Rsa97

SELECT * 
  FROM `entity`
  WHERE `entity_id` >= 0 AND `entity_id` >= 100

WHERE `date` >= CURDATE() - INTERVAL 1 DAY AND `date` < CURDATE()

echo "Max: ".implode(', ', array_map(function($i) { return chr(ord('a')+$i); },
                                     array_keys(array($a, $b, $c, $d), $max)));

DELETE `t1`.*
  FROM `table` AS `t1`
  JOIN `table` AS `t2` ON `t2`.`name` = `t1`.`name`

SELECT DISTINCT `OFFNAME` 
  FROM `ADDROBJ`
  WHERE SHORTNAME IN ('г', 'обл', 'Чувашия', 'АО', 'Аобл', 'край', 'округ', 'Респ', 'п', 'р-н', 'дп', 'кп', 'пгт', 'рп', 'с/о', 'с/п', 'городок', 'гп', 'д', 'дп', 'нп', 'остров', 'с', 'ст-ца', 'х', 'сад')

(SELECT ...
  FROM `table` 
  WHERE `date` < NOW()
  ORDER BY `date` DESC
  LIMIT 1)
UNION (SELECT ...
  FROM `table` 
  WHERE `date` >= NOW())