Generated SQL: SELECT `SQL_CALC_FOUND_ROWS` `web_school_news`.`id`, `web_school_news`.`add_time`, `web_school_news`.`title`, `web_school_news`.`seo_desc`, `web_school_news`.`orig`, `web_school_news`.`img`, `b`.`shortname`, `a`.`name`
FROM `web_school_news`
LEFT JOIN `web_school` as `b` ON `web_school_news`.`school_id` = `b`.`id`
LEFT JOIN `web_category` as `a` ON `web_school_news`.`cate_id` = `a`.`id`
WHERE `school_cate` = "teacher" and `web_school_news`.`status` = 1 and `school_id` = 1682
ORDER BY `add_time` DESC