SELECT i.*,a.* FROM internal as i LEFT JOIN praise as a on a.userid=i.userid WHERE i.`group`=101 and(a.tid is null or a.tid !=20);