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;