[ SQL ] SELECT `p`.*,cp.id as cid FROM `mnzx_portal_post` `p` INNER JOIN `mnzx_portal_category_post` `pc` ON `p`.`id`=`pc`.`post_id` INNER JOIN `mnzx_portal_category` `cp` ON `cp`.`id`=`pc`.`category_id` WHERE `pc`.`category_id` = 1 AND `p`.`delete_time` = 0 AND `p`.`post_status` = 1 ORDER BY `p`.`is_top` DESC,`p`.`create_time` DESC LIMIT 0,15 [ RunTime:0.001803s ]