21,893
社区成员




(SELECT max(id) FROM `ts_checkin` GROUP BY cid)
(SELECT * FROM `ts_checkin` WHERE id IN (SELECT max(id) FROM `ts_checkin` GROUP BY cid))
select `a`.`id`,`a`.`sourcename`,`a`.`authorid`, b.id AS b__id,b.uid AS b__uid,b.cid AS b__cid from `ts_wffiles` AS a LEFT JOIN (SELECT * FROM `ts_checkin` WHERE id IN (SELECT max(id) FROM `ts_checkin` GROUP BY cid)) AS b on a.id=b.cid where a.authorid=8 GROUP BY id order by id desc