or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

Sign up to our newsletter and become the first to know about our latest deals and promotions

Aqua Expeditions
Aqua Mekong
Aqua Mekong

Valid: 21 Jan 2019 - 28 Feb 2019

4-Nights accommodation aboard the elegant Aqua Mekong
All meals whilst on board
Beverages on board (non-alcoholic,premium wines & beer)
All shore excursions - 10 guests per guide
Complimentary laundry service
Ten bicycles for guests to explore independently on shore
Wireless internet (intermittent satellite connection)
Group Transfers

3-Nights pre-cruise accommodation at Intercontinental Saigon Hotel, Ho Chi Minh (Saigon) ~ includes breakfast
3-Nights post-cruise accommodation at Amanjaya Pancam Hotel, Phnom Penh ~ includes breakfast
Private Full Day Ho Chi Minh & Cu Chi Tunnels Excursion
Full Day Phnom Penh Tour
Private transfer – Saigon Airport to Hotel – Hotel to Park Hyatt Saigon – Dock to Hotel – Hotel to Phnom Penh Hotel

Special Conditions

Cruise costs are in New Zealand Dollars (NZD). Offer subject to availability at time of booking. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Subject to availability and currency fluctuations. All fares and taxes are subject to change without notice up until full payment is received. Itinerary may be subject to change. Credit card payments will incur a fee. Cruise deposit, amendment and cancellation conditions apply. Travel agent service fees may apply. Special conditions apply - please ask for full details at time of enquiry. Cruise Line reserves the right to re-instate the fuel supplement for all guests up to US$9 per person per day if the price of light sweet crude on the New York Mercantile Exchange (NYMEX) exceeds US$70 per barrel. Please consult cruise line website for current information.

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 88

Total elapsed time: 0.14753723144531

# Query Time
(1) connect 0.00097107887268066
(2) DESCRIBE `specials` 0.007072925567627
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '10-night-aqua-mekong-explorer-cruise-package-from-ho-chi-minh-to-phnom-penh') AND (orchid_available = 1) LIMIT 1 0.0016391277313232
(4) DESCRIBE `cruises` 0.0040931701660156
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48300))) 0.0007021427154541
(6) DESCRIBE `avid_specials` 0.002032995223999
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524694 and class = 'Special') OR (item_id = 48300 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018970966339111
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524694') 0.00049519538879395
(9) DESCRIBE `ships` 0.0040700435638428
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00076603889465332
(11) DESCRIBE `ships` 0.004141092300415
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00060915946960449
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036907196044922
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035595893859863
(15) DESCRIBE `itineraries` 0.0019829273223877
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '48300') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011308193206787
(17) DESCRIBE `ports` 0.0021798610687256
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00082492828369141
(19) DESCRIBE `ports` 0.0021982192993164
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00057005882263184
(21) DESCRIBE `ports` 0.0025491714477539
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00053811073303223
(23) DESCRIBE `specialsailingdates` 0.0017781257629395
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1524694') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00085997581481934
(25) DESCRIBE `sailingdates` 0.0019590854644775
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485045))) 0.00043582916259766
(27) DESCRIBE `ports` 0.0020549297332764
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00073099136352539
(29) DESCRIBE `ports` 0.0020999908447266
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00059819221496582
(31) DESCRIBE `ports` 0.0020551681518555
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00052499771118164
(33) DESCRIBE `ports` 0.0019400119781494
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00042510032653809
(35) DESCRIBE `ports` 0.002316951751709
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00051212310791016
(37) DESCRIBE `ports` 0.0019030570983887
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00046896934509277
(39) DESCRIBE `ports` 0.0020279884338379
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.0004889965057373
(41) DESCRIBE `ports` 0.0019130706787109
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00043296813964844
(43) DESCRIBE `ports` 0.0019180774688721
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00046992301940918
(45) DESCRIBE `ports` 0.0020101070404053
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00046992301940918
(47) DESCRIBE `ports` 0.0021898746490479
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00054287910461426
(49) DESCRIBE `ports` 0.002094030380249
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00046396255493164
(51) DESCRIBE `ports` 0.0020380020141602
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00056099891662598
(53) DESCRIBE `ports` 0.0018460750579834
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00047397613525391
(55) DESCRIBE `specialsmultipricing` 0.0021288394927979
(56) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1524694' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00056719779968262
(57) DESCRIBE `leadpricing` 0.0018200874328613
(58) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1524694') LIMIT 1 0.00047397613525391
(59) DESCRIBE `specialspricing` 0.0019180774688721
(60) SELECT `specialspricing`.* FROM `specialspricing` WHERE (special_id = '1524694') 0.00088787078857422
(61) DESCRIBE `cabins` 0.0019700527191162
(62) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 10573))) 0.00039386749267578
(63) DESCRIBE `currencies` 0.0016160011291504
(64) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00041794776916504
(65) DESCRIBE `cruiselines` 0.0027151107788086
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00052094459533691
(67) DESCRIBE `orchid_image` 0.0021288394927979
(68) DESCRIBE `cruiselines` 0.0027000904083252
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00047111511230469
(70) DESCRIBE `cruises` 0.0040099620819092
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48300') 0.00053715705871582
(72) DESCRIBE `deckplans` 0.0019371509552002
(73) DESCRIBE `cabins` 0.0020809173583984
(74) DESCRIBE `shipphotos` 0.0020151138305664
(75) DESCRIBE `cruiselines` 0.0026650428771973
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00064611434936523
(77) DESCRIBE `orchid_image` 0.002288818359375
(78) DESCRIBE `cruiselines` 0.0027670860290527
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00049996376037598
(80) DESCRIBE `cruises` 0.0037300586700439
(81) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 63940, 71423, 63941, 43678, 67915, 75085)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,63940,71423,63941,43678,67915,75085') 0.0019030570983887
(82) DESCRIBE `cruiselines` 0.0024552345275879
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') 0.0019130706787109
(84) DESCRIBE `ships` 0.0037789344787598
(85) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') 0.0052821636199951
(86) DESCRIBE `cruisetypes` 0.0017759799957275
(87) DESCRIBE `destinations` 0.0023908615112305
(88) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') 0.0023369789123535