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 (77) OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID in (77)) )) 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-20' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-20')) 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
Guide to Airlines, Travel Agencies, Public Transportation and Taxis in Lebanon :: Beirut.com :: Beirut City Guide
 

1DayNomad

  • Recreational Rental Service
  • Achrafieh

1DayNomad is an adventure that will take you into the heart of Arab Bedouin traditions in which you will discover and experience a whole new lifestyle of ancient ethnic communities based in...

 

33 North

  • Travel Agency

33 North is an experiential tourism tour operator. It reflects Lebanon's geographic coordinates and carries out tours in Lebanon, Syria, Jordan and Morocco.

 

A.C. Tours

  • Travel Agency
  • Hamra

For all your travel and tour services, A.C. Tours can be your guide.

 

ABC Shipping Co.

  • Shipping & Cargo
  • Ain El Mreisseh

In 1998, and after more than a decade in the business of freight forwarding customs brokerage, ABC shipping Co.was founded in the heart of Beirut city the capital of Lebanon, and main gate for all...

 

Ace Travel

  • Travel Agency
  • Ain El Mreisseh

Established in 1990, and based in Beirut - Lebanon, Ace Travel is a Travel Agency and Tour Operator that provides World Class Travel arrangements for both Leisure and Corporate...

 

Acra Agency sarl

  • Travel Agency
  • Achrafieh

Acra Agency; Without a travel agent, you're on your own.

 

Aeolos Travel

  • Travel Agency
  • Achrafieh

Aeolos Travel takes care of your travel arrangements, ticketing reservations, organization of sightseeing tours, local cruises, and conferences.

 

Aeroflot Russian Airlines

  • Airlines
  • Verdun

Aeroflot is Russia’s de facto national carrier and largest airline. Founded by the Russian government on 9th February, 1923, Aeroflot is among the world’s oldest airlines and one of Russia’s...

 

Air Algerie

  • Airlines
  • Clemenceau

Air Algerie is the national flag carrier airline of Algeria.

 

Air Arabia

  • Airlines
  • Kantari

Air Arabia, the Middle East & North Africa's first and largest low cost carrier (LCC). They fly to over 65 destinations spreading across the Middle East, North Africa, Asia and Europe. Air Arabia...