SELECT provider.last_name as 'Doctor', demographic.last_name as
'Surname', demographic.first_name as 'Given', measurements.type,
measurements.dataField as 'Value', DATE(measurements.dateObserved) as
'Date', demographic.phone as 'Home', demographic.phone2 as 'Work',
demographic.HIN FROM measurements
JOIN demographic ON measurements.demographicNo = demographic.demographic_no
JOIN measurementsExt ON measurements.id = measurementsExt.measurement_id
JOIN provider ON demographic.provider_no = provider.provider_no
WHERE measurements.dateObserved >= DATE_SUB(CURDATE(), INTERVAL {days} DAY) AND
(measurementsExt.val = '2165' OR measurementsExt.val = '6301-6')
ORDER by demographic.provider_no, demographic.last_name, dateEntered;