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

Three People on Leaving Lebanon (and Reaching Their Breaking Point)

Security issues, long-standing political stagnation, lack of job opportunities, and a seemingly perpetual economic slump; any way you look at it, Lebanon has been put through the wringer for years....

 

Things We Wish for Lebanon in 2014

In the spirit of solidarity and togetherness, we’ve scoured the streets to ask people this one question: what gift do you wish for Lebanon in 2014. We chose Hamra as our starting point, and...

 

Five New Year's Resolutions for Lebanon

1. Halt the Honk (Photo via carlamaree.com) So it’s fun every once in a while to blare up our radios to “Tee Rash Rash” or “Zamir ya Tawil l 3omir” and yes, it’s even more fun to...

 

Five Common Lebanese Excuses

If you're Lebanese, you've probably used at least one of these excuses within the past week. Whether you're skipping a meeting, avoiding some annoying friends, escaping family get togethers or just...

 

How You Can Help Syrian Refugees in Lebanon

Cold weather conditions were reportedly responsible for the deaths of four Syrian infants in Arsal and Akroum last week, following the arrival of the winter storm, Alexa, in Lebanon. Oxfam says...

 

Six Ways to Donate in December

 

So You Wanna Be Lebanese?

A new non-profit initiative has launched in New York aiming to help Lebanese-Americans activate their Lebanese citizenship, free of charge. For now, the initiative is focusing on emigrants located...

 

Four Things to Make You Feel Patriotic on Independence Day

It only takes one glance at the latest news report to realize that we’re a lost, haunted nation. Heck, it only takes one conversation with a taxi driver. And of course, with the past week’s...

 

Spotted: Hero Helped Injured Domestic Workers after Beirut Suicide Bombings

Amid the immense tragedy we witnessed following twin suicide bombings in Beirut on Tuesday, a flicker of humanity remains. (Photo by Hasan Shaaban via the Daily Star) (Photo by Hussein...

 

Anger Management: Nearly 40,000 Have Sought Help at Men's Center

"I advise every man [in Lebanon] to consult the Men's Center before getting married, to see if he's capable of raising children. Bringing innocent people who have done nothing wrong into this world - ...