SELECT * FROM ( (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "571 Chronic Liver Disease", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('571','5710','5711','5712','5713','5714','5715','5716','5718','5719') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('571','5710','5711','5712','5713','5714','5715','5716','5718','5719') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "340 Multiple Sclerosis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('340') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('340') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "304 Drug Dependence", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('304') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('304') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "725 PMR", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('725') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('725') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "188 Ca Bladder", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('188') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('188') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "332 Parkinsons", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('332') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('332') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "5569 Ulcerative colitis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('556','5569') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('556','5569') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "042 HIV", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('042') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('042') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "59651 OAB", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('59651','5965') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('59651','5965') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "00845 CDiff", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('00845') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('00845') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "185 Ca Prostate", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('185') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('185') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "73300 Osteoporosis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('7330','73300','73301','73302','73303','73309') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('7330','73300','73301','73302','73303','73309') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "208 Leukemia", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('208','2080','2081','2082','2088','2089') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('208','2080','2081','2082','2088','2089') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "20280 Lymphoma", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('20280','2028','20281','20282','20283','20284','20285','20286','20287','20288') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('20280','2028','20281','20282','20283','20284','20285','20286','20287','20288') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "193 Ca Thyroid", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('193') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('193') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1869 Ca Testicle", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1869','186') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1869','186') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1830 Ca Ovary", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1830') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1830') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1890 Ca Renal", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1890','1891') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1890','1891') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1749 Ca Breast", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1749','174','1740','1741','1742','1743','1744','1745','1746','1747','1748') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1749','174','1740','1741','1742','1743','1744','1745','1746','1747','1748') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1629 Ca Lung", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1629','162','1620','1622','1623','1624','1625','1628') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1629','162','1620','1622','1623','1624','1625','1628') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "1539 Ca Colon", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('1539','153','1531','1532','1533','1534','1535','1536','1537','1538') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('1539','153','1531','1532','1533','1534','1535','1536','1537','1538') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "29680 Bipolar disorder", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('29680','2960','29600','29601','29602','29603','29604','29605','29606','2961','2964','2965','2966','2967','2968','2969') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('29680','2960','29600','29601','29602','29603','29604','29605','29606','2961','2964','2965','2966','2967','2968','2969') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "295 Schizophrenia", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('295','2950','29500','29501','29502','29503','29504','29505','2952','2953','2959','2955','2956','2957','2958','2959') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('295','2950','29500','29501','29502','29503','29504','29505','2952','2953','2959','2955','2956','2957','2958','2959') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "346 Migraine", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('346','3460','3461','3462','3468','3469') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('346','3460','3461','3462','3468','3469') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "78057 OSA", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('78057') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('78057') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "2429 Hyperthyroid", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('2429','24290','24291') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('2429','24290','24291') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "7200 Ankylosing spondilitis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('7200') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('7200') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "274 Gout", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('274','2740','2748','27489','2749') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('274','2740','2748','27489','2749') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "7291 Fibromyalgia", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('7291') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('7291') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "6960 Psoriatic arthritis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('6960') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('6960') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "6961 Psoriasis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('6961','696') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('6961','696') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "7140 Rheumatoid Arthritis", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('7140','7142') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('7140','7142') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "27800 Obesity", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('278','2780','27800','27801') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('278','2780','27800','27801') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "07054 Hep C", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('07054','07051') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('07054','07051') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "493 Asthma", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('493','4930','49301','49302','4931','49311','49312','4939','49391','49392') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('493','4930','49301','49302','4931','49311','49312','4939','49391','49392') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "2449 Hypothyroid", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('244','2440','2441','2442','2443','2444','2448','2449') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('244','2440','2441','2442','2443','2444','2448','2449') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "3382 PAIN", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('3382','3384','3078','2938') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('3382','3384','3078','2938') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "585 CKD", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('585') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('585') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "303 Alcohol dependence", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('303') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('303') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "311 Depression", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('311','2963','2962') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('311','2963','2962') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "2900 Dementia", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('3310','290','2900','2901','2902','2903','2909','29010','2904','2912','29282','2941','29410','29411') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('3310','290','2900','2901','2902','2903','2909','29010','2904','2912','29282','2941','29410','29411') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "7159 OA", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('715','7150','71500','7159') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('715','7150','71500','7159') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "414 IHD", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('414','4140','41400','41401','41402','41403','41404','41405') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('414','4140','41400','41401','41402','41403','41404','41405') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "3000 Anxiety", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('300','3000','30001','30002') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('300','3000','30001','30002') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "436 CVA", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('433','434','435','436','437','438') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('433','434','435','436','437','438') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "V66 EOL", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('V66') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('V66') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "V15 Frailty", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('V15') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('V15') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "428 CHF", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('428','4280','4281','4289') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('428','4280','4281','4289') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "401 HBP", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('401','4011','4019') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('401','4011','4019') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "250 DM", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('250','2500','2504','2505','2506','2507','2508','2509') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('250','2500','2504','2505','2506','2507','2508','2509') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "496 COPD", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('496','491','492','494','497','498') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('496','491','492','494','497','498') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "42731 Afib", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('42731','4273') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('42731','4273') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) UNION ALL (SELECT demo.last_name AS Name, demo.first_name, CONCAT( "", "5559 Crohns", "" ) AS "Dx Registry", CONCAT( "", "eChart", "" ) AS "eChart" FROM billingmaster bm,demographic demo WHERE demo.provider_no = '{provider_no}' AND bm.dx_code1 in ('555','5559') AND demo.patient_status = 'AC' AND bm.service_date > ((CURDATE() + 0)- {num}0000) AND demo.demographic_no = bm.demographic_no AND demo.demographic_no NOT IN (select dx.demographic_no from dxresearch dx where dx.dxresearch_code in ('555','5559') and dx.demographic_no = demo.demographic_no) GROUP BY demo.last_name,demo.first_name ) ) a ORDER BY Name; select provider_no,concat(last_name,',',first_name,'(',provider_no,')') from provider where status='1' and provider_type='doctor' and ohip_no>1 order by provider_no; SELECT "1" AS yr, '1 years' AS typeDisplayName UNION SELECT "2" AS yr, '2 year' AS typeDisplayName UNION SELECT "3" AS yr, '3 years' AS typeDisplayName UNION SELECT "4" AS yr, '4 years' AS typeDisplayName UNION SELECT "5" AS yr, '5 years' AS typeDisplayName UNION SELECT "6" AS yr, '6 years' AS typeDisplayName UNION SELECT "7" AS yr, '7 years' AS typeDisplayName UNION SELECT "8" AS yr, '8 years' AS typeDisplayName UNION SELECT "9" AS yr, '9 years' AS typeDisplayName UNION SELECT "10" AS yr, '10 years' AS typeDisplayName