SELECT `n`.`id`, IFNULL(`c`.`count`, 0)
FROM `news` AS `n`
LEFT JOIN (
SELECT `news_id`, COUNT(*) AS `count`
FROM `like`
WHERE `date` > date_sub(NOW(), INTERVAL 7 day)
GROUP BY `news_id`
) AS `c` ON `c`.`news_id` = `n`.`id`
ORDER BY `c`.`count` DESC
LIMIT 100SELECT `news_id`, COUNT(*) AS `count`
FROM `like`
WHERE `date` > date_sub(NOW(), INTERVAL 7 day)
GROUP BY `news_id`
ORDER BY `count` DESC
LIMIT 100АВСЕКМНОРСТХаеорсу
ABCEKMHOPCTXaeopcySELECT `objid`
FROM `table`
GROUP BY `objid`
HAVING MAX(`status`) = 0SELECT DISTINCT `t1`.`objid`
FROM `table` AS `t1`
LEFT JOIN (
SELECT DISTINCT `objid`
FROM `table`
WHERE `status` = 1
) AS `t2` USING(`objid`)
WHERE `t2`.`objid` IS NULLUPDATE `prices` AS `prc`
JOIN (
SELECT `prd`.`parent_id` AS `product_id`, MIN(`prc`.`price`) AS `price`
FROM `products` AS `prd`
JOIN `prices` AS `prc` ON `prc`.`product_id` = `prd`.`product_id`
GROUP BY `prd`.`parent_id`
) AS `min` ON `min`.`product_id` = `prc`.`product_id`
SET `prc`.`price` = `min`.`price`