联系我们

SELECT sum(t1.hit) hit,t2.tid,t2.title,t2.image,t2.url,t3.name FROM king_forum_topic_hit t1 LEFT OUTER JOIN (king_forum_topic t2,king_forum_board t3) ON t1.tid=t2.tid AND t2.bid=t3.bid WHERE t2.status=1 and t2.isimage=1 and t1.today>=20220626 GROUP BY t1.tid ORDER BY hit desc LIMIT 4