Abu Dhabi Small Group Day-Trip from Dubai

2026-07-26 8h-9h English

Please select your show time to proceed.

Please select at least one option to proceed.

1 Day Pass, anytime access from 9:00-18:00

There's no availability, please select a different date.

Abu Dhabi Small Group Day-Trip from Dubai

ENGLISH GROUP

Start Date :

Start Time:

Participants:

Price:

€ 0^.00

Total Price :

€ 0^.00

Included

Mineral cold water

Access to the Palace, Garden and other public spaces inside the Qasr Al Watan

Professional and licensed Guide

Clean, air-conditioned modern vehicle for transportation

Hotel Pick-up and Drop-off in central Dubai

Not Included

Lunch and Tips (only if required)

Guided tour inside Qasr Al Watan

Entrance to the Etihad Towers and the Emirates Palace

Advantages

Licensed Guides

Guaranteed Entrance

Mobile Voucher

Printed Voucher

Free Cancellation

Dubai

NEED HELP?

📥 Email us at:

hi@dotravel.com

FAQ

Is my payment secure?

How do I cancel my booking?

What is Your refund policy?

Can I make changes to my booking post-reservation?

How can I apply the promotion I received via email?

Do you store my credit card information in your system?

#	Time	Query
1	1.52 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	5.76 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.39 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.45 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30
5	0.69 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'products_status_booking' ORDER BY `id` DESC LIMIT 0 , 30
6	0.74 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3697 AND p.`status` = '23' AND p.`status_booking` = '9' ORDER BY `id` DESC
7	0.84 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
8	0.78 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3697 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
9	1.32 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'review_status' ORDER BY `id` DESC LIMIT 0 , 30
10	0.44 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
11	0.42 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3697 AND `status` = '26'
12	0.34 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
13	0.37 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
14	0.38 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
15	0.25 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
16	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3697 ORDER BY `show_order` asc LIMIT 0 , 30
17	0.38 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
18	0.59 ms	SELECT sb.*, lg.name as language, t.name as groupType ,t.id as groupTypeId,lg.id as languageId, pp.price as price,pp.id as priceId FROM `sub_product` sb inner join languages lg on sb.id_language = lg.id inner join type t on t.id = sb.type left join product_prices pp on pp.id_subproduct = sb.id...
19	0.37 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `status` = '15' ORDER BY `id_language` DESC LIMIT 0 , 30
20	0.25 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
21	0.52 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
22	0.4 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000
23	0.83 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3697 ORDER BY `id` DESC
24	0.56 ms	SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3697 AND `status` = '26'
25	0.44 ms	SELECT COUNT(*) FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') AND `id_product` = 3697
26	0.49 ms	select r.*, c.firstname , c.lastname,(select metavalue from customer_meta where id_customer = c.id and metaname = 'avatar') as avatar from reviews r inner join customers c on c.id = r.id_customer WHERE TRUE AND `id_product` = 3697 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5
27	0.28 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
28	0.36 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.3 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2353 ORDER BY `id` DESC LIMIT 0 , 30
30	0.26 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
31	0.29 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6677 ORDER BY `id` DESC LIMIT 0 , 30
32	0.31 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
33	0.28 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3697 ORDER BY `id` DESC LIMIT 0 , 30
34	0.45 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
35	0.38 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 3 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
36	0.37 ms	SELECT sb.*, t.name AS type_name FROM `subproduct_blockeddates` AS sb INNER JOIN `type` AS t ON sb.block_type = t.id WHERE t.`group` = 'subproduct_blockeddates_block_type' AND sb.`id_subproduct` = 2353 ORDER BY sb.`id` DESC
37	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'private' ORDER BY `id` DESC LIMIT 0 , 30
38	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
39	0.33 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 5 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
40	0.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
41	0.78 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30

Time

Query

1.52 ms

SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1

5.76 ms

INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...

0.39 ms

SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'

0.45 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30

0.69 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'products_status_booking' ORDER BY `id` DESC LIMIT 0 , 30

0.74 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3697 AND p.`status` = '23' AND p.`status_booking` = '9' ORDER BY `id` DESC

0.84 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000

0.78 ms

SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3697 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30

1.32 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'review_status' ORDER BY `id` DESC LIMIT 0 , 30

0.44 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30

0.42 ms

SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3697 AND `status` = '26'

0.34 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30

0.37 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30

0.38 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30

0.25 ms

SELECT * FROM `languages` WHERE TRUE AND `id` = 1

0.36 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3697 ORDER BY `show_order` asc LIMIT 0 , 30

0.38 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.59 ms

SELECT sb.*, lg.name as language, t.name as groupType ,t.id as groupTypeId,lg.id as languageId, pp.price as price,pp.id as priceId FROM `sub_product` sb inner join languages lg on sb.id_language = lg.id inner join type t on t.id = sb.type left join product_prices pp on pp.id_subproduct = sb.id...

0.37 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `status` = '15' ORDER BY `id_language` DESC LIMIT 0 , 30

0.25 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30

0.52 ms

SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC

0.4 ms

SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

0.83 ms

SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3697 ORDER BY `id` DESC

0.56 ms

SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3697 AND `status` = '26'

0.44 ms

SELECT COUNT(*) FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') AND `id_product` = 3697

0.49 ms

select r.*, c.firstname , c.lastname,(select metavalue from customer_meta where id_customer = c.id and metaname = 'avatar') as avatar from reviews r inner join customers c on c.id = r.id_customer WHERE TRUE AND `id_product` = 3697 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5

0.28 ms

SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'

0.36 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.3 ms

SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2353 ORDER BY `id` DESC LIMIT 0 , 30

0.26 ms

SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.29 ms

SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6677 ORDER BY `id` DESC LIMIT 0 , 30

0.31 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.28 ms

SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3697 ORDER BY `id` DESC LIMIT 0 , 30

0.45 ms

SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.38 ms

SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 3 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.37 ms

SELECT sb.*, t.name AS type_name FROM `subproduct_blockeddates` AS sb INNER JOIN `type` AS t ON sb.block_type = t.id WHERE t.`group` = 'subproduct_blockeddates_block_type' AND sb.`id_subproduct` = 2353 ORDER BY sb.`id` DESC

0.3 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'private' ORDER BY `id` DESC LIMIT 0 , 30

0.3 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30

0.33 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 5 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30

0.34 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3697 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30

0.78 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3697 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30