WHERE `created` > CURDATE()
SELECT *
FROM `entity`
WHERE `entity_id` >= 0 AND `entity_id` >= 100SELECT `i`.`id`, `i`.`name`, `i`.`color`, `p`.`name_file_jpg`
FROM `item` AS `i`
LEFT JOIN (
SELECT `id_item`, MIN(`id`) AS `min`
FROM `photo`
GROP BY `id_item`
) AS `m` ON `m`.`id_item` = `i`.`id`
LEFT JOIN `photo` AS `p` ON `p`.`id` = `m`.`min`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())select `r`.`id` as `req`, `ss`.`user_id` as `user`, `ss`.`created_at` as `date`
from (
select `user_id`, min(`created_at`) as `min_date`
from `seo_source`
group by `user_id`
) as ss
right join `seo_user_request` as `su` on `su`.`user_id` = `ss`.`user_id`
left join `request` as `r` on `r`.`id` = `su`.`request_id`UPDATE `product`
SET `description` = CONCAT(SUBSTRING_INDEX(`description`, '(', 1), SUBSTRING_INDEX(`description`, ')', -1))
WHERE `description` LIKE '%(%)%'SELECT `b`.`id` AS `bot_id`, IFNULL(`c`.`count`, 0) AS `total`
FROM (
SELECT `bot_id`, COUNT(*) AS `count`
FROM `items`
GROUP BY `bot_id`
) AS `c`
RIGHT JOIN `bots` AS `b` ON `b`.`id` = `c`.`bot_id`
ORDER BY `total`