(select distinct d.demographic_no Demographic, d.sex Sex, floor(datediff(curdate(),str_to_date(concat(d.year_of_birth,d.month_of_birth,d.date_of_birth),'%Y%m %d'))/365.25) Age, concat(d.last_name, ', ', d.first_name) Patient, concat (p.last_name, ', ', p.first_name) MRP, '' as Registry, dr.BN as 'Drug Name', '' as 'Billing Code' FROM drugs dr, demographic d, provider p WHERE d.demographic_no = dr.demographic_no AND d.patient_status = 'AC' AND floor(datediff(curdate(),str_to_date(concat(d.year_of_birth,d.month_of_birth,d.date_of_birth),'%Y%m%d'))/365.25) >=35 AND d.provider_no = p.provider_no AND (dr.BN like '%Tiotropium%' or dr.BN like '%Ipratropium%' or dr.BN like '%Spiriva%' or dr.BN like '%Atrovent%')) UNION (select distinct d.demographic_no Demographic, d.sex Sex, floor(datediff(curdate(),str_to_date(concat(d.year_of_birth,d.month_of_birth,d.date_of_birth),'%Y%m %d'))/365.25) Age, concat(d.last_name, ', ', d.first_name) Patient, concat(p.last_name, ', ', p.first_name) MRP, dx.dxresearch_code as Registry, '', concat(bi.dx, ' ', bi.dx1, ' ', bi.dx2) as 'Billing Code' from billing_on_cheader1 bch, billing_on_item bi, demographic d, provider p, dxresearch dx where bch.id = bi.ch1_id AND (bi.dx = '490' or bi.dx1 = '490' or bi.dx2 = '490' or bi.dx = '491' or bi.dx1 = '491' or bi.dx2 = '491' or bi.dx = '492' or bi.dx1 = '492' or bi.dx2 = '492' or bi.dx = '494' or bi.dx1 = '494' or bi.dx2 = '494' or bi.dx = '496' or bi.dx1 = '496' or bi.dx2 = '496' or dx.dxresearch_code ="490" or dx.dxresearch_code ="491" or dx.dxresearch_code ="492" or dx.dxresearch_code ="494" or dx.dxresearch_code ="496") AND dx.dxresearch_code <>"493" AND bch.demographic_no = d.demographic_no AND d.demographic_no = dx.demographic_no AND d.patient_status = 'AC' AND d.provider_no = p.provider_no) order by MRP, Patient;