SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID) inner join Categories on (pa_CategoryID=pi_CategoryID) 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-21' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-21')) 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 ((pi_ParentID in (374)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (374)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
People :: Beirut.com :: Beirut City Guide
 

5 seKonds late

  • Band

5 seKonds late a band is made up of friends who have played together in an assortment of occasions and musical gigs over the years. The members bring their various musical backgrounds to the table to ...

 

Abdo Feghali

  • Noteworthy

Abdo Feghali is a pro racer and drifter who was also the track designer and organizer of Red Bull Car Park Drift in Lebanon and the Middle East from 2008 to 2011. He has won numerous championships ...

 

Abdul Rahman Katanani

  • Artist

Beirut-born Palestinian artist Abdul Rahman Katanani’s work intensely depicts the tragedy of his fellow Palestinian refugees, yet never delivers evidently sad or depressing messages. Katanani uses...

 

Addict

  • Band

Beirut's music scene has been swarming with fresh talents and emerging bands. Among the most promising of them on the classic rock and blues scene are Addict. The local band, comprised of 3 members,...

 

Adnan Mansour

  • Politician
  • Achrafieh

Born in 1946, Adnan Hassan Mansourwas appointed Minister of Foreign Affairs & Emigrants in June 2011. He received a degree in Administrative Sciences and Policies from the St. Joseph University in ...

 

Adonis

  • Band

Adonis is a musical project that came to life on the rooftop of an anonymous building in an anonymous Northern suburb, as a response to the glutinous swamp of silicone and mediocrity that is flooding ...

 

Afro-Beat Collective

  • Band

Afro-Beat Collective is newly born. Coming from different origins but with the same passion for African beats they aim to develop and encourage all kinds of music and art that find their roots in the ...

 

Ahmad Karami

  • Politician

June 2011: Appointed Minister of State under Prime Minister Najib Mikati.

 

Ahmed Zidan

  • Blogger, Beirut.com Contributor, Journalist

Ahmed Zidan is a freelance journalist and translator from Egypt. Follow him on Twitter @zidanism.

 

Alaeddine Terro

  • Politician

Born in the year 1953, he is a member of the “progressive socialist party” June 2011: appointed Minister for the Displaced under Prime Minister Najib Mikati.