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-17' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-17')) 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 (4)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (4)))) 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 Places to Eat and Drink in Lebanon :: Beirut.com :: Beirut City Guide
 

Al Falamanki

  • Cafe, Restaurant
  • Sodeco
 

Bar Tartine

  • Restaurant
  • Achrafieh, Gemmayzeh
 

Zein Cafe

  • Cafe, Restaurant
  • Sad el-Baouchrieh
 

1188 Restaurant-Lounge

  • Restaurant
  • Jbeil
 

365 Restaurant

  • Restaurant
  • Dbayeh

With their signature Plat du Jour and varied menu with home-style cooking, they serve food that can be enjoyed 365 times a year as 365 separate days of flavors waiting to be discovered.

 

3a Zaw2ak

  • Cafe, Restaurant
  • Hamra

3a Zaw2ak by Ka3kaya is an inviting Lebanese restaurant serving delicious meals for breakfast, lunch and dinner. Don't forget to enjoy their tasty shishas.

 

3arayes Restaurant

  • Restaurant
  • Chyiah

A contemporary Lebanese restaurant ready to cater to your personal lifestyle, 3arayes Restaurant has it all—from soft pastry day-starters to irresistible shawarma and BBQ grills—all prepared on...

 

3kayfak

  • Cafe, Quick Bite
  • Raoucheh

3kayfak, meaning "Whatever Suits You", speaks for itself. You can go and chill in this cafe at your own terms. Offering different kinds of drinks and hookahs to make your stay worthwhile.

 

9:30

  • Restaurant, Pub
  • Hamra

9:30 bar and grill in Hamra is all about a fun, fashionable atmosphere with flavorful and reasonably-priced cocktails. Please Note: The 9:30 bar and grill is now closed for renovation. It is set ...

 

A'al Fahem

  • Quick Bite
  • Ras El-Nabeh

A'al Fahem is a fast food restaurant serving Lebanese food. A'al Fahem is well known for his famous shawarma.