SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID and pi_CategoryID in (396)) 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-19' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-19')) 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 b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
The Beirut Guide to Movies and Film Now Playing in Cinemas Across Lebanon :: Beirut.com :: Beirut City Guide
 

Non-Stop

An air marshal springs into action during a transatlantic flight after receiving a series of text messages that put his fellow passengers at risk unless the airline transfers $150 million into an...

 

'Crossing the Bridge: The Sound of Istanbul' Screening at Radio Beirut

Need for Speed

Fresh from prison, a street racer who was framed by a wealthy business associate joins a cross country race with revenge in mind. His ex-partner, learning of the plan, places a massive bounty on his...

 

Divergent

In a world divided by factions based on virtues, Tris learns she's Divergent and won't fit in. When she discovers a plot to destroy Divergents, Tris and the mysterious Four must find out what makes...

 

Mea culpa

Simon and Franck are police officers. After celebrating the end of a mission, they hit a car on the way home. Franck uninjured, while Simon, who was driving under alcohol and was wounded. But the...

 

Heritages

When director Philippe Aractingi is forced to leave his motherland for the third time, the realisation dawns on him: his ancestors have been fleeing wars for five generations. Exploring his roots,...

 

Casse-tête chinois

A 40-year-old father of two, still finds life very complicated. When the mother of his children moves to New York, he can't bear them growing up far away from him and so he decides to move there as...

 

Miniscule - Valley of lost ants

In a peaceful forest, the remains of a picnic trigger a ruthless war between rival ant colonies, obsessed with gaining control of the same prize: a box of sugar cubes!

 

Son of God

The life story of Jesus is told from his humble birth through his teachings, crucifixion and ultimate resurrection.

 

Rio 2

It's a jungle out there for Blu, Jewel and their three kids after they're hurtled Rio de Janeiro to the wilds of the Amazon. As Blu tries to fit in, he goes beak-to-beak with the vengeful Nigel, and...