mysql 每天每个客户第一个报告

每天每个客户第一个报告

SELECT r.id,r.pay,r.customer_id, r.createTime
FROM jl_checkreport r
LEFT JOIN dowell_project p ON p.id=r.customer_id
WHERE DATE_FORMAT(r.createTime,'%Y-%m-%d')='2017-05-05' AND r.reportType='report' and p.firstOrderDate is not null AND 
r.id=(
SELECT rr.id
FROM jl_checkreport rr
WHERE 
rr.customer_id=r.customer_id AND rr.reportType='report' AND DATE_FORMAT(rr.createTime,'%Y-%m-%d')= DATE_FORMAT(r.createTime,'%Y-%m-%d')
ORDER BY rr.createTime ASC
LIMIT 1)