Александр Литвинов

SELECT `t1`.`id`, `t1`.`name`, COUNT(`t2`.`id`) AS cnt 
FROM `table` as `t1`
LEFT JOIN `table` `t2` ON `t1`.`id` = `t2`.`ref_id`
WHERE (`t1`.`param1` + `t1`.`param2` + `t1`.`param3`) > 5 
GROUP BY `t1`.`id`
ORDER BY cnt DESC

SELECT `t1`.`id`, `t1`.`name`, COUNT(`t2`.`id`) AS cnt 
FROM `table` as `t1` 
LEFT JOIN `table` `t2` ON `t1`.`id` = `t2`.`ref_id` 
AND (`t2`.`param1` + `t2`.`param2` + `t2`.`param3`) > 5 
WHERE (`t1`.`param1` + `t1`.`param2` + `t1`.`param3`) > 5 
GROUP BY `t1`.`id` ORDER BY cnt DESC

UPDATE `wp_posts`  SET `post_status`='publish' WHERE `id` in (SELECT DISTINCT `post_id` as `id` FROM `wp_postmeta` WHERE `meta_value` LIKE '%letitbit.net%')