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

Our 20 Favorite Graffiti Pieces in Beirut Right Now

 

What's Up with the Green Hair Trend?

Riddle me this, dear readers: we've spotted a bunch of Lebanese, varying in age from teens to the elderly, all sporting green hair at either Le Mall Dbayeh or ABC Mall Dbayeh. I, for one, love the...

 

A Graffiti Homage to Ali Abdallah

Photo via Facebook.com Yazan Halwani has once again put his unique style, creative approach and, now, social consciousness into another memorable piece of graffiti art. His latest mural pays...

 

The Most Perverted Lebanese Truck You Will See Today

Spotted: a sign on the back of a delivery truck in Lebanon that reads: “Play alone, end up satisfied." I'm going to try and stretch my imagination for this one. Maybe by "play alone," he...

 

Spotted: A Smart Road Safety Hack in Hamra

“This could be your uncle’s kids, your sister's, your own kids or your friends'… don’t speed in front of schools and near pedestrian sidewalks.” That's the message road safety NGO...

 

Spotted: Belgian Fries Joint on Bliss Street

Bliss street is no stranger to new concepts. With three brand new spots open within the past few months alone— Papparoti, Prime on Bliss Cinema and now, Fritz—it seems that the busy street is...

 

Spotted: New Cinema on Bliss Street

Everyone, everyone! The rumors are true! There actually is a cinema on Bliss Street! Sheathed in mystery and clouded in darkness (I'm going for dramatic effect), the cinema complex stands next to...

 

Gorgeous Street Art: Fayrouz Spotted in Gemmayzeh

You may have seen this incredible piece of graffiti on the alleyway wall next to the 392Rmeil393 art gallery in Gemmayzeh. It was created by 20-year-old graffiti artist Yazan Halwani....

 

Executive Magazine Creates Panorama of Cranes in Beirut

We all love sleep, and thus, we all hate the sound of construction. Now we all think that there's tons of work going on around our houses and routes to work. But how much is there really? To answer...

 

Spotted: New TV Show Filming on Abdel Aziz Street

You know the typical Lebanese show mold: hot models, intense backdrop, lots of drama, and more really hot models. And currently taking place on Abdel Aziz Street is a huge crew filming exactly...