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

Windstar Cruises
Star Legend
Star Legend

Valid: 18 Feb 2019 - 28 Feb 2019

10-Night yacht cruise aboard Star Legend
Accommodation in an oceanview stateroom.
Superb dining, with all main meals included during your cruise.
Non-alcoholic beverages, including specialty tea and coffee drinks.
Onboard entertainment, including local performances in most regions.
Port taxes and government fees.

Popular Highlights:
• Discover the beauty of UNESCO site Mount Fuji, Japan's highest mountain, when you get to Shimizu
• Highlights of Busan to visit include Gyeongju, a UNESCO site and 1,500-year-old Tongdosa Temple
• Explore Shingu's UNESCO site Makimura-jinja Shrine, part of the Sacred Sites of Pilgrimage Routes in the Kii Mountain Range
• Respectfully remember "Never Again" at the Peace Memorial Parks of Nagasaki and Hiroshima
• Enjoy the cuisine of Hiroshima, with not-to-be-missed Okonomiyaki savory pancakes
• See the 16th century Osaka Castle, the city's main historic landmark

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. Prices are subject to currency fluctuations and are based on cash or cheque. Itinerary changes may apply. 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: 103

Total elapsed time: 0.2590639591217

# Query Time
(1) connect 0.0010650157928467
(2) DESCRIBE `specials` 0.0066537857055664
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '10-night-grand-japan-yacht-cruise-from-tokyo-to-osaka') AND (orchid_available = 1) LIMIT 1 0.0055778026580811
(4) DESCRIBE `cruises` 0.0038249492645264
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75087))) 0.00068497657775879
(6) DESCRIBE `avid_specials` 0.0020401477813721
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535086 and class = 'Special') OR (item_id = 75087 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 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.0020489692687988
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535086') 0.00038790702819824
(9) DESCRIBE `ships` 0.0037460327148438
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00073099136352539
(11) DESCRIBE `ships` 0.0041038990020752
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00066399574279785
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041317939758301
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(15) DESCRIBE `itineraries` 0.0019011497497559
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75087') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010778903961182
(17) DESCRIBE `ports` 0.0023910999298096
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00050210952758789
(19) DESCRIBE `ports` 0.0020439624786377
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00050711631774902
(21) DESCRIBE `ports` 0.0020291805267334
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00043988227844238
(23) DESCRIBE `specialsailingdates` 0.0016908645629883
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1535086') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0012068748474121
(25) DESCRIBE `sailingdates` 0.0019600391387939
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474261))) 0.00049304962158203
(27) DESCRIBE `ports` 0.0017569065093994
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00046706199645996
(29) DESCRIBE `ports` 0.0018558502197266
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00040698051452637
(31) DESCRIBE `ports` 0.0017459392547607
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00046706199645996
(33) DESCRIBE `ports` 0.0019528865814209
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00041913986206055
(35) DESCRIBE `ports` 0.0017600059509277
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) 0.00046491622924805
(37) DESCRIBE `ports` 0.0019040107727051
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') 0.00044512748718262
(39) DESCRIBE `ports` 0.0017950534820557
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00049996376037598
(41) DESCRIBE `ports` 0.0019819736480713
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00042200088500977
(43) DESCRIBE `ports` 0.0017118453979492
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00062394142150879
(45) DESCRIBE `ports` 0.0021181106567383
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00046014785766602
(47) DESCRIBE `ports` 0.0020260810852051
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00065994262695312
(49) DESCRIBE `ports` 0.0018851757049561
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00043201446533203
(51) DESCRIBE `ports` 0.0020649433135986
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.00046777725219727
(53) DESCRIBE `ports` 0.0018739700317383
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.00041484832763672
(55) DESCRIBE `ports` 0.0019819736480713
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00043892860412598
(57) DESCRIBE `ports` 0.0021698474884033
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00046205520629883
(59) DESCRIBE `ports` 0.0023620128631592
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) 0.00053215026855469
(61) DESCRIBE `ports` 0.001924991607666
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') 0.00062990188598633
(63) DESCRIBE `ports` 0.0022380352020264
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00052785873413086
(65) DESCRIBE `ports` 0.0018999576568604
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00058293342590332
(67) DESCRIBE `specialsmultipricing` 0.0016989707946777
(68) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1535086' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00049805641174316
(69) DESCRIBE `leadpricing` 0.0017340183258057
(70) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1535086') LIMIT 1 0.00051999092102051
(71) DESCRIBE `specialspricing` 0.0025508403778076
(72) SELECT `specialspricing`.* FROM `specialspricing` WHERE (special_id = '1535086') 0.001410961151123
(73) DESCRIBE `cabins` 0.0035159587860107
(74) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11433))) 0.00058197975158691
(75) DESCRIBE `currencies` 0.0015428066253662
(76) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00038599967956543
(77) DESCRIBE `cruiselines` 0.0028479099273682
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00056099891662598
(79) DESCRIBE `orchid_image` 0.0023701190948486
(80) DESCRIBE `cruiselines` 0.0029928684234619
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00063705444335938
(82) DESCRIBE `cruises` 0.0041179656982422
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75087') 0.00053691864013672
(84) DESCRIBE `deckplans` 0.0018980503082275
(85) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '1266') ORDER BY `level` ASC 0.0079870223999023
(86) DESCRIBE `cabins` 0.0019810199737549
(87) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '1266') ORDER BY `cabin_order` ASC 0.079437017440796
(88) DESCRIBE `shipphotos` 0.0020368099212646
(89) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '1266') 0.0024111270904541
(90) DESCRIBE `cruiselines` 0.0029258728027344
(91) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00058889389038086
(92) DESCRIBE `orchid_image` 0.0021309852600098
(93) DESCRIBE `cruiselines` 0.0031149387359619
(94) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00051283836364746
(95) DESCRIBE `cruises` 0.0046350955963135
(96) 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.0019299983978271
(97) DESCRIBE `cruiselines` 0.00313401222229
(98) 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.0019409656524658
(99) DESCRIBE `ships` 0.0038161277770996
(100) 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.0053808689117432
(101) DESCRIBE `cruisetypes` 0.001849889755249
(102) DESCRIBE `destinations` 0.0028879642486572
(103) 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.0025968551635742