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

Five Noteworthy Stories You Might Have Missed in Lebanon This Week (1/12)

1. Al Manar Reporter Dies After Dahiyeh Blast (Photo via Al Manar) Abbas Karnib, 52, died on January 6 after suffering injuries in the January 2 Dahiyeh car bombing. He had worked at Al Manar ...

 

Our Top Five Favorite #USActLebanese Tweets

The US Embassy in Beirut released a statement on Sunday warning American citizens to "avoid hotels, western-style shopping centers, including western-style grocery chain stores, and any public or...

 

In Pictures: Friday's Starco Blast in Beirut

At least six people were killed Friday morning when a car bomb went off in downtown Beirut. Former Finance Minister and aide to former Prime Minister Saad Hariri, Mohammad Chatah, was among those...

 

Government Sends SMS Messages Warning of Alexa Storm

The Lebanese ministries of interior and communication sent out SMS messages on Tuesday morning to residents across Lebanon asking them to take precautionary measures ahead of the arrival of Alexa, a...

 

Caught on Tape: Lebanese Police Beat and Bully Suspected Thief

A video has surfaced showing Lebanese security forces beating a young man suspected of stealing a woman's purse in Jdeideh while riding his motorbike. In LBC's impressive graphic re-enactment ...

 

Microwaved Cat Handed Over to Animals Lebanon

The two teens responsible for filming and forcing a cat to be microwaved have willingly handed the animal, named Bousbous, over to the NGO, Animals Lebanon. (Photo via Facebook) The news was...

 

BeBe: Coming Soon to a Theater Near You

A new Lebanese film hits theatres at the end of this month. It's called BeBe, the story of a 33-year-old woman named Badiaah Badran, played by actress Maguy Abou Ghosn, who has the IQ of an...

 

Lebanese Teen Who Microwaved Cat Issues Apology

On Friday, Beirut.com told you about a video posted on Facebook that showed a Lebanese teen forcefully shoving a cat in a microwave and turning it on for a few seconds before removing the animal. The ...

 

The Most Pressing Concern in Lebanon Today

 

The Ten Types of People on Facebook in Lebanon

Having a Facebook profile, by nature, induces attention-seeking behavior, and most status updates are just designed to feed into the ego of the person posting them. But some people take their...