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 (97)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (97)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Information and Resources about Education, Schools and Universities in Lebanon :: :: Beirut City Guide

Morgan International

  • Learning Center
  • Downtown

1,2,3 ... Soleil

  • Learning Center
  • Achrafieh

1,2,3...soleil is a daycare that grows, develops and operates in the field of early childhood and preschool. Its personnel is distinguished by applying basic principles based on child's personality...


Academie Libanaise des Beaux Arts (ALBA)

  • University
  • Sin El-Fil

The Académie Libanaise des Beaux-Arts (ALBA‎) was originally a stand-alone Lebanese institute, and is now one of the nine current faculties at the University of Balamand, teaching courses in fine...


Academy Of Languages And Practical Skills

  • Learning Center
  • Hamra

Located in Beirut (in Hamra central district near AUB) ALPS offers courses in Arabic language, both colloquial Levant language (spoken in all of Lebanon, Syria, Jordan and Palestine) and MSA. They are...


ACT Knowledge Center

  • Learning Center
  • Clemenceau

ACT established its Knowledge Center believing that training is the most important aspect in a technical professional's career. Training should be considered Lifelong learning not just a one-time...


Al Kafaat University

  • University
  • Ain Saadeh

The Al-Kafaàt University (AKU) bases its educational philosophy, standards, and practices upon two principles: First, that "AKU shall promote the right of every individual to a quality education...


Al- Bayader School

  • School
  • Zarif

Al- Bayader School, in its educational mission, aims to ensure a teaching environment, built on modern, active basis. These in turn -aim to stimulate the learner, to develop a responsible, creative,...


Al-Manar University of Tripoli

  • University
  • Tripoli

Since its founding, the Al-Manar University of Tripoli (MUT) has consistently striven to create individuals who are effective and active in their community. Its success in achieving this goal is...


ALPS Arabic Language Program in Beirut

  • Language Center
  • Hamra

ALPS is an Arabic teaching center language in Hamra that specializes in personal instruction in both MSA and Spoken Lebanese Arabic. They have been helping students learn and improve their Arabic for...


Amadeus Dance & Music School

  • Learning Center
  • Sodeco

Founded in 1998, Amadeus Dance and Music School offers classes by a certified and professional team of teachers .