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 ;