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

Spinneys Egypt - City Scape Ma...

Super Mall

Branch DetailsOpening Hours: 10:00AM - 12:00AMAddress: 6th October City, El Horria square, Cityscape Mall.Opening HoursFrom: 07:00 AM Till: 12:00 AM

Spinneys Egypt - City Stars

Branch DetailsOpening Hours: Week days: 10:00AM - 12:00AMThursdays: 10:00AM - 12:00AMFridays (winter season): 10:00AM – 12:00AMFridays (summer season): 10:00AM – 12:00AMAddress: Heliopolis, Omar Ibn Elkhatab St., City Stars, 1st Fl.Phone: +202 2 4802340-1-2-3-4-5-6Fax: +202 2 480...

Spinneys Egypt - Mall of Arabi...

Super Mall

Branch DetailsOpening Hours: Weekdays: 9:00AM - 12:00AMThursdays: 9:00AM - 12:00AMFridays (winter season): 10:00AM – 12:00AMFridays (summer season):10:00AM – 12:00AMAddress: 6th October City, Juhayna sq., Mall of Arabia

The Westown Hub

Super Mall

Westown Hub will be home to some of Cairo's finest restaurants and cafes. Set amongst pedestrian-friendly, landscaped squares and embellished with serene fountains and beautiful greenery, this is a place where one could have a small family retreat or catch up with friends and colleagues. Top brands ...

Carrefour Egypt - Maadi City C...

Super Mall

We strive to always provide the best quality and most diverse selection of household goods available in Egypt. Our value packs and combination discount offers means that we can offer these products at even lower costs, keeping your household essentials at unbeatable prices.Maadi City CenterKm28 Cair...

Carrefour Egypt - Dandy Mega M...

Super Mall

Porto Cairo Mall

Super Mall

Porto Cairo Mall is a new concept of shopping mixed with entertainment and the perfect location that could be reached from 10-15 minutes from anywhere in Cairo. Porto Cairo Mall has a variety of 180 shopping brand names that would suite the tastes of all mall visitors. In addition, the mall has...

Dandy

Super Mall

Dandy Test

Hyper One

Super Mall

Company Overview:Hyperone is one of the biggest hyper market chains in Egypt. Founded in 2005 by Mohamed El Hawary, Hyperone has 2 main branches, 6th of October in Western Cairo, and 10th of Ramadan on the Eastern outskirts. The current workforce in Hyperone consists of more than 2,500 employees. St...

Find

Title Venue Type

Our Venues

Time	Query
0.56ms	SELECT * FROM `sessions` WHERE `id` = '2KDJRgPBOxdYEUm9EXCHfV3VuUgMTxmljShFSUcv' LIMIT 1
0.57ms	SELECT * FROM `configs`
0.82ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.80ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.57ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.26ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.47ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
0.90ms	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.29ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.25ms	SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '52'
0.45ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '52' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0
0.15ms	SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'
0.60ms	SELECT * FROM `images` WHERE `link_id` = '42' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.26ms	SELECT * FROM `images` WHERE `link_id` = '41' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '40' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.21ms	SELECT * FROM `images` WHERE `link_id` = '37' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.19ms	SELECT * FROM `images` WHERE `link_id` = '36' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '35' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.19ms	SELECT * FROM `images` WHERE `link_id` = '27' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.10ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '20' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.26ms	SELECT * FROM `images` WHERE `link_id` = '17' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.10ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.44ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.29ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.21ms	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.28ms	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.20ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.52ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.18ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.35ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.34ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.25ms	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.26ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.20ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.15ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.22ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('2KDJRgPBOxdYEUm9EXCHfV3VuUgMTxmljShFSUcv', '1680389783', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"9Y8RWqMaLBzZuQKptfy457XlEOUA22H3Kv9ZMrne\";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.56ms

SELECT * FROM `sessions` WHERE `id` = '2KDJRgPBOxdYEUm9EXCHfV3VuUgMTxmljShFSUcv' LIMIT 1

0.57ms

SELECT * FROM `configs`

0.82ms

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

0.80ms

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

0.57ms

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

0.26ms

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

0.47ms

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

0.90ms

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

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

0.25ms

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

0.45ms

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

0.15ms

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

0.60ms

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

0.16ms

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

0.26ms

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

0.16ms

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

0.20ms

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

0.14ms

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

0.21ms

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

0.15ms

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

0.19ms

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

0.11ms

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

0.20ms

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

0.11ms

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

0.19ms

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

0.10ms

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

0.25ms

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

0.13ms

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

0.26ms

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

0.10ms

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

0.44ms

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

0.25ms

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

0.25ms

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

0.29ms

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

0.21ms

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

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

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

0.12ms

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

0.22ms

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

0.11ms

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

0.52ms

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

0.13ms

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

0.20ms

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

0.18ms

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

0.35ms

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

0.14ms

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

0.34ms

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

0.15ms

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

0.22ms

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

0.15ms

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

0.25ms

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

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

0.13ms

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

0.20ms

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

0.15ms

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

0.22ms

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

Spinneys Egypt - City Scape Ma...

Spinneys Egypt - City Stars

Spinneys Egypt - Mall of Arabi...

The Westown Hub

Carrefour Egypt - Maadi City C...

Carrefour Egypt - Dandy Mega M...

Porto Cairo Mall

Dandy

Hyper One

Sponsoreship

Find

Our Venues

Contact

Pages

Recent news

Subscribe