SELECT pa_ContactID,t_ContactName FROM Profiles as P 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-20' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-20')) 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 b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
:: Beirut.com :: Beirut City Guide
 

Rest House Tyr Hotel and Resort

  • Four Star Hotel
  • Sour
 

Beirut.com

  • Food & Beverages, Fashion, Recreation, Guides & Directories, News & Politics, Arts & Entertainment
  • Website
  • Hamra
 

Al Falamanki

  • Cafe, Restaurant
  • Sodeco
 

1188 Restaurant-Lounge

  • Restaurant
  • Jbeil
 

Golden Tulip Serenada Hotel

  • Four Star Hotel
  • Hamra
 

Victoria Residence

  • Property Developments
  • Aramoun
  • Real Estate Developer: Burjan LLC
 

SGBL

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

Sam Fakhoury

  • Photography Studios
  • Zouk
 

Two Wooden Stones Live at Yukunkun

  • Live Music
  • Wednesday, Apr 23, 9:00pm -> 11:30pm
  • Yukunkun

F Group

  • Developers
  • Unesco