[ SQL ] SELECT p.id as id,p.thumbnail as thumb,p.post_title as title FROM `cmf_portal_category_post` `a` INNER JOIN `cmf_portal_post` `p` ON `a`.`post_id`=`p`.`id` WHERE `a`.`category_id` = '14' AND ( p.post_status=1 and a.status=1 ) ORDER BY `p`.`published_time` DESC,`p`.`recommended` DESC,`p`.`id` DESC LIMIT 0,9 [ RunTime:0.001826s ]
