一条sql

包含全部：

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

 

转载于:https://www.cnblogs.com/hnbiao/p/6225123.html