左连接查询

select * from (SELECT DISTINCT(a.id) as nid,a.*,b.usid,d.name as mername,e.name as lname from eb_user_saler a LEFT JOIN eb_merchant d on a.mid = d.id LEFT JOIN eb_level_fee e on a.lfid = e.id LEFT JOIN eb_account_user_saler_income as b ON a.id = b.usid and b.addtime between 1514095328 and 1516687328 ) c where c.usid is null