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

Re-Cycling with Regar: Beirut’s Bicycle Kitchen

For many, bicycles are regarded as nothing more than a mode of leisure and entertainment. They’re ridden around parking garages and public spaces for a couple of years before being ultimately...

 

Creative Beirut: A Cultural Exploration of Lebanon in Edinburgh

This week, Lebanon took center stage in Scotland during a four-day, global ethnography showcase called Creative Beirut. The event was organized by Arek Dakessian as part of his ongoing research into...

 

Street Artist Ali Rafei: An 'Honest' Vandal

  • Hey, Scenesters!
  • on Feb 26, 2014

When you have something to say, you just say it. But when most media networks around you are politically biased and arbitrary censorship runs rampant, then you have no choice but to spray it. This has...

 

Wandering Through a Labyrinth of Shock and Provocation

It is a commonly held belief in Lebanon that art is essentially correlated with beauty and aesthetic pleasure; a craft manufactured to embellish or decorate. Many Lebanese would wholeheartedly agree...

 

Totally Fab: The Queen of Lebanon's Design Scene, Rana Salam, Opens Her Own Boutique (Finally!)

Lebanese graphic designer Rana Salam is the queen of contemporary Middle Eastern design. Salam has honed a unique skill for craftily combining Arabic pop art with whimsical prints and eye-catching...

 

The Panoramic Party Experience of O1NE

Stepping inside the spacious structure, you find yourself surrounded by a larger-than-life visual display that turns a nightclub into a vivid world of bright colors and moving images. Welcome to O1NE,...

 

Stereo Club Nights Are Back Again

On December 21, one of Beirut’s major party series, Stereo Club Nights, will be making a long-anticipated return to the ever-lively nightlife scene after a lengthy absence. Stereo Club Nights...

 

Rediscovering Beirut with Wael Kodeih

Although cities are dynamic, ever-changing, and in a constant state of transformation, life in them can become monotonous and tedious. You see the same building every day on your way to work, you pass...

 

Six Reasons to Check Out the Beirut & Beyond International Music Fest

This week Beirut will be injected with a dose of musical awesomeness as the Beirut & Beyond International Music Festival kicks off bringing you half a dozen incredible live performances by artists...

 

A Half Century Later, Video Chico Brings Back the Vinyl

You could say Diran Mardirian's passion for music started in the womb. “When I was in my early teens," the owner of Video Chico tells Beirut.com, "I set up a little sound system and got out the...