SELECT {drug_query}; High dose opioids (MME calculated) All opioids (MME not calculated) All select provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider where status='1' AND provider_type = 'doctor' AND ohip_no>1 AND ohip_no!= 123456 order by last_name, first_name, provider_no;