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
- 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 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 (151,149,102,99) ) ORDER BY first_name ASC
BARIATRIC SURGERY
- Mark Choh, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Hinsdale
- View Details
- Wayne Yang, MD, FASMBS
- Suburban Surgical Associates/Suburban Metabolic Institute
-
Hinsdale
- 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
BLOOD DISEASE SPECIALIST
- Srilata Gundala, MD
- Hope & Healing Cancer Services
-
Hinsdale
- 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
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (135) ) 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) ) ORDER BY first_name ASC
CHIROPRACTIC
- Glen Batson, DC
- Batson Chiropractic Clinic
-
Willowbrook
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (149,103) ) 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 (149,103) ) ORDER BY first_name ASC
COLORECTAL SURGERY
- Jeffrey Zawacki, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Hinsdale
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (57,116,156,31,176) ) 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) ) 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 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,63,149,102,99,103,97,101) ) ORDER BY first_name ASC
GENERAL SURGERY
- Jeffrey Zawacki, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Hinsdale
- View Details
- Mark Choh, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Hinsdale
- View Details
- Robin Favor, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Elmhurst, Hinsdale
- View Details
- Ryan Headley, MD
- Suburban Surgical Associates/Suburban Metabolic Institute
-
La Grange, Elmhurst, Hinsdale
- View Details
- Wayne Yang, MD, FASMBS
- Suburban Surgical Associates/Suburban Metabolic Institute
-
Hinsdale
- View Details
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 (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
- Chris Gomez
- Resilience Home Health Corp.
-
Aurora, Morris
- View Details
- 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) ) 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
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,165,34,55,65,120,122,20,175,173) ) 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,165,34,55,65,120,122,20,175,173) ) ORDER BY first_name ASC
INTERNAL MEDICINE
- Anne Schultz, MD, FACP, MSCP
- Authentic Internal Medicine
-
Westmont
- View Details
- Asha Thomas, MD
- Westbrook Wellness Internal Medicine
-
Westchester
- View Details
- Cynthia Lagone, MD, FACP
- Authentic Internal Medicine
- View Details
- Gerald Simon, MD
- Adult Medicine Physicians
-
Downers Grove, Countryside
- View Details
- Hardeep Raj Arora, MD
- Advanced Rehabilitation Care, LLC
-
Chicago
- 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
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 (73,87,78,67) ) 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,78,67) ) 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 (121) ) 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
- 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 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 (93,72,80,96,94) ) ORDER BY first_name ASC
OPHTHALMOLOGY
- Prakash Selvaraj, MD
- West Suburban Eye Center
-
Bolingbrook
- View Details
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 Wang, DDS
- 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,164,124,127) ) 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,164,124,127) ) 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
- Thomas Pang, MD, FAAPMR, Physiatrist
- Advanced Rehabilitation Care, LLC
-
Chicago
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (160) ) 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 (160) ) ORDER BY first_name ASC
PEDIATRICS
- Arjumand Farhana, MD
- Grace Pediatrics
-
Glendale Heights
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (167) ) 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 (167) ) ORDER BY first_name ASC
PHYSIATRY
- Roshan Shah, MD, DABIM
- Advanced Rehabilitation Care, LLC
-
Chicago
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (166,163) ) 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 (166,163) ) ORDER BY first_name ASC
PHYSICAL MEDICINE & REHABILITATION
- Jason Gruss, MD
- Advanced Rehabilitation Care, LLC
-
Chicago
- View Details
- Rupak Parikh, MD, FAAPMR
- A.R.C. Advanced Rehabilitation Care, LLC
-
Chicago
- View Details
select * from directory where status=0 and is_archived=0 AND ( id IN (145,91,158,157,159) ) 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,159) ) 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
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
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 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 (161) ) ORDER BY first_name ASC
RETINA SPECIALIST
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
- 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
- Patricia S. Mikes, MD, MBA, FCCP
- University Affiliated Physicians
-
Hinsdale, Palos Heights
- View Details
- Shilpa Viswanath, DO
- Drs. Girgis & Associates
-
Hinsdale
- 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) ) 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) ) ORDER BY first_name ASC
VASCULAR
- 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