飞闪网

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