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 (select pa_CategoryID from Categories where pi_ParentID in (2)) 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 Shopping in Shops and Malls in Lebanon :: :: Beirut City Guide


  • Home Appliances
  • Downtown, Hazmieh

Samsung Service Center

  • Service Center, Computers & Devices
  • Amaret Chalhoub

ABC Mall

  • Mall
  • Achrafieh


  • 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 ...


2 Zareh

  • Clothing
  • Hamra

2 Zareh is a boutique in Hamra, where you can find the latest designs in fashion.



  • Clothing
  • Achrafieh

2Pieces is a small shop located in Achrafieh. Consisting mostly of bikinis of European and South American styles, these suits are specially decorated with exotic and brilliant colors. They also...


3F Electronics

  • Computers & Devices
  • Hamra, Zarif

Your ultimate technology store, 3F Electronics is a Lebanese company located in Beirut. This company was created by brothers, each of which is specialized in a field related to the activity of the...


4 Office

  • Furniture
  • Achrafieh

Good design and comfort should be available to everyone, everywhere! That's why you should visit 4 Office and benefit from its wide office furniture collection and check its different brands such as...


44 Souk An Najjarin

  • Antiques & Collectibles
  • Saifi

Having a vast passion for her job, Nadia El Khoury pushed the adventure further and opened “44 Souk An Najjarin”. Located in the Saifi village in the heart of Beirut city, you can find home...


460 The Multimedia Store

  • Computers & Devices
  • Achrafieh, Sin El-Fil

Computer Retail Store offering the world's leading IT brands. You can find at our stores the latest products from Apple, Toshiba, HP, Canon, Epson, Microsoft & Symantec. 460 The Multimedia Store...