SELECT `a`.`id`,`a`.`companyname`,`a`.`logo`,`a`.`district1`,`a`.`district2`,`a`.`district3`,`a`.`district`,`a`.`scale`,`a`.`nature`,`a`.`trade`,`a`.`audit`,`a`.`setmeal_id`,b.deadline as setmeal_deadline,`a`.`click` FROM `qs_company` `a` LEFT JOIN `qs_member_setmeal` `b` ON `a`.`uid`=`b`.`uid` LEFT JOIN `qs_job_search_rtime` `c` ON `a`.`uid`=`c`.`uid` WHERE  `c`.`id` IS NOT NULL  AND `a`.`district1` > 0  AND `a`.`is_display` = 1 GROUP BY `a`.`id` ORDER BY `a`.`id` DESC LIMIT 708,12