SELECT pa_ContactID,t_ContactName FROM Profiles as P INNER JOIN Categories_ContactsCategories AS CC ON ( CC.pi_contactID = pa_ContactID AND (pi_CategoryID =507 OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID=397) )) inner join Profiles_MediaObjects as PM on (PM.pi_MediaObjectID=pa_ContactID) 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 ((PM.pi_Typeid!=0) OR (PM.pi_MediaObjectID in (select pi_MediaObjectID from MediaObjects_Authors))) and PM.pi_Typeid in (21) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by d_DateAdded DESC
Crave :: Blogs, Articles, and Featured Stories :: Beirut.com :: Beirut City Guide
 

Taste of Beirut: The Day Beirut's Best Foods Were Meant to Be Together

ArabNet, the ultimate hub for entrepreneurship and e-commerce, hosted its annual digital conference in Beirut this week with the addition of a delightfully delicious bonus: Taste of Beirut. The event ...

 

How to Save Money Going to the Movies in Lebanon

Anyone else notice how costly a trip to the movies can be? Aside from the price of the ticket, the concession stand inside the theater is exorbitantly expensive. A small box of popcorn with a...

 

What's New at Zaitunay Bay

Zaitunay Bay is nearly two years old, and it’s definitely growing. A small shop selling Belgian waffles opened its doors less than a month ago next to the recently renamed Cro (originally Cro...

 

The Easiest Way to Eat Healthier: Go to Captain Cook

If you’re looking for a delicious, balanced and affordable meal downtown, look no further: Captain Cook is here. Operating since the fall of 2013, Captain Cook specializes in “super...

 

Go Mobile With Kaak and Labneh in Lebanon

Have you seen these products in the yogurt aisle? Krocks, as they're called, feature kaak spears and labneh in a plastic cup for eating on the go. There are four flavors: original, labneh light,...

 

A Taste of France in Beirut

TSC Signature in the heart of Beirut Souks always manages to bring out the epicure in me! On my last last trip there, I discovered fine French yogurt and dessert products in the freezer aisle. The...

 

Our Favorite Places to Grab a Homemade Meal in Beirut

 

Bardo's Brand New Miso Ramen Soup: Yum

Too bad we came out with this list of Slurp-Worthy Soups before we had the chance to try this new offering at Bardo: the newly unveiled perfection that is the Miso Ramen. Chicken miso soup,...

 

Meals Every Tourist in Lebanon MUST Try

 

Five Healthy Places to Eat During the Holidays