select distinct
CONCAT( "/", d.demographic_no, "/" ) AS "Demo",
CONCAT(d.last_name,', ', d.first_name) as demographic,
(YEAR(CURRENT_DATE)-YEAR(DATE_FORMAT(CONCAT((d.year_of_birth),'-',(d.month_of_birth),'-',(d.date_of_birth)),'%Y-%m-%d')))-(RIGHT(CURRENT_DATE,5)ED.fdid
where
dx.dxresearch_code = '{searchtext}' and
d.patient_status = 'AC' and
d.provider_no LIKE '{provider_no}' and
dx.status = 'A' and
dx.demographic_no = d.demographic_no and
ED.form_date>='{FromDate}' AND
ED.form_date<='{ToDate}' AND
M.fdid IS NULL AND
ED.demographic_no=d.demographic_no AND
ED.fid = '{eform_id}' AND
ED.status=1 AND
ED.fdid=EV.fdid AND
ED.fid=EV.fid
GROUP BY d.demographic_no
order by d.last_name, d.first_name;
SELECT '%' AS provider_no, 'all providers' AS provider
UNION
SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider
WHERE status='1'
AND provider_type='doctor'
AND ohip_no>1
ORDER BY provider_no;
SELECT
fid,
form_name
FROM eform
WHERE status= "1"
ORDER BY
form_name ;