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-18' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-18')) 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 (select pa_CategoryID from Categories where pi_ParentID in (3)) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Guides to Businesses in Lebanon :: :: Beirut City Guide

Guerrilla Music

  • Recording Studio, Music Production
  • Hamra


  • Consultancy
  • Hamra

Morgan International

  • Learning Center
  • Downtown


  • Bank
  • Achrafieh, Corniche El Mazraa, Downtown, Geitawi, Hamra, Kantari, Mathaf, Mousseitbeh, Raoucheh, Tallet Al Khayat, Tarik el Jadida, Verdun

1,2,3 ... Soleil

  • Learning Center
  • Achrafieh

1,2,3...soleil is a daycare that grows, develops and operates in the field of early childhood and preschool. Its personnel is distinguished by applying basic principles based on child's personality...



  • Recreational Rental Service
  • Achrafieh

1DayNomad is an adventure that will take you into the heart of Arab Bedouin traditions in which you will discover and experience a whole new lifestyle of ancient ethnic communities based in...


247 Square

  • Civic Group

A virtual center that is available anytime and anywhere, 247square triangulates your creative interests and puts them in one place. 247square takes a circle of artists and gathered enthusiasts...


3 Axess

  • Consultancy
  • Downtown

3Axess is a Lebanese based consultancy firm that offers services in connection with media production and television integrated software and hardware solutions, local events planning and organization...


33 North

  • Travel Agency

33 North is an experiential tourism tour operator. It reflects Lebanon's geographic coordinates and carries out tours in Lebanon, Syria, Jordan and Morocco.


3arabiyyat Car Services

  • Auto Service

3arabiyyat Car Services is a team of professionals specialized in the automotive services, striving to offer unique and fundamental services such as regular vehicle check-up and repair if needed. They...