/* 3.14.6.194 */ SELECT SQL_NO_CACHE id, title, description, category_id, city_id, address, phone, email, url, messenger, img, your_name, delete_pass, unix_time, ip, info_new, ref, marked, premium, fixed FROM `boplusuz_ads` AS A RIGHT JOIN ( SELECT aid FROM ( SELECT * FROM ( SELECT SQL_SMALL_RESULT adv_id as aid, unix_time, info_new, CASE WHEN premium >= 1715324449 THEN premium ELSE 0 END as pr, sum(weight) as wi FROM `boplusuz_adswordindex` LEFT JOIN `boplusuz_ads` ON `boplusuz_ads`.id = adv_id WHERE ((dict_id = 0 AND word_id = 17094) OR (dict_id = 0 AND word_id = 329755) OR (dict_id = 0 AND word_id = 593869)) AND (city_id = 10 OR city_id = -1) AND info_new = 0 GROUP BY adv_id ORDER BY wi DESC, unix_time DESC LIMIT 200 ) AS BASETBL1 ORDER BY pr DESC, wi DESC, unix_time DESC LIMIT 100 ) AS BASETBL2 LIMIT 0, 10 ) AS LST ON A.id = LST.aid Server shutdown in progress