SELECT ANY_VALUE(`name`), MIN(`score`) FROM `tab`
SELECT DISTINCT `user_id`
FROM `ticket`
WHERE `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 2)
AND `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 3)
AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 1)
AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 4)
SELECT `c`.`id`, `c`.`name`, `s`.`score`
FROM (
SELECT `cp`.`id_clan` AS `id_clan`,
SUM(`uc`.`health`) + SUM(`uc`.`power`)
+ SUM(`uc`.`agil`) + SUM(`uc`.`intell`) AS `score`
FROM `clan_part` AS `cp`
JOIN `users_combat` AS `uc` ON `uc`.`id_user` = `cp`.`id_user`
GROUP BY `cp`.`id_clan`
ORDER BY `score` DESC
LIMIT 0, 10
) AS `s`
JOIN `clan` AS `c` ON `c`.`id` = `s`.`id_clan`
start2 > end1 || start2 > end1
~(start2 > end1 || start2 > end1) =
= ~(start2 > end1) && ~(start2 > end1) =
= start2 <= end1 && start2 <= end1
SELECT `p`.`product_id`, `p2s`.`price`
FROM `product` AS `p`
JOIN (
SELECT `product_id`, MIN(`price`) AS `min_price`
FROM `product_to_supplier`
WHERE `price` > 0 AND `quantity` > 0
GROUP BY `product_id`
) AS `p2s` ON `p2s`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW()
AND `p`.`manufacturer_id` = '5011'
ORDER BY `p`.`sort_order` ASC, LCASE(`p`.`name`) ASC
LIMIT 0,15
SELECT *
FROM `messages`
WHERE `id_add` = :doctorId AND `id_to` = :patientId
UNION SELECT *
FROM `messages`
WHERE `id_add_pac` = :patientId AND `id_to_pac` = :doctorId
SELECT `d`.`datetime`, COUNT(`th`.`create_time`) AS `count`
FROM (
SELECT DISTINCT DATE(`create_time`) + INTERVAL 22 HOUR AS `datetime`
FROM `tick`
) AS `d`
LEFT JOIN `tick_history` AS `th`
ON `th`.`create_time` < `d`.`datetime`
AND `th`.`state` NOT IN (1, 4, 9)
AND `th`.`queue` = 1
GROUP BY `d`.`datetime`