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.28ms	SELECT * FROM `sessions` WHERE `id` = 'TtjczPsAFSkMFg5OXHxklePfeaGh2X4W1GDVxD7k' LIMIT 1
0.29ms	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.57ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.46ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.25ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.63ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
1.02ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.33ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.36ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.31ms	SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '52'
0.48ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '52' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0
0.33ms	SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'
0.44ms	SELECT * FROM `images` WHERE `link_id` = '42' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '41' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '40' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '37' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
1.06ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.51ms	SELECT * FROM `images` WHERE `link_id` = '36' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '35' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.30ms	SELECT * FROM `images` WHERE `link_id` = '27' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.19ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.33ms	SELECT * FROM `images` WHERE `link_id` = '20' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.18ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.27ms	SELECT * FROM `images` WHERE `link_id` = '17' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.92ms	SELECT * FROM `categories` WHERE `id` = '52' LIMIT 1
0.40ms	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.24ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '13' 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.29ms	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.29ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	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.17ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.10ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.25ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.10ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.24ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	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.14ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.26ms	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 ('TtjczPsAFSkMFg5OXHxklePfeaGh2X4W1GDVxD7k', '1702012896', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"489wGd18YJzMc7XNWEQrGXAecVteAvuTqmC9zU14\";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.28ms

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

0.29ms

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

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

0.46ms

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

0.25ms

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

0.63ms

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

1.02ms

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

0.33ms

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

0.36ms

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

0.31ms

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

0.48ms

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

0.33ms

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

0.44ms

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

0.15ms

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

0.25ms

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

0.15ms

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

0.23ms

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

0.28ms

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

0.23ms

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

1.06ms

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

0.51ms

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

0.15ms

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

0.32ms

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

0.15ms

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

0.30ms

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

0.19ms

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

0.33ms

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

0.18ms

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

0.27ms

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

0.92ms

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

0.40ms

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

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

0.28ms

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

0.25ms

SELECT * FROM `images` WHERE `link_id` = '13' 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.29ms

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

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

0.11ms

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

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

0.22ms

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

0.10ms

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

0.25ms

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

0.11ms

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

0.22ms

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

0.10ms

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

0.23ms

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

0.24ms

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

0.22ms

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

0.13ms

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

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

0.26ms

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 ('TtjczPsAFSkMFg5OXHxklePfeaGh2X4W1GDVxD7k', '1702012896', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"489wGd18YJzMc7XNWEQrGXAecVteAvuTqmC9zU14\";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