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.21ms	SELECT * FROM `sessions` WHERE `id` = 'tzNXuHv4EDaZW2mvrptM1DuP13s8KnjPXPE301aY' LIMIT 1
0.42ms	SELECT * FROM `configs`
0.57ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.62ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.31ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.21ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.44ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
1.21ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.27ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.34ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.29ms	SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60'
0.34ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '60' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0
0.16ms	SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'
0.43ms	SELECT * FROM `images` WHERE `link_id` = '63' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '64' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '62' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.10ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '66' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.17ms	SELECT * FROM `images` WHERE `link_id` = '67' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.19ms	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.19ms	SELECT * FROM `images` WHERE `link_id` = '59' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.27ms	SELECT * FROM `images` WHERE `link_id` = '65' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.35ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.19ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.19ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.35ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '44' 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` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.26ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.27ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.25ms	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.14ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.23ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.18ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.26ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('tzNXuHv4EDaZW2mvrptM1DuP13s8KnjPXPE301aY', '1680393246', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"lrKSKg0CkpBLRnmWbYA0gKHRUtiDuJNDhVS8X7Gb\";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.21ms

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

0.42ms

SELECT * FROM `configs`

0.57ms

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

0.62ms

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

0.31ms

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

0.21ms

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

0.44ms

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

1.21ms

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

0.27ms

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

0.34ms

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

0.29ms

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

0.34ms

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

0.16ms

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

0.43ms

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

0.16ms

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

0.24ms

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

0.12ms

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

0.21ms

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

0.10ms

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

0.22ms

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

0.11ms

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

0.17ms

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

0.12ms

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

0.19ms

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.19ms

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

0.12ms

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

0.27ms

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

0.15ms

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

0.21ms

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

0.11ms

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

0.35ms

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

0.21ms

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

0.19ms

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

0.19ms

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

0.35ms

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

0.21ms

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

0.23ms

SELECT * FROM `images` WHERE `link_id` = '44' 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` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.14ms

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

0.26ms

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

0.13ms

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

0.23ms

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

0.14ms

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

0.25ms

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

0.13ms

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

0.27ms

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

0.13ms

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

0.25ms

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

0.13ms

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

0.25ms

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.14ms

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

0.23ms

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

0.12ms

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

0.23ms

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

0.18ms

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

0.26ms

INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('tzNXuHv4EDaZW2mvrptM1DuP13s8KnjPXPE301aY', '1680393246', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"lrKSKg0CkpBLRnmWbYA0gKHRUtiDuJNDhVS8X7Gb\";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