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-17' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-17')) 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 (19) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by d_DateAdded DESC
We Heart Nerds :: Blogs, Articles, and Featured Stories :: Beirut.com :: Beirut City Guide
 

FIRST Lego League Brings the Robot Revolution to Lebanon

“In the past, we witnessed the computer revolution, then the internet revolution; in the coming years we will be witnessing the robot revolution." This quote does not belong to a Japanese scientist ...

 

How to Become a Beirut Hipster

We love us some hipsters and anyone with an unquenchable thirst for all things alternative, for that matter. But for the sake of appearances, here's a simple how-to guide on becoming a hipster in...

 

Eight Reasons Arabic is Impossible to Learn

For native Arabic speakers, the language might seem like a piece of Knefe, but for our fellow neighbors in the world, Arabic is considered among the top ten most difficult languages to learn. Here's...

 

Six Great Lebanese Comic Books You Should Check Out

 

Le Gray Beirut Launches Instagram Contest

Even if Instagram isn't your thing, the potential prizes you could win in this contest far outweigh anything you may have against the online photo-sharing application. All you have to do is take...

 

Five Underrated Places Every Beirut Bookworm Needs to Visit

 

Beating Scores, Scoring Beats: The 8-Bit Sounds of Rhea Dally

The last time you held a Nintendo Game Boy between your hands - if ever - you were probably nothing more than a child making an Italian plumber leap over flaming barrels. The technology may be a bit...

 

A Guide to Undergraduate Fine Arts Degrees in Lebanon

 

Lebanese Developers Start Kickstarter Campaign for Conflict-Resolution Video Game

Search for Common Ground Lebanon (SCGL), a team of professionals dedicated to helping youth learn about conflict resolution in fun and entertaining ways, is currently developing a video game called...

 

The Definitive Guide to Buying Comic Books in Beirut