发布时间:2019-11-27 15:00 发布者:飞闪网 浏览数:0









SELECT t1.tid,t2.id,t2.title,t2.url,t2.date,t3.id FROM king_content_tag_bind t1 LEFT OUTER JOIN (king_content t2,king_content_tag_bind t3) ON t2.id=t3.id WHERE t2.mid=1 and t2.status=1 and t1.id=803 and t3.tid=t1.tid and t2.id<>803 GROUP BY t2.id desc LIMIT 8
SELECT t1.title,t1.url,t1.image,t2.cid,t4.tu FROM king_content t1 LEFT OUTER JOIN (king_content_categroy_bind t2,king_content_categroy t3,king_content__case t4) ON t1.id=t2.id and t2.cid=t3.cid and t2.id=t4.id WHERE t1.mid=2 and t1.status=1 and t3.cid1=22 GROUP BY t1.hit desc LIMIT 10
公众号
飞闪网微信公众号
企业微信
飞闪助手君¹企微