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

Thirteen Times I've Had to Tip in Lebanon

Has anyone ever noticed how everything in Lebanon requires a tip? 1. The Gas Station You stop at the pump for gas. The gas station attendant squeegees your car's windshield. You tip him. 2....

 

The Most Unusual News Stories of 2013

Next up in recap lists, we recount the strange, the weird, the wacky, the bizarreā€¦ the headlines that elicited either a dumbfounded head shake, an eye roll or an amused chuckle. Here are the most...

 

The News Stories that Sparked the Most Outrage in 2013

In another end-of-year review, we go over the news stories that sparked the most outrage in Lebanon in 2013. Unsurprisingly, most of the indignation this year originated on social media, where...

 

Five Bizarre Retro Music Videos from Lebanon

Believe it or not, picking just five videos was actually a challenge given the plethora of bizarre material out there. And fair warning: the time wasted here is time you will never be able to get...

 

Saudi Man Cemented Door, Trapped Wife and Daughters in Room For Over a Year

According to Al-Sharq al-Awsat newspaper, a Saudi woman, identified as Abir, was trapped inside a rented room outside of Mecca by her husband for more than a year. The husband hired a guard to ensure ...

 

Microwaved Cat Incites Outrage in Lebanon

Social media and Internet users in Lebanon expressed outrage and frustration on Friday over an online video that depicts a Lebanese youth putting a cat in a microwave and turning it on for several...

 

Albums Covers Reimagined for Middle East Censorship

 

Twelve Lebanese Life Hacks

Use it to solve a problem, or just be more awesome in life. Either way, you can tell a lot about a person based on the kinds of ingenious shortcuts they come up with. Here are 12 Lebanese life...

 

Spotted at a Beirut Restaurant: Falafel with a Side of 'Torture'

File this one under: #OnlyinLebanon From the creators of the Phoenician alphabet, we bring you this miserable menu item: a "Dozen Flafel and vegetable and torture," from the Damas restaurant in...

 

General Security Rebuffs Report, Says Lebanon's Passport is 'Among Best' in World

Everyone and their Lebanese mother was talking about a report released earlier this week that ranked Lebanon's passports among the worst in the world when it comes to allowing its citizens to travel...