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 (371) OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID in (371)) )) 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-17' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-17')) 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
Sports and Activities :: :: Beirut City Guide

A Day in the Heart of Baalbek

Beirut Elite Fighting Championship

  • Martial Arts

The BEFC is Lebanon's first mixed martial arts league. It features the best Lebanese fighters and from all over the world. BEFC aims to host the most exciting MMA fights in the Middle-East, featuring ...


Beirut on Ice at City Mall

Bike Generation

  • Bicycle Rentals, Biking
  • Tayouneh

Bike Generation is a group of friends with a common passion for cycling - firmly committed to turning Beirut into a bicycle-friendly city - who decided to set up their own professional cycling shop in...


Charly's Gym

  • Gyms & Studios, Martial Arts
  • Mtaileb

Charly's gym is the place to stay in shape, as it provides for a variety of different programs and classes. They have radical fitness classes are like Powercardio, X55 and Fight Do as well as a Zumba ...


Cheetah Fighting Club

  • Martial Arts
  • Burj Abi Haidar

Cheetah Fighting Club offers a variety of programs like MMA, Fitness and Cardio, Stretching and pilates, self defense and weight loss.

  • Rock Climbing is a non-profit website aiming at promoting and developing rock climbing in Lebanon. Their site was put up by the efforts of the community of rock climbers in Lebanon. A group...


Dbayeh Country Club

  • Horseback Riding
  • Dbayeh

Since 1971, horse enthusiasts have been heading over to the Dbayeh Country Club to delight in equestrian sports. If you're not a professional horseback rider, there's nothing to fear, because trainers...


Easter Monday Hike in Tannourine Nature Reserve

Hoops Club

  • Gyms & Studios, Basketball, Tennis, Football
  • Antelias, Ghobeiry, Hazmieh

Hoops is a club where the youth get the opportunity to discover the physical and moral benefits of sports. Hoops Club offers a wide range of sport activities for amateurs, professionals, children and ...