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 a LEFT JOIN ts_checkin b on a.id=b.cid and b.uid=8 where a.authorid=2