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-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 ((PM.pi_Typeid!=0) OR (PM.pi_MediaObjectID in (select pi_MediaObjectID from MediaObjects_Authors))) and PM.pi_Typeid in (9) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by d_DateAdded DESC
Stuff We Love :: Blogs, Articles, and Featured Stories :: Beirut.com :: Beirut City Guide
 

Five of Amalia Abi Saleh's Funniest Moments

Lebanese comedian and actress Amalia Abi Saleh passed away today Friday at around 3:00 a.m. She was 68-years-old. In June of 2013, Abi Saleh sparked national controversy after she was rejected from...

 

Our Fave TV Commercial Jingles from the 1990s

The Lebanese rock band, Meen, has famously paid tribute in their song "Wa'afe Ma' Al E'len" to a lot of the jingles we watched on television and eventually knew by heart while growing up in Lebanon....

 

Five Things We Love About Lebanese Frenchies

Let’s face it: Beirut has a lot of Frenchies, or, to be safe, pseudo-Lebanese-Frenchies that were in a French school during their teenage years and traveled once, or twice, to Paris for their senior...

 

Five Things You (Probably) Don't Know About Tripoli

 

Forget Third World Problems, These are Lebanese Problems

You've heard of #firstworldproblems and #thirdworldproblems, well we don't know much about that, but we do know a little something about Lebanese problems. Take a look: 1. Mixing Different...

 

Our Top 10 Fave Beirut.com Articles from 2013

Admit it. We've published some fun articles over the past year. We're bringing you our top ten favorite articles from 2013, and hoping you've laughed just as much as we have. 1. The Eight Types of ...

 

The Holidays: Now vs. Your Childhood

The holidays are upon us - finally! Vacation, presents, food, rest, couldn't get any better right? - wrong. So. Wrong. We're not kids anymore. Long gone are the days when the holidays meant...

 

Another Reason To Love Couqley Restaurant

We're already fans of Couqley restaurant. It has - hands down - the best Eggs Benedict in the country. No really, I've committed myself to living a life without Eggs Benedict unless I am ordering it...

 

Five Places to Grab Cute Christmas Gifts in Beirut

 

Our Five Favorite Things About December in Lebanon