SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID) inner join Categories on (pa_CategoryID=pi_CategoryID) where P.b_Deleted=0 and P.b_Completed=1 and b_featured=0 and ( (t_picsFolder='place' and b_Status=1) OR (t_picsFolder!='place') ) and ( (t_picsFolder='event' and pa_ContactID in (select pi_ContactID FROM Profiles_Events WHERE pi_ContactID=pa_ContactID and ((d_EndDate='0000-00-00') Or (d_EndDate ='2014-04-23' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-23')) and NotImportant=0)) OR (t_picsFolder!='event') ) and ( (t_picsFolder='movie' and 1 in (select b_PlayingNow FROM Profiles_Movies WHERE pi_MovieID=pa_ContactID))OR (t_picsFolder!='movie') ) and ((pi_ParentID in (71)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (71)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Guide to Health Services, Healthcare Providers, Doctors and Hospitals in Lebanon :: Beirut.com :: Beirut City Guide
 

A New Earth

  • Nutrition & Health
  • Achrafieh

At A New Earth, you’ll find pretty much everything you see in a regular grocery store, plus many items you don’t. The difference is that their products are all organic and natural. What makes ...

 

Abakua Dance School

  • Gyms & Studios
  • Gemmayzeh

If you hitting the dance floor usually provokes an insane wave of hilarious laughter, it’s time to change the established equilibrium. Abakua Dance School helps setting salseras and salseros...

 

Abiad Pharmacy

  • Pharmacy
  • Hamra

Abiad Pharmacy is a pharmacy located in the Hamra area of Beirut.

 

Abla Bsat Jomaa

  • Clinic
  • Hamra

Educational Evaluation and Educational Psychology specialist

 

Advanced Sports Center

  • Gyms & Studios
  • Jal el-Dib

Advanced Sports Center (ASC) is the first health center in Lebanon and the Middle East to provide a wide range of health services in one place with a multidisciplinary approach personalized for each...

 

Al Hout Pharmacy

  • Pharmacy
  • Mousseitbeh

Al Hout Pharmacy is located in Mousseitbeh.

 

Al Jamiaa Al Jadida

  • Pharmacy
  • Ras El-Nabeh

Al Jamiaa Al Jadida is a pharmacy located in Ras El-Nabeh

 

Al-Chaer Pharmacy

  • Pharmacy
  • Hamra

Al-Chaer Pharmacy is a pharmacy located in Hamra.

 

Al-Richani Pharmacy

  • Pharmacy
  • Hamra

A pharmacy located close to American University Hospital

 

Al-Saydé Pharmacy

  • Pharmacy
  • Achrafieh

Al-Saydé Pharmacy is located in Achrafiyeh, not far from a district containing different clinics and healthcare facilities.