ld-portal | 4440 | sql

SELECT
cdrd.*,
ud.`name`,
ud.`stage`
FROM
(SELECT
cd.`consultation_id`,
cd.`consultation_name`,
cd.`venue_name`,
cd.`nearest_station`,
cd.`event_date`,
rd.`user_id`,
rd.`over_time`,
rd.`fare`
FROM
consultation_data cd
LEFT JOIN
report_data rd
ON
cd.`consultation_id`=rd.`cm_id`
WHERE
cd.`event_date` >= '2016/12/20'
AND
cd.`event_date`<= '2019/12/20'
AND
cd.`property_id` = 1
ORDER BY
cd.`consultation_id`
) cdrd
LEFT JOIN
user_data ud
ON
cdrd.user_id=ud.user_id
ORDER BY
cdrd.consultation_id