SELECT CONCAT( "", demographic_no, "" ) AS DemoLink, last_name as Surname, first_name as First, phone, Age, Result
FROM (SELECT demographic.demographic_no,`last_name`,`first_name`,`phone`, YEAR(DATE(CONCAT(YEAR(CURDATE()),'-10-01')))-demographic.year_of_birth-(DATE_FORMAT(DATE(CONCAT(YEAR(CURDATE()),'-10-01')),'00-%m-%d') 'D'
AND billing_on_item.service_date BETWEEN DATE(CONCAT(YEAR(CURDATE()),'-09-20')) AND NOW()
) AS Item
WHERE billing_on_cheader1.id = Item.ch1_id
AND billing_on_cheader1.status <> 'D'
UNION
SELECT appointment.demographic_no AS demo_no,
appointment.`appointment_date` AS Result
FROM appointment
WHERE appointment_date > NOW()
AND INSTR(appointment.reason,'flu')>1
) AS temp
GROUP BY demo_no
) As Flu_Shot
ON Flu_Shot.demo_no = Patient.demographic_no
order by surname
;
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;