SELECT DISTINCT a.*,c.slug,c.name FROM saas_posts a LEFT JOIN saas_term_relationships as b on b.object_id= a.id LEFT JOIN saas_terms as c on c.id= b.term_taxonomy_id WHERE a.status <> 'trash' AND a.delay = 0 AND `type` = 'post' ORDER BY a.createtime desc LIMIT 0,15
在线预约享受建站8折