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

Artist Profile: Bass Breche and the Politics of Telling Stories

(Photo via Instagram.com) “A story can change a person’s life. Artists should be aware of that. Stories cross borders. They’re like acupuncture -- cultural acupuncture, with the story as...

 

Taking on These "Twisted Times," Pindoll Releases Debut Album

“We don’t make music, it makes us. That’s just the way it is,” explains guitarist Miran Gurunian. Perhaps what makes Pindoll’s new album, Twisted Times, so prodigious is the genuine autonomy...

 

The Absolute Worst Lebanese Music Videos Ever Made

I realize I probably come off as a hater of Arabic music, what with my recent post about The Six Most Utterly Bizarre Lebanese Song Lyrics, but I should clarify that I am actually a huge fan of Arabic...

 

Stolen Guitars, Kafta and UFOs: The Evolution of Lazzy Lung

For a band with a lead singer that spent most of his childhood believing that UFOs are God (ironically, he originally hails from a Canadian town with the most reported UFO sightings in the world), and...

 

The Six Most Utterly Bizarre Lebanese Song Lyrics

It’s official: there is something very weird going on in the Lebanese music industry. Fair enough, art is subjective, but these lyrics in particular... these lyrics are something else. And the...

 

Sandmoon Reveals ‘Walk’ Video

Yesterday, Lebanese folk-rock group Sandmoon released a music video for the song Walk, the second from their second album Home, which came out back in November 2013. The video is directed by...

 

MC El Rass: Finding a Voice for Tripoli through Hip Hop

The city of Tripoli is, to a certain extent, shrouded in media-fabricated illusion. Whenever it’s on the news, it’s often bad news: from the ongoing armed clashes between supporters and detractors...

 

Songs You Hear at Lebanese Parties

Most people will tell you that the best part of living in Lebanon is the partying and, luckily enough, we tend to make a party out of pretty much every occasion. Now, although most teenagers would...

 

The Impressive Sound of Flum

Constant bombings, assassinations, and kidnappings have not made life in Beirut so easy lately. If the pressures of day-to-day life weren’t enough to get you all stressed out, you now have the...

 

Five Unique Middle Eastern Covers of Popular Songs

What makes for a good cover song? Appropriation and re-contextualization, for one. A good cover must also have its own twist, respect (and sometimes transcend) the original, and convey the same...