or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

 
VIEW & VERANDAH Move up, get more - Upgrade Event Book selected 2018/19 Cruises or Land+Sea journeys and receive stateroom upgrades, on board credit and discounts off shore excursions. T&C's apply.
Holland America Line
Volendam
Volendam

Valid: 12 Feb 2018 - 23 Feb 2018

14-Nights accommodation aboard the elegant ms Volendam
Superb dining with all meals included during your cruise
Additional Dining options; Pinnacle Grill (US$39 per person), Canaletto (US$15 per person)
Entertainment and activities while cruising
Kids Club for 3-17 years old
Choice of bars throughout the cruise
Cruise, port charges and government taxes

Special Conditions

All fares mentioned are per person, in NZ dollars; cruise only, based on double occupancy in stated stateroom categories, and includes Taxes, Fees & Port Expenses and all applicable discounts (correct as at 12/02/18). Air travel and suggested onboard gratuities are additional. Fares and deposits are non-refundable and final payment is due within 24 hours of booking. Offer is capacity controlled and not combinable with groups, View & Verandah, or other major promotional offers. For new bookings only. Special conditions, currency fluctuations and availability restrictions apply. Other restrictions may apply. Sale is from 09 February to 23 February 2018.

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: 123

Total elapsed time: 0.12270474433899

