SELECT concat( p.first_name, ' ', p.last_name ) AS "Provider", count( DISTINCT demo.last_name, demo.first_name ) "# PFT's in 2yr" FROM hl7TextInfo h, demographic demo, dxresearch dx, provider p WHERE h.discipline = "Respiratory" AND DATEDIFF( CURDATE( ) , h.obr_date ) <365 *2 AND dx.dxresearch_code IN ('491', '496') AND demo.patient_status = 'AC' AND demo.roster_status NOT IN ('TE-terminated', 'transient') AND dx.status = 'A' AND h.health_no = demo.hin AND dx.demographic_no = demo.demographic_no AND p.provider_no = demo.provider_no GROUP BY p.first_name ORDER BY p.provider_no LIMIT 0 , 20