SELECT CONCAT(d.last_name, ', ', d.first_name) as "Patient",
m.demographicNo, m.dataField as "{name} > {min}", me.val as "Name",
m.dateObserved
FROM measurementsExt me, measurements m
LEFT JOIN demographic d ON d.demographic_no = m.demographicNo
WHERE keyval = 'name'
AND val LIKE '%{name}%'
AND m.id = me.measurement_id
AND m.dataField >{min}
AND m.dateObserved >((PERIOD_ADD(EXTRACT(YEAR_MONTH FROM
CURDATE()),-{months})*100)+1)
ORDER BY m.demographicNo, m.dateObserved;
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;