SELECT pa_ContactID,t_ContactName FROM Profiles as P 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 b_JustForKids=1 and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Just For Kids :: Beirut.com :: Beirut City Guide
 

0123

  • Accessories
  • Sin El-Fil

0123 imports the best brands that provides you with innovative, functional and attractive products that are the best for your baby. 0123 offers European and North American brands from leaders who are ...

 

Adventures in Lebanon

  • Recreation, Guides & Directories
  • Website

Adventures in Lebanon is an Ecotourism club that shares the love of nature, adventure, good spirits, and positivity with its members. It is organized and managed Viviane & Joe Karam. Their...

 

Al Majal

  • Associations & NGO's
  • Badaro

Members of Beirut Association for Social Development (BASD), AL MAJAL is a specialized center dedicated to enhancing the lives of children and young people with special needs by giving them the...

 

Alex

  • Toys & Accessories
  • Downtown, Sodeco

Alex's mission is to provide children with quality creative products that foster personal expression and build self-esteem. The best children activities provide lots of fun and they open a child's...

 

Alina

  • Furniture
  • Ghazir, Sin El-Fil

Galerie Alina is a chain of stores founded in Beirut in 1975. Their services are dedicated to babies and mothers-to-be, and they are exclusive agents of the best international brands devoted to...

 

Amusement World

  • Children's Activity Center
  • Chyiah

Adventure World is the first indoor family park in Lebanon, with two fully air-conditioned floors of over 3,500 square meter area, filled with exclusive rides and games. Children from 2 to 12 years...

 

Animal Encounter

  • Zoo
  • Aley

Animal Encounter is a small zoo that has 34 animal species including a bear, a jackal, a wolf, and other wildlife creatures. The reserve take also care of injured animals and is open to public on...

 

Antoine ID

  • Books & Stationery
  • Downtown

Librairie Antoine, the leading bookstore in Lebanon, returns to Beirut Souks with a visionary concept: Antoine iD. The ground floor features newspapers and magazines, publications about Lebanon,...

 

Apo Moda

  • Clothing
  • Bourj Hammoud

Apo Moda has a wide variety of clothing for women and specializes in pregnant women clothes. You can find very competitive prices there with stylish cuts and designs.

 

Assaha

  • Cafe, Restaurant
  • Ghobeiry

Assaha Lebanese traditional village is an authentic, cultural and touristic project symbolizing the real model of the Lebanese traditional village in its multi-artistic elements.