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-16' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-16')) 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 (12) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by d_DateAdded DESC
Editor's Notes :: Blogs, Articles, and Featured Stories :: :: Beirut City Guide is Hiring an Assistant Editor

Position available: Assistant editor at Description: As part of a small team, the assistant editor at will be responsible for editing all content published to the website,... is Hiring an Arts and Culture Reporter

  • Editor's Notes
  • on Apr 17, 2013

Job Opening: Full-time Arts and Culture reporter at Description: As an arts and culture reporter at, you will be responsible for pitching stories and writing a minimum of ...


Tourist Guide to Lebanon

Here you’ll find basic information, resources and tips to start planning your trip to Lebanon. Browse through the slideshow and click on the subjects you want to know more about.


Plan Your Trip to Lebanon: The Basics

1. Visas International visitors to Lebanon must carry a valid passport and, if required, a visa. For more information, click here. 2. The Weather Lebanon’s Mediterranean climate stays...


The Cheapest New Year's Eve Party in Beirut

Stop complaining about how expensive New Year's Eve can be and just follow this easy three step plan to the cheapest New Year's Eve party in Beirut. Step 1. Acquire one of these bad boys. Step 2. ...