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-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 ((pi_ParentID in (294)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (294)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Online:: Internet:: Beirut :: Beirut.com :: Beirut City Guide
 

Beirut.com

  • Food & Beverages, Fashion, Recreation, Guides & Directories, News & Politics, Arts & Entertainment
  • Website
  • Hamra
 

+961

  • Social
  • Blog

+961 is a collection of posts about events and various things happening in Lebanon. The main reason for building this blog was +961's interest in citizen journalism and the joy they find in reporting ...

 

14March.org

  • News & Politics
  • Website

14March.org is the official website of the 14 March national gathering. Latest news, speeches, petitions, photos and more.

 

2famous.tv

  • Social
  • Blog

Matias Nordahl Carlsen is from the majestic Lofoten islands in the North of Norway. Always on the move, he has travelled the world from North to South, and from East to West. Most often he would go ...

 

3akarat.net

  • Guides & Directories
  • Website
  • Downtown

3akarat.net deals with real estate services mediating online, by offering a wide range of real estate on its website.

 

3albeit.com

  • Food & Beverages, Guides & Directories
  • Website

3albeit.com is a visual directory listing all Lebanese restaurants providing home and office delivery. It lists online all delivery restaurants with their menus, contacts and addresses.

 

3ikar.com

  • Guides & Directories
  • Website

3ikar.com is a Lebanese real estate website and search engine created for the purpose of connecting buyers to sellers and vice versa with all their real estate needs. Agents and buyers are provided...

 

50mm Across

  • Arts & Entertainment
  • Blog

Our eyes see at 50mm. It's where reality happens. Check out this photography blog that covers everything from still life to portrait shooting.

 

7iber

  • News & Politics
  • Website

7iber, meaning 'ink' in Arabic, is a citizen media platform established in 2007 with the aim of providing a collective online space for the average Jordanian citizen to share their opinions,...

 

961 Website

  • Guides & Directories
  • Website

Whenever you want to find the top businesses in Lebanon, look no further than Ninesixone. They're the Lebanese online business directory that includes all top businesses in Lebanon. Ninesixone gives...