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

Ten Amazing Photos of Christmas in Lebanon on Instagram

The lights, the Christmas trees and the decorated streets of Lebanon are so gorgeous, how could you *not* want to capture them forever on your Instagram account? We've scoured your profiles to...

 

20 Powerful Images from Lebanon in 2013

 

Syria, War and Universal Struggle: Tammam Azzam's 'I, The Syrian' Exhibit

In early 2013, Syrian artist Tammam Azzam made headlines worldwide when his work, Freedom Graffiti, went viral on social media. He used one of the most iconic kisses in art ‒ Gustav Klimt’s The...

 

In Photos: Christmas Decorations From Across Lebanon

 

Five Strangely Amusing Vintage Ads from the Arab World

 

Beirut in Pictures: Before and After

One of our readers, Hassan Krayem, had the chance to document Beirut's entire reconstruction era from 1990 to 2001, and which continues to this day. Among hundreds of images he took of Beirut...

 

Saida's Studio Soussi Defied Photoshop in the 1950s

On Monday, UK newspaper The Guardian published pictures taken by self-taught photographer Chafic Ahmad Soussi, who lived and worked in Saida his entire life. One of those photographs features a ...

 

Syrian Artist Tammam Azzam Criticizes 'USA' in Latest Work

On Tuesday, Syrian artist Tammam Azzam shared his newest digital work critiquing the ongoing Syrian conflict, which has plagued the country for more than two years now. The black and white...

 

What Do You Want to Be When You Grow Up?

In an ironic twist, Kidzmondo’s “What do you want to be when you grow up?” ad campaign has been uniquely captured through the lens of the brilliant Ratib Al Safadi. The photographer...

 

Ramlet El-Baida Then and Now

  • Eye Candy
  • on Jun 6, 2013

Ever wonder what half a century does to Lebanon? Check out the differences between Ramlet El-Baida, circa 1960's, and the Ramlet El-Baida of today. There's a striking change in the amount of...