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 (10) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by d_DateAdded DESC
Stuff We Hate :: Blogs, Articles, and Featured Stories :: Beirut.com :: Beirut City Guide
 

Six Lebanese Presenters We Wish Would Change Their Attitudes

 

Five Beauty Trends We'd Like to See Lebanese Women End

For some, Lebanese celebrities are considered the epitome of fashion-forward thinking and sheer beauty. But just because Maya Diab can pull it off (sort of), doesn't mean the rest of us should blindly...

 

What the New 50,000 LL Bill Could Have Looked Like

On Wednesday, local TV station LBCI tweeted an image showing the brand new redesign of the 50,000 LL bill which is expected to be released into circulation on November 22, just in time for the 70th...

 

Five Things to Hate about the Holidays

Every time a holiday season approaches in Lebanon - and let's be serious, it happens quite a lot in this country - the nightmarish things we hate about it (you know, the ones we've buried deep in our ...

 

Report: Work Resumes to Dismantle Hippodrome Ruins

Developers will continue to dismantle ancient ruins on the site of the Roman Hippodrome after a judge overruled a temporary work cessation order to make way for a multi-million dollar gated community ...

 

Five Reasons Some Lebanese TV Series Seriously Suck

As an avid viewer and supporter of Lebanese TV series, I've come to realize that while some programs are working on transforming the way we watch television with imaginative story lines, provocative...

 

Beirut Jazz Festival 2013 Postponed

The Beirut Jazz Festival, which was scheduled to happen this weekend from September 5 to September 6, has been postponed "due to the current situation," a spokesperson for the festival told Beirut.com...

 

Taksim Trio Cancels Beirut Performance

Members of the Turkish band, Taksim Trio, announced on Wednesday they are cancelling their performance on September 19 at AUB as part of the Beirut and Beyond International Music Festival, fearing the...

 

An-Nahar Staff Member Among Dahiyeh Blast Victims

(Photo via Facebook.com) Very little is so far known about the 24 victims killed on Thursday in the car bombing that ripped through the southern Beirut neighborhood of Ruwaiss. One of the...

 

Sabah Fakhri Holds Concert at Beirut Souks, Barely Sings

On Tuesday night, famed singer Sabah Fakhri performed live at Beirut Souks as part of the Beirut Holidays Festival. The show, to put it simply, was a disaster. First off, Fakhri didn't start...