SELECT
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)= '{FromDate}'
AND form_date <= '{ToDate}'
) as ed
ON ed.demographic_no = d.demographic_no
WHERE
d.patient_status = 'AC' and
d.provider_no LIKE '{provider_no}' and
ed.demographic_no IS NULL
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 ;