包含全部： SELECT u.id,u.user_name,usa.fixed_amount,d.uloadtype,d.min_loan_money FROM fanwe_user_autobid usa LEFT JOIN fanwe_user u ON u.id=usa.user_id LEFT JOIN fanwe_deal d ON d.id=1620 LEFT JOIN fanwe_user du ON du.id = d.user_id WHERE (usa.fixed_amount >=d.min_loan_money or d.min_loan_money = 0) AND (usa.fixed_amount <= d.max_loan_money or d.max_loan_money = 0) AND usa.fixed_amount <= d.borrow_amount*0.2 AND usa.is_effect = 1 AND (1482777186 between usa.min_time and usa.max_time) AND (d.rate between usa.min_rate AND usa.max_rate) AND (d.repay_time between usa.min_period AND usa.max_period) AND usa.user_id not in (SELECT user_id FROM fanwe_deal_load WHERE deal_id=1620) and usa.user_id <>d.user_id AND usa.fixed_amount < (d.borrow_amount - d.load_money) AND FIND_IN_SET(d.cate_id,usa.deal_cates) GROUP BY usa.user_id ORDER BY usa.last_bid_time ASC