DIRECTORY

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

  • Veena Nayak, MD
  • Southland Rheumatology Center
  • Olympia Fields, Willowbrook
  • 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 * 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,176,31) ) 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,176,31) ) ORDER BY first_name ASC

DERMATOLOGY

  • Lalitha Reddy, MD
  • Reddy Dermatology, SC
  • Downers Grove
  • View Details
  • Shelley Halper, MD, FAAD, ASDS
  • Dermatology Associates of La Grange
  • La Grange
  • View Details
  • Vikram Khanna
  • 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

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
  • Nancy Gryniewicz-Sika, MD
  • Family Medical Care, LTD.
  • Oak Park
  • 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 (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

GYNECOLOGY

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,171,177) ) 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,171,177) ) 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 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 (139) ) ORDER BY first_name ASC

INFECTIOUS DISEASES

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

  • 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

  • Anne Schultz, MD, FACP, MSCP
  • Authentic Internal Medicine
  • Westmont
  • View Details
  • 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
  • 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) ) 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) ) ORDER BY first_name ASC

INTERVENTIONAL RADIOLOGY

  • Saumil M. Shah, 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 (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

MASSAGE

  • Sharon M. Vogel
  • National Lymphatic Centers - Post Surgery Lymph Drainage Massage
  • St. Charles
  • View Details
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 (73,87,78,67) ) ORDER BY displayname ASC
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 (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

OBSTETRICS AND GYNECOLOGY

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,263,124) ) 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,263,124) ) ORDER BY first_name ASC

PAIN MANAGEMENT

  • Omar Said, MD
  • Ascend Pain & Wellness
  • Westchester
  • 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
  • E. Shaaban Hassanein, PT
  • Star Physical Therapy
  • Downers Grove
  • 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) ) 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) ) ORDER BY first_name ASC

PODIATRY

  • Ashley Lee
  • Northern Illinois Foot & Ankle Specialists
  • Hinsdale
  • View Details
  • Kevin J. Salvino, DPM
  • Hinsdale Foot & Ankle Clinic
  • Hinsdale
  • View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (170) ) 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 (170) ) ORDER BY first_name ASC

PSYCHIATRY

  • Mark C. Walker, MD
  • Mark C. Walker, MD
  • Hinsdale
  • View Details
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,155,128,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 (47,155,128,258) ) ORDER BY first_name ASC

RHEUMATOLOGY

  • Kayur Patel, DO
  • Greater Chicago Specialty Physicians
  • Orland Park, Schaumburg, Oakbrook Terrace
  • View Details
  • Veena Nayak, MD
  • Southland Rheumatology Center
  • Olympia Fields, Willowbrook
  • 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) ) 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) ) ORDER BY first_name ASC

SLEEP MEDICINE

  • Amita Goyal, MD
  • Drs. Girgis & Associates
  • Hinsdale
  • View Details
  • 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
  • Saumil M. Shah, MD
  • MakrisMD Vascular Center
  • Westmont
  • View Details
  • Sreenivas Reddy, MD, ABVLM
  • Vein and Vascular Centers, SC
  • Hinsdale, Joliet, Downers Grove
  • View Details