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;