[ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id`,`u`.`user_login`,`u`.`user_nickname`,`u`.`user_email` FROM `cmf_portal_postcase` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_gccase_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= '0' AND `a`.`delete_time` = '0' AND ( `b`.`category_id` = '41' AND `a`.`post_type` = '1' ) ORDER BY `a`.`list_order` DESC LIMIT 0,10 [ RunTime:0.000770s ]