# Query Time
(1) connect 0.00048398971557617
(2) DESCRIBE `specials` 0.0028519630432129
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '14-night-majestic-japan-and-china-premium-cruise-from-shanghai-to-yokohama') AND (orchid_available = 1) LIMIT 1 0.0020508766174316
(4) DESCRIBE `cruises` 0.0021481513977051
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 61590))) 0.00056791305541992
(6) DESCRIBE `avid_specials` 0.00083112716674805
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1400843 and class = 'Special') OR (item_id = 61590 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 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.00095295906066895
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1400843') 0.00021100044250488
(9) DESCRIBE `ships` 0.0016098022460938
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00027608871459961
(11) DESCRIBE `ships` 0.0016751289367676
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00024199485778809
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020718574523926
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(15) DESCRIBE `itineraries` 0.00069618225097656
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61590') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072002410888672
(17) DESCRIBE `ports` 0.0011618137359619
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00024294853210449
(19) DESCRIBE `ports` 0.00064802169799805
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00024509429931641
(21) DESCRIBE `ports` 0.00099897384643555
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00022697448730469
(23) DESCRIBE `specialsailingdates` 0.0012538433074951
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1400843') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00061702728271484
(25) DESCRIBE `sailingdates` 0.00081014633178711
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 389423))) 0.0002589225769043
(27) DESCRIBE `ports` 0.00075817108154297
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00027084350585938
(29) DESCRIBE `ports` 0.00080585479736328
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00023007392883301
(31) DESCRIBE `ports` 0.00076699256896973
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00045990943908691
(33) DESCRIBE `ports` 0.0011520385742188
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00029802322387695
(35) DESCRIBE `ports` 0.0027840137481689
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1429))) 0.00034308433532715
(37) DESCRIBE `ports` 0.00078010559082031
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1429') 0.00020694732666016
(39) DESCRIBE `ports` 0.00096607208251953
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00027108192443848
(41) DESCRIBE `ports` 0.00078988075256348
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00020599365234375
(43) DESCRIBE `ports` 0.00061988830566406
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00023198127746582
(45) DESCRIBE `ports` 0.00064802169799805
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00017499923706055
(47) DESCRIBE `ports` 0.00068092346191406
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00022292137145996
(49) DESCRIBE `ports` 0.0008080005645752
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00023198127746582
(51) DESCRIBE `ports` 0.00086092948913574
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4475))) 0.00025486946105957
(53) DESCRIBE `ports` 0.0012519359588623
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4475') 0.00022101402282715
(55) DESCRIBE `ports` 0.00063490867614746
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 190))) 0.00021505355834961
(57) DESCRIBE `ports` 0.00082492828369141
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '190') 0.00025510787963867
(59) DESCRIBE `ports` 0.00072693824768066
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00022387504577637
(61) DESCRIBE `ports` 0.00069308280944824
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00022697448730469
(63) DESCRIBE `ports` 0.00073480606079102
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00026679039001465
(65) DESCRIBE `ports` 0.00067710876464844
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00025105476379395
(67) DESCRIBE `ports` 0.00078701972961426
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00025796890258789
(69) DESCRIBE `ports` 0.00084805488586426
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00022697448730469
(71) DESCRIBE `specialsmultipricing` 0.00063800811767578
(72) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1400843' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.0002899169921875
(73) DESCRIBE `leadpricing` 0.00060296058654785
(74) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1400843') LIMIT 1 0.00022697448730469
(75) DESCRIBE `specialspricing` 0.00072312355041504
(76) SELECT `specialspricing`.* FROM `specialspricing` WHERE (special_id = '1400843') 0.00055193901062012
(77) DESCRIBE `cabins` 0.0010919570922852
(78) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2944))) 0.00032687187194824
(79) DESCRIBE `cabins` 0.0006868839263916
(80) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12075))) 0.00026297569274902
(81) DESCRIBE `cabins` 0.00068402290344238
(82) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2949))) 0.00018310546875
(83) DESCRIBE `cabins` 0.00061702728271484
(84) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2958))) 0.00017905235290527
(85) DESCRIBE `cabins` 0.00060296058654785
(86) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7413))) 0.00021886825561523
(87) DESCRIBE `currencies` 0.00063204765319824
(88) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00017499923706055
(89) DESCRIBE `currencies` 0.00050902366638184
(90) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00016212463378906
(91) DESCRIBE `currencies` 0.00053882598876953
(92) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00016498565673828
(93) DESCRIBE `currencies` 0.00054097175598145
(94) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00019001960754395
(95) DESCRIBE `currencies` 0.00060009956359863
(96) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00016403198242188
(97) DESCRIBE `cruiselines` 0.00091290473937988
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00020694732666016
(99) DESCRIBE `orchid_image` 0.00081205368041992
(100) DESCRIBE `cruiselines` 0.00092720985412598
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00027298927307129
(102) DESCRIBE `cruises` 0.0018930435180664
(103) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61590') 0.0003209114074707
(104) DESCRIBE `deckplans` 0.00075507164001465
(105) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '82') ORDER BY `level` ASC 0.0031437873840332
(106) DESCRIBE `cabins` 0.0012369155883789
(107) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '82') ORDER BY `cabin_order` ASC 0.029828071594238
(108) DESCRIBE `shipphotos` 0.0011050701141357
(109) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '82') 0.0015950202941895
(110) DESCRIBE `cruiselines` 0.0014758110046387
(111) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00034999847412109
(112) DESCRIBE `orchid_image` 0.00096893310546875
(113) DESCRIBE `cruiselines` 0.001166820526123
(114) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00025391578674316
(115) DESCRIBE `cruises` 0.0028080940246582
(116) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63786, 63787, 40591, 40596, 68831, 40593, 57675, 57673, 57674, 66748)) ORDER BY FIND_IN_SET(id, '63786,63787,40591,40596,68831,40593,57675,57673,57674,66748') 0.0016250610351562
(117) DESCRIBE `cruiselines` 0.0017879009246826
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('213', '191', '23', '33', '18', '26', '114', '15', '212', '216', '8', '101', '151', '91', '218', '28', '37', '14', '20', '29', '19', '24', '187', '258')) ORDER BY FIND_IN_SET(id, '213,191,23,33,18,26,114,15,212,216,8,101,151,91,218,28,37,14,20,29,19,24,187,258') 0.0013599395751953
(119) DESCRIBE `ships` 0.0024280548095703
(120) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '1347', '1032', '1023', '163', '547', '1266', '1385', '1539', '855', '78', '780', '262', '451', '1013', '1282', '1526', '1579', '542', '616', '1154', '1672', '75', '82', '98', '258', '287', '290', '332', '341', '406', '580', '585', '678', '683', '790', '850', '968', '1022', '1029', '1135', '1402', '43', '74', '84', '105', '111', '223', '253', '286', '291', '335', '348', '349', '352', '389', '403', '404', '508', '573', '582', '652', '657', '711', '722', '748', '770', '776', '884', '888', '966', '1108', '1163', '1189', '1223', '1285', '1302', '1308', '1319', '1320', '1323', '1325', '1409', '1413', '1571')) ORDER BY FIND_IN_SET(id, '1205,1347,1032,1023,163,547,1266,1385,1539,855,78,780,262,451,1013,1282,1526,1579,542,616,1154,1672,75,82,98,258,287,290,332,341,406,580,585,678,683,790,850,968,1022,1029,1135,1402,43,74,84,105,111,223,253,286,291,335,348,349,352,389,403,404,508,573,582,652,657,711,722,748,770,776,884,888,966,1108,1163,1189,1223,1285,1302,1308,1319,1320,1323,1325,1409,1413,1571') 0.0032129287719727
(121) DESCRIBE `cruisetypes` 0.0010480880737305
(122) DESCRIBE `destinations` 0.0014910697937012
(123) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '22', '54', '55', '8', '35', '12', '39', '50', '11', '21', '26', '40', '48', '25', '37', '49', '29', '53')) ORDER BY FIND_IN_SET(id, '2,43,22,54,55,8,35,12,39,50,11,21,26,40,48,25,37,49,29,53') 0.00086402893066406