SELECT * FROM fn_content_1 LEFT JOIN fn_content_1_industries ON `fn_content_1`.`id`=`fn_content_1_industries`.`id` WHERE `fn_content_1`.`status`=1 AND (`fn_content_1`.`catid`=23) AND `fn_content_1_industries`.`type`=4 ORDER BY `fn_content_1`.`updatetime` DESC LIMIT 0,5