Venues

عمرو موسى 2012: موقع حملة عمرو موسى...More
Motaz Tours: Motaz Tours Egypt provide a very special diving program in Hurghada, Sharm El-Sheikh, Nuwbaa, Soma B......More
Mall of Arabia Cairo: Mall of Arabia is planned to hold:- 900 brands.- A free parking space to hold up to 9,000 cars.- 13 ......More
Al Riwaq Art Space - Bahrain: Situated in the neighbourhood of Adliya in Bahrain, Al Riwaq Art Space is dedicated to promoting loc......More
Albareh Art Gallery - Manama -...: Since opening its doors in 1998, an early pioneer in Bahrain and the Arabian Gulf, Albareh Art Galle......More

Category

H&M - Maadi City Center

Clothing

The H&M groupFrom a single women’s wear shop in Västerås, Sweden, to six different brands and 3,500 stores all around the world.H & M Hennes & Mauritz AB comprises six independent brands: H&M, COS, Monki, Weekday, Cheap Monday and & Other Stories.H&MH&M’s design team...

H&M - Dandy Mega Mall

Clothing

Mango - City Star

Clothing

Behind the brandAt Mango, our business goes beyond design, beyond manufacture and beyond the marketing of garments and accessories for women and men.Corporate Social ResponsibilityWe have taken the following steps to contribute to social improvement and to protect the environment.The MANGO storeAll ...

Mango - Mall of Arabia

Clothing

Mango - Mohandseen

Clothing

Quiz - Cairo Festival City Mal...

Clothing

Quiz is a dynamic fast fashion retail group that focuses on delivering catwalk style looks and all the latest trends at value for money prices. Our target audience is the fashion conscious women’s wear market. We aim to be exciting and innovative, offering our customers the fashions, footwear and ac...

Marks & Spencer - Cairo Festiv...

Clothing

Founded in 1884, M&S has grown from a single market stall to an international, multi-channel retailer. We sell stylish, high quality, great value clothing and home products, as well as outstanding quality food, responsibly sourced from around 3,000 suppliers globally90 Cairo Governorate, Cairo, ...

Tommy Hilfiger - Dandy Mega Ma...

Clothing

Tommy Hilfiger is one of the world’s leading designer lifestyle brands and is internationally recognized for celebrating the essence of classic American cool style, featuring preppy with a twist designs.Founded in 1985, Tommy Hilfiger delivers premium styling, quality and value to consumers wor...

Centre Point Egypt

Clothing

Centrepoint is a one stop shopping destination, with Babyshop, Splash, Lifestyle, Shoe Mart and more recently Beautybay under one roof. Centrepoint has become the 1st choice shopping destination for the whole family across the Middle East.The Centrepoint has been designed to reflect the dynamism and...

Find

Title Venue Type

Our Venues

Time	Query
0.38ms	SELECT * FROM `sessions` WHERE `id` = 'fC7AavNWwDWy34E09bpAB3XC9IhJ5q6L8dMCcrVe' LIMIT 1
0.35ms	SELECT * FROM `configs`
1.07ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.48ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.33ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.29ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.88ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
1.27ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.37ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.38ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.40ms	SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60'
0.45ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0
0.36ms	SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'
0.61ms	SELECT * FROM `images` WHERE `link_id` = '63' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.22ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.41ms	SELECT * FROM `images` WHERE `link_id` = '64' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.18ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '62' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.29ms	SELECT * FROM `images` WHERE `link_id` = '66' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.59ms	SELECT * FROM `images` WHERE `link_id` = '67' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.19ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.31ms	SELECT * FROM `images` WHERE `link_id` = '61' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '59' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.39ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.65ms	SELECT * FROM `images` WHERE `link_id` = '65' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.29ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.35ms	SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.22ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.77ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.45ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.26ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.76ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.48ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.30ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.35ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.34ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.48ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.29ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.19ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.17ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.24ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('fC7AavNWwDWy34E09bpAB3XC9IhJ5q6L8dMCcrVe', '1702017158', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"PUVRW0dXgjtovdJ33sajhW4CGp2RferIyH7nsJXm\";s:7:\"configs\";a:11:{s:9:\"site_name\";s:42:\"7awalaya - Hawalaya - حـواليــّه\";s:13:\"meta_keywords\";s:106:\"Events, Exhibitions, Offers, Coupons, 7awalaya, Android, Application, Mobile, Tablet, shopping, navigation\";s:16:\"meta_description\";s:237:\"RIGHT PLACE, RIGHT DEAL, RIGHT TIME\r\n7AWALAYA is a free mobile phone application that gives you deals and information from your favorite brands when you’re around the shopping point. No need to search for offers, they’ll come to you.\";s:8:\"facebook\";s:32:\"http://www.facebook.com/7awalaya\";s:7:\"twitter\";s:31:\"http://www.twitter.com/7awalaya\";s:10:\"googleplus\";s:27:\"http://google.com/+7awalaya\";s:13:\"contact_email\";s:17:\"info@7awalaya.com\";s:12:\"header_title\";s:8:\"7awalaya\";s:12:\"package_text\";s:29:\"Choose Package that suits you\";s:10:\"login_text\";s:35:\"Login with your E-mail and Password\";s:13:\"register_text\";s:33:\"Register with E-mail and Password\";}s:8:\"language\";s:2:\"en\";}')

Time

Query

0.38ms

SELECT * FROM `sessions` WHERE `id` = 'fC7AavNWwDWy34E09bpAB3XC9IhJ5q6L8dMCcrVe' LIMIT 1

0.35ms

SELECT * FROM `configs`

1.07ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5

0.48ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10

0.33ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5

0.29ms

SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5

0.88ms

SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC

1.27ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC

0.37ms

SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC

0.38ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC

0.40ms

SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60'

0.45ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0

0.36ms

SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'

0.61ms

SELECT * FROM `images` WHERE `link_id` = '63' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.22ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.41ms

SELECT * FROM `images` WHERE `link_id` = '64' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.18ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.32ms

SELECT * FROM `images` WHERE `link_id` = '62' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.16ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.29ms

SELECT * FROM `images` WHERE `link_id` = '66' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.15ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.59ms

SELECT * FROM `images` WHERE `link_id` = '67' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.19ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.31ms

SELECT * FROM `images` WHERE `link_id` = '61' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.15ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.28ms

SELECT * FROM `images` WHERE `link_id` = '59' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.39ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.65ms

SELECT * FROM `images` WHERE `link_id` = '65' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.29ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.35ms

SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.22ms

SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1

0.77ms

SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.45ms

SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.26ms

SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.76ms

SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.48ms

SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.30ms

SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.35ms

SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.13ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.24ms

SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.14ms

SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1

0.25ms

SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.12ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.20ms

SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.34ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.32ms

SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.16ms

SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1

0.28ms

SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.48ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.29ms

SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.12ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.20ms

SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.12ms

SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1

0.21ms

SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.12ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.25ms

SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.14ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.19ms

SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1

0.17ms

SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1

0.24ms

INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('fC7AavNWwDWy34E09bpAB3XC9IhJ5q6L8dMCcrVe', '1702017158', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"PUVRW0dXgjtovdJ33sajhW4CGp2RferIyH7nsJXm\";s:7:\"configs\";a:11:{s:9:\"site_name\";s:42:\"7awalaya - Hawalaya - حـواليــّه\";s:13:\"meta_keywords\";s:106:\"Events, Exhibitions, Offers, Coupons, 7awalaya, Android, Application, Mobile, Tablet, shopping, navigation\";s:16:\"meta_description\";s:237:\"RIGHT PLACE, RIGHT DEAL, RIGHT TIME\r\n7AWALAYA is a free mobile phone application that gives you deals and information from your favorite brands when you’re around the shopping point. No need to search for offers, they’ll come to you.\";s:8:\"facebook\";s:32:\"http://www.facebook.com/7awalaya\";s:7:\"twitter\";s:31:\"http://www.twitter.com/7awalaya\";s:10:\"googleplus\";s:27:\"http://google.com/+7awalaya\";s:13:\"contact_email\";s:17:\"info@7awalaya.com\";s:12:\"header_title\";s:8:\"7awalaya\";s:12:\"package_text\";s:29:\"Choose Package that suits you\";s:10:\"login_text\";s:35:\"Login with your E-mail and Password\";s:13:\"register_text\";s:33:\"Register with E-mail and Password\";}s:8:\"language\";s:2:\"en\";}')

7awalaya Shopping never being easier

Venues

H&M - Maadi City Center

H&M - Dandy Mega Mall

Mango - City Star

Mango - Mall of Arabia

Mango - Mohandseen

Quiz - Cairo Festival City Mal...

Marks & Spencer - Cairo Festiv...

Tommy Hilfiger - Dandy Mega Ma...

Centre Point Egypt

Sponsoreship

Find

Our Venues

Contact

Pages

Recent news

Subscribe