SELECT c.* FROM mos_content_cn as c LEFT JOIN mos_content AS cen ON c.id = cen.id WHERE c.access<='0' AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2020-04-09 05:24:13' ) AND c.sectionid=7 AND c.state='1' AND c.publish_up <= '2020-04-09 05:24:13' AND cen.editors_pick='1' ORDER BY c.publish_up DESC, c.newordering ASC