select * from directory where status=0 and is_archived=0 AND ( id IN (138) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (138) ) ORDER BY first_name ASC
ACUPUNCTURE
- Xiaoping Xu, MD, PhD
- Midwest Medicine & Acupuncture, SC
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (25,26,36,41,42,43,44,52,61,83,113,100,168,112) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (25,26,36,41,42,43,44,52,61,83,113,100,168,112) ) ORDER BY first_name ASC
ALLERGY
- Diane L. Ozog, MD
- Dr. Diane Ozog & Associates
-
Naperville
- View Details
- Mark C. Jacobson, MD
- Allergy & Asthma Physicians
-
Hinsdale
- View Details
- Priya Bansal, MD
- Asthma and Allergy Wellness Center
-
Saint Charles
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (133,152) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (133,152) ) ORDER BY first_name ASC
ANESTHESIOLOGY
- Marco Fernandez, MD
- Midwest Anesthesia Partners, LLC
-
Naperville
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (155,258) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (155,258) ) ORDER BY first_name ASC
ARTHRITIS
- John Berry, DO
- Arnold Arthritis & Rheumatology
-
Skokie
- View Details
- Veena Nayak, MD
- Southland Rheumatology Center
-
Willowbrook , Olympia Fields
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (113,162,100,168,112) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (113,162,100,168,112) ) ORDER BY first_name ASC
ASTHMA
- Diane L. Ozog, MD
- Dr. Diane Ozog & Associates
-
Naperville
- View Details
- Mark C. Jacobson, MD
- Allergy & Asthma Physicians
-
Hinsdale
- View Details
- Patricia S. Mikes, MD, MBA, FCCP
- University Affiliated Physicians
-
Hinsdale, Palos Heights
- View Details
- Priya Bansal, MD
- Asthma and Allergy Wellness Center
-
Saint Charles
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (151,149,102,99) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (35) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (35) ) ORDER BY first_name ASC
BLOOD DISEASE SPECIALIST
- Srilata Gundala, MD
- Hope & Healing Cancer Services
-
Hinsdale, New Lenox
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (35) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (35) ) ORDER BY first_name ASC
CANCER
- Srilata Gundala, MD
- Hope & Healing Cancer Services
-
Hinsdale, New Lenox
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (135,263) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (135,263) ) ORDER BY first_name ASC
CHIROPRACTIC
- Glen Batson, DC
- Batson Chiropractic Clinic
-
Willowbrook
- View Details
- Kara Babinski, DC
- BodyWorks Medical Center
-
Carol Stream, St. Charles, West Dundee
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (149,103) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (57,116,156,31,176,265) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (57,116,156,31,176,265) ) ORDER BY first_name ASC
DERMATOLOGY
- Laurence M. Bradley, Jr., MD, FAAD
- Legacy Dermatology
- View Details
- Shelley Halper, MD, FAAD, ASDS
- Dermatology Associates of La Grange
-
La Grange
- View Details
- Vikram Khanna, MD
- Dermatology Specialists of Illinois
-
Algonquin, Woodstock, Lake Barrington, Huntley
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (25,26,36,43,45,70,76,69,75,144,119,147,3) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (25,26,36,43,45,70,76,69,75,144,119,147,3) ) ORDER BY first_name ASC
EAR, NOSE AND THROAT
- Regina Walker, MD
- Regina Paloyan Walker, M.D.
-
Western Springs
- View Details
- Samuel J. Girgis, MD, FACS
- Drs. Girgis and Associates
-
Hinsdale, Oak Park, La Grange
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (146) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (146) ) ORDER BY first_name ASC
ENDOCRINOLOGY
- Hong Lee, MD
- Diabetes & Endocrinology Group
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (89,114,149) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (25,26,36,64,46,82,84,110,143,118,49,90,150,71,39,88,5) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (25,26,36,64,46,82,84,110,143,118,49,90,150,71,39,88,5) ) ORDER BY first_name ASC
FAMILY MEDICINE
- Daniel Chen, DO
- Family Medical Center of La Grange
-
La Grange
- View Details
- Ingrid Liu, DO
- Progressive Health Primary Care, PLLC
-
Oak Park
- View Details
- Iram Shaikh-Abbasi, MD, FAAFP
- Lifetime Family Healthcare
-
Clarendon Hills
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (81,108,89,114,106,92) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (25,26,63,149,102,99,103,97,101) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (154) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (154) ) ORDER BY first_name ASC
GENETICS
- Scott Weissman, MS, CGC
- Chicago Genetic Consultants, LLC
-
Northbrook
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (130,20) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (130,20) ) ORDER BY first_name ASC
GERIATRICS
- Gerald Simon, MD
- Adult Medicine Physicians
-
Downers Grove, Countryside
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (262,121) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (262,121) ) ORDER BY first_name ASC
GYNECOLOGY
- Adam Ramsey, MD
- Hinsdale and Oak Brook Women's Clinic
-
Willowbrook
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (89,114,106,92) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (58,177,171) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (58,177,171) ) ORDER BY first_name ASC
HOME HEALTH
- Vera Filimonov
- Accurate Private Care, Inc.
-
Deerfield
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (113,100,112) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (113,100,112) ) ORDER BY first_name ASC
IMMUNOLOGY
- Diane L. Ozog, MD
- Dr. Diane Ozog & Associates
-
Naperville
- View Details
- Mark C. Jacobson, MD
- Allergy & Asthma Physicians
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (139) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (138,263) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (138,263) ) ORDER BY first_name ASC
INTEGRATIVE MEDICINE
- Kara Babinski, DC
- BodyWorks Medical Center
-
Carol Stream, St. Charles, West Dundee
- View Details
- Xiaoping Xu, MD, PhD
- Midwest Medicine & Acupuncture, SC
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (79,85,136,34,55,65,120,122,20,175,173,167,165,261) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (79,85,136,34,55,65,120,122,20,175,173,167,165,261) ) ORDER BY first_name ASC
INTERNAL MEDICINE
- Cynthia Lagone, MD, FACP
- Authentic Internal Medicine
-
Westmont
- View Details
- Gerald Simon, MD
- Adult Medicine Physicians
-
Downers Grove, Countryside
- View Details
- Helene M. Ruiz-Pla, MD
- Helene M. Ruiz-Pla, MD, SC
-
Melrose Park
- View Details
- Prabhu Shivalingappa, MD
- Dupage Internal Medicine of IL, LLC
-
Hinsdale
- View Details
- Veena Prabhu, MD
- Dupage Internal Medicine of IL, LLC
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (33,142,174,260) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (33,142,174,260) ) ORDER BY first_name ASC
INTERVENTIONAL RADIOLOGY
- Angelo N. Makris, MD
- MakrisMD Vascular Center
-
Westmont
- View Details
- Sreenivas Reddy, MD, ABVLM
- Vein and Vascular Centers, SC
-
Hinsdale, Joliet, Downers Grove
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN () ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (121) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (121) ) ORDER BY first_name ASC
MENOPAUSE
select * from directory where status=0 and is_archived=0 AND ( id IN (132) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (132) ) ORDER BY first_name ASC
MLD (MANUAL LYMPHATIC DRAINAGE)
- Sharon M. Vogel
- National Lymphatic Centers - Post Plastic Surgery or Mastectomy Lymph Drainage Massage
-
Hinsdale, Downers Grove, Joliet
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (73,87,67,78) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (73,87,67,78) ) ORDER BY first_name ASC
NEPHROLOGY
- Rizwan Moinuddin, DO
- Associates in Nephrology, SC
-
Chicago Heights, Lombard, Woodridge
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (148,98,129) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (148,98,129) ) ORDER BY first_name ASC
NEUROLOGY
- Rodrigo M. Ubilluz, MD
- RMU Neurology, SC
-
Downers Grove
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (114) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (115,125,39) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (115,125,39) ) ORDER BY first_name ASC
OBESITY MEDICINE & METABOLIC HEALTH PRACTICE
- Catherine Johnson, MD
- Precision Medical Care, LLC
-
Clarendon Hills
- View Details
- Iram Shaikh-Abbasi, MD, FAAFP
- Lifetime Family Healthcare
-
Clarendon Hills
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN () ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (35) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (35) ) ORDER BY first_name ASC
ONCOLOGY/HEMATOLOGY
- Srilata Gundala, MD
- Hope & Healing Cancer Services
-
Hinsdale, New Lenox
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (93,72,80,96,94) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (44,109) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (140) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (140) ) ORDER BY first_name ASC
OROFACIAL PAIN
- Joan C. Wang, DDS, MS
- The Orofacial Pain Center
-
Chicago
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (77) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (77) ) ORDER BY first_name ASC
ORTHOPAEDIC & SPINE SURGERY
- Vivek Mohan, MD, MS, FAAOS
- Orthopaedic Spine Institute
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (131,54) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (148,137,127,164,124,263) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (148,137,127,164,124,263) ) ORDER BY first_name ASC
PAIN MANAGEMENT
- Kara Babinski, DC
- BodyWorks Medical Center
-
Carol Stream, St. Charles, West Dundee
- View Details
- Omar Said, MD
- Ascend Pain & Wellness
-
Westchester, Woodridge
- View Details
- Rodrigo M. Ubilluz, MD
- RMU Neurology, SC
-
Downers Grove
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (160) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN () ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (166,163) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (145,91,158,157,259,159,263) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (145,91,158,157,259,159,263) ) ORDER BY first_name ASC
PHYSICAL THERAPY
- Beth Gorman, MSPT, C/NDT, LSVT
- Impulse Rehab & Wellness, PLLC
-
Westchester
- View Details
- Kara Babinski, DC
- BodyWorks Medical Center
-
Carol Stream, St. Charles, West Dundee
- View Details
- Mary Ann Hilsen, MSPT, LVST
- Impulse Rehab & Wellness, PLLC
-
Westchester
- View Details
- Mirette Mikhail, PT, DPT, Cert. DN
- Team Rehabilitation Physical Therapy
-
Downers Grove
- View Details
- Philip Olasa, PT, OCS, CMT
- Emery Physical Therapy
-
Oakbrook Terrace, Mount Prospect
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (86,105,169,264) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (86,105,169,264) ) ORDER BY first_name ASC
PODIATRY
- Ashley Lee, DPM
- Northern Illinois Foot & Ankle Specialists
-
Hinsdale
- View Details
- Kevin J. Salvino, DPM
- Hinsdale Foot & Ankle Clinic
-
Hinsdale
- View Details
- Patrick McEneaney, DPM
- Northern Illinois Foot and Ankle Specialists
-
Crystal Lake
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (170) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (162) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (162) ) ORDER BY first_name ASC
PULMONARY MEDICINE
- Patricia S. Mikes, MD, MBA, FCCP
- University Affiliated Physicians
-
Hinsdale, Palos Heights
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (141) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (141) ) ORDER BY first_name ASC
REGENERATIVE & SPORTS MEDICINE
- Matthew E. Vogt, MD
- The Sports Medicine and Regenerative Therapeutics Institute
-
Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (161) ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (47,128,155,267,258,271) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (47,128,155,267,258,271) ) ORDER BY first_name ASC
RHEUMATOLOGY
- Alexandra Small, MD
- Rheumatology Associates
-
Westchester, Chicago, Chicago
- View Details
- Ben Small, MD
- Rheumatology Associates
-
Westchester, Chicago, Chicago
- View Details
- John Berry, DO
- Arnold Arthritis & Rheumatology
-
Skokie
- View Details
- Kayur Patel, DO
- Greater Chicago Specialty Physicians
-
Orland Park, Schaumburg, Oakbrook Terrace
- View Details
- Veena Nayak, MD
- Southland Rheumatology Center
-
Willowbrook , Olympia Fields
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN () ) ORDER BY displayname ASC
select * from directory where status=0 and is_archived=0 AND ( id IN (68,107,162,172,266) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (68,107,162,172,266) ) ORDER BY first_name ASC
SLEEP MEDICINE
- Patricia S. Mikes, MD, MBA, FCCP
- University Affiliated Physicians
-
Hinsdale, Palos Heights
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (158,157) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (158,157) ) ORDER BY first_name ASC
SPEECH THERAPY
- Beth Gorman, MSPT, C/NDT, LSVT
- Impulse Rehab & Wellness, PLLC
-
Westchester
- View Details
- Mary Ann Hilsen, MSPT, LVST
- Impulse Rehab & Wellness, PLLC
-
Westchester
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (33,174,260) ) ORDER BY displayname ASC
SELECT customer_contact_info.user_contact_id,directory.* FROM `customer_contact_info` LEFT JOIN directory on customer_contact_info.user_contact_id = directory.user_id WHERE customer_contact_info.expiry_on > NOW() AND customer_contact_info.is_archived=0 AND directory.is_archived=0 AND directory.status=0 AND ( directory.id IN (33,174,260) ) ORDER BY first_name ASC
VASCULAR
- Angelo N. Makris, MD
- MakrisMD Vascular Center
-
Westmont
- View Details
- Sreenivas Reddy, MD, ABVLM
- Vein and Vascular Centers, SC
-
Hinsdale, Joliet, Downers Grove
- View Details