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

Americana Plaza

Shopping & Retail

Americana Plaza is located in Sheikh Zayed, behind Hyper One market within 30 minutes by car from Lebanon Square.Americana Plaza has successfully assembled all of Americana’s restaurants in just one place alongside Plaza Cinemas, a 14-cinema complex which will host the first IMAX theater in Egy...

Zamalek FISH GARDEN (Genent El...

Shopping & Retail

Aquarium Grotto Garden 1867145 years later Khedawy Ismail had decided to establish this aquarium.It had been place for kings and Princes only.1902 had been opened for public for first time under supervision of central administration of zoos.حديقة الأسماك او حديقة الجبلاية, توجد في الزمالك&...

Joly Optics‬ - Mall of Arabia

Shopping & Retail

Joly Optics founded in 1997 as new brand in the eyewear market in Egypt.Joly Optics is among the leading companies for eyewear and stands out in the luxury sector for high quality of products, focus on details and a prestigious distribution network. In 2013, the company branches reach 30 in Egypt an...

Galleria 40

Shopping & Retail

The ultimate urban address, Galleria West Cairo is the first luxury shopping, dining, entertainment and business hub of its kind in Egypt.Designed to set a whole new standard for green building technology and smart infrastructure, it boasts some of the world’s most sought-after high-end brands,...

7awalaya - Alexandria - Egypt

Shopping & Retail

Hawas Design is a full-service agency that offers you a robust range of creative services to address a wide variety of marketing needs.Our services include:1• Brand strategy and development: logos and corporate ID.2• Indoor / Outdoor printing.3• Display stands.4•Print c...

7awalaya - Downtown - Cairo - ...

Shopping & Retail

7awalaya - Sheikh Zayed - Giza...

Shopping & Retail

7awalaya - حواليه ショッピングが簡単である...

Shopping & Retail

右折、右折、右折以前に見たことがないようなショッピング体験にようこそ。 7AWALAYAは、ショッピングポイントの周りにいるときにあなたのお気に入りのブランドからの情報や情報を提供する無料の携帯電話アプリケーションです。オファーを検索する必要はなく、彼らはあなたに来るでしょう。スパムはありません。お気に入りのブランドのみを選択します。必要な情報、必要なとき、必要な場所What＆Who＆Where製品は主に、イベント、クーポン、クーポンからユーザーの周りのすべての情報を取得するように設計されています。薬局 - 航空会社 - 銀行 - スポ...

Find

Title Venue Type

Our Venues

Time	Query
0.27ms	SELECT * FROM `sessions` WHERE `id` = 'NNP2lwJMgQ2sGj0Qx8IOukv6RGxDcpo1XvVS4oum' LIMIT 1
0.47ms	SELECT * FROM `configs`
0.70ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.50ms	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.26ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.48ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
1.51ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.34ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.47ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.27ms	SELECT COUNT(*) AS `aggregate` FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '56'
0.35ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `category_id` = '56' ORDER BY `created_at` DESC LIMIT 12 OFFSET 0
0.19ms	SELECT * FROM `categories` WHERE `published` = '1' AND `deleted` = '0'
0.46ms	SELECT * FROM `images` WHERE `link_id` = '69' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.53ms	SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.17ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '60' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.19ms	SELECT * FROM `images` WHERE `link_id` = '43' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.11ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '16' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.12ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.20ms	SELECT * FROM `images` WHERE `link_id` = '15' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.72ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.45ms	SELECT * FROM `images` WHERE `link_id` = '14' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.30ms	SELECT * FROM `categories` WHERE `id` = '56' 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.46ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.31ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.30ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.43ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.37ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.17ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.27ms	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.29ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.27ms	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.91ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.29ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.30ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.34ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.48ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.20ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.76ms	SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.42ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.17ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.20ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.14ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.21ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('NNP2lwJMgQ2sGj0Qx8IOukv6RGxDcpo1XvVS4oum', '1726121326', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"qBejS5Ca7cJVWis3G3Sxbw3xseRs59x3rZaJpbAG\";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.27ms

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

0.47ms

SELECT * FROM `configs`

0.70ms

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

0.50ms

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

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

0.48ms

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

1.51ms

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

0.34ms

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

0.47ms

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

0.27ms

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

0.35ms

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

0.19ms

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

0.46ms

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

0.28ms

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

0.53ms

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

0.17ms

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

0.24ms

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

0.14ms

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

0.19ms

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

0.11ms

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

0.24ms

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

0.12ms

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

0.20ms

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

0.72ms

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

0.45ms

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

0.30ms

SELECT * FROM `categories` WHERE `id` = '56' 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.46ms

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

0.31ms

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

0.28ms

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

0.30ms

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

0.43ms

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

0.32ms

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

0.37ms

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

0.17ms

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

0.27ms

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

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

0.16ms

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

0.28ms

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

0.15ms

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

0.27ms

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

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

0.29ms

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

0.30ms

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

0.34ms

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

0.48ms

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

0.20ms

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

0.76ms

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

0.42ms

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

0.32ms

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

0.17ms

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

0.20ms

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

0.14ms

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

0.21ms

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

Americana Plaza

Zamalek FISH GARDEN (Genent El...

Joly Optics‬ - Mall of Arabia

Galleria 40

7awalaya - Alexandria - Egypt

7awalaya - Downtown - Cairo - ...

7awalaya - Sheikh Zayed - Giza...

7awalaya - حواليه ショッピングが簡単である...

Sponsoreship

Find

Our Venues

Contact

Pages

Recent news

Subscribe