SELECT "1 month" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=1 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} UNION SELECT "3 monthS" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=3 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} UNION SELECT "5 months" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=5 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} UNION SELECT "11 months" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=11 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} UNION SELECT "14 months" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=14 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} UNION SELECT "17 months" as age, CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)) as dob, CONCAT( "/", d.demographic_no, "/" ) as dem,d.`last_name` as last,d.`first_name`as first,d.`city`,d.`phone`,CONCAT(`roster_status`,"-",`patient_status`) as status, CONCAT(p.last_name, ', ', p.first_name, ' (', d.provider_no, ')') as provider from demographic d, provider p WHERE (((YEAR(CURRENT_DATE) - 1) * 12 + MONTH(CURRENT_DATE)) - ((YEAR(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth))) - 1) * 12 + MONTH(CONCAT((d.year_of_birth), '-', (d.month_of_birth), '-', (d.date_of_birth)))))=17 AND d.patient_status="AC" AND d.roster_status IN ("RO","NR","QU") AND d.provider_no=p.provider_no AND p.`provider_no` LIKE {provider_no} ; select "'%'" as provider_no, 'all providers' as provider union select "'1__'" as provider_no, 'all Haileybury doctors' as provider union select provider_no, CONCAT(last_name, ', ', first_name, ' (', provider_no, ')') as provider from provider where status='1' ;