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

Princess Cruises
Sun Princess
Sun Princess

Sun Princess

Sun Princess truly lights up the seas, serving up tantalizing cuisine, dazzling live entertainment and new experiences with our Discovery at SEA™ programs. Relax in The Sanctuary, a tranquil haven reserved for adults, or put your feet up at Movies Under the Stars®, whatever you decide to do, your time on board will be unforgettable.

Detailed information about Sun Princess

Star Rating 4 Star
Currency Used

Australian Dollars

Cruise Type Contemporary
Maiden Voyage December 1995
Refurbished April 2016
Tonnage 77,441 tonnes
Length 856 ft
Beam 106 ft
Draft 26 ft
Passenger Capacity 2000
Crew Nationality International
Cuisine International

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

Total elapsed time: 0.31275868415833

# Query Time
(1) connect 0.00084805488586426
(2) DESCRIBE `specials` 0.006303071975708
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0015478134155273
(4) DESCRIBE `cruises` 0.0040481090545654
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.0012168884277344
(6) DESCRIBE `avid_specials` 0.0021340847015381
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1490159 and class = 'Special') OR (item_id = 79643 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 40 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.002047061920166
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.00056791305541992
(9) DESCRIBE `ships` 0.0037260055541992
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00068902969360352
(11) DESCRIBE `ships` 0.0041310787200928
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.0005030632019043
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048112869262695
(15) DESCRIBE `itineraries` 0.0019419193267822
(16) DESCRIBE `ports` 0.0027000904083252
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066208839416504
(18) DESCRIBE `ports` 0.0021169185638428
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046610832214355
(20) DESCRIBE `ports` 0.0019361972808838
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004279613494873
(22) DESCRIBE `specialsailingdates` 0.0016350746154785
(23) DESCRIBE `sailingdates` 0.0018150806427002
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.00047206878662109
(25) DESCRIBE `ports` 0.0019490718841553
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044608116149902
(27) DESCRIBE `ports` 0.0018711090087891
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043106079101562
(29) DESCRIBE `ports` 0.0020229816436768
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048398971557617
(31) DESCRIBE `ports` 0.002086877822876
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00043392181396484
(33) DESCRIBE `ports` 0.0020430088043213
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0005497932434082
(35) DESCRIBE `ports` 0.0019781589508057
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00042605400085449
(37) DESCRIBE `ports` 0.0018548965454102
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00049304962158203
(39) DESCRIBE `ports` 0.0020139217376709
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00048995018005371
(41) DESCRIBE `ports` 0.0019550323486328
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00051283836364746
(43) DESCRIBE `ports` 0.0023338794708252
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00049781799316406
(45) DESCRIBE `ports` 0.0020251274108887
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0004880428314209
(47) DESCRIBE `ports` 0.002047061920166
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00051379203796387
(49) DESCRIBE `ports` 0.0023298263549805
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.0005340576171875
(51) DESCRIBE `ports` 0.0022580623626709
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00043797492980957
(53) DESCRIBE `ports` 0.0021519660949707
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00069785118103027
(55) DESCRIBE `ports` 0.0020477771759033
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00038790702819824
(57) DESCRIBE `ports` 0.0015959739685059
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00042104721069336
(59) DESCRIBE `ports` 0.001924991607666
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00047993659973145
(61) DESCRIBE `ports` 0.001863956451416
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00062203407287598
(63) DESCRIBE `ports` 0.0020852088928223
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00043296813964844
(65) DESCRIBE `ports` 0.0021359920501709
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00057792663574219
(67) DESCRIBE `ports` 0.0019059181213379
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00046896934509277
(69) DESCRIBE `ports` 0.0018880367279053
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00046515464782715
(71) DESCRIBE `ports` 0.002039909362793
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00047087669372559
(73) DESCRIBE `ports` 0.0019831657409668
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00047802925109863
(75) DESCRIBE `ports` 0.0019149780273438
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00040006637573242
(77) DESCRIBE `ports` 0.0027651786804199
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00051498413085938
(79) DESCRIBE `ports` 0.0020630359649658
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00068306922912598
(81) DESCRIBE `ports` 0.0020642280578613
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00061798095703125
(83) DESCRIBE `ports` 0.002007007598877
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0006871223449707
(85) DESCRIBE `ports` 0.0020248889923096
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00049710273742676
(87) DESCRIBE `ports` 0.0020160675048828
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00053501129150391
(89) DESCRIBE `ports` 0.0021369457244873
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00056099891662598
(91) DESCRIBE `ports` 0.0021300315856934
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00045013427734375
(93) DESCRIBE `ports` 0.0030019283294678
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0005490779876709
(95) DESCRIBE `ports` 0.0020859241485596
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00095796585083008
(97) DESCRIBE `ports` 0.0027670860290527
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0010428428649902
(99) DESCRIBE `ports` 0.0023250579833984
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0006260871887207
(101) DESCRIBE `ports` 0.0031609535217285
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0038080215454102
(103) DESCRIBE `ports` 0.0020859241485596
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00046992301940918
(105) DESCRIBE `ports` 0.003352165222168
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0019450187683105
(107) DESCRIBE `ports` 0.0037269592285156
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00064802169799805
(109) DESCRIBE `ports` 0.0021531581878662
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00061702728271484
(111) DESCRIBE `ports` 0.0021088123321533
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00042104721069336
(113) DESCRIBE `ports` 0.0020778179168701
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049996376037598
(115) DESCRIBE `ports` 0.0020310878753662
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00048398971557617
(117) DESCRIBE `ports` 0.0019519329071045
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00045394897460938
(119) DESCRIBE `ports` 0.0018718242645264
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039792060852051
(121) DESCRIBE `ports` 0.0035140514373779
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00070595741271973
(123) DESCRIBE `ports` 0.0023629665374756
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00048398971557617
(125) DESCRIBE `ports` 0.002208948135376
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00071501731872559
(127) DESCRIBE `ports` 0.0020420551300049
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00046110153198242
(129) DESCRIBE `ports` 0.0017709732055664
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00049304962158203
(131) DESCRIBE `ports` 0.0019130706787109
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00045394897460938
(133) DESCRIBE `ports` 0.0019938945770264
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00050902366638184
(135) DESCRIBE `ports` 0.0020589828491211
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00057315826416016
(137) DESCRIBE `ports` 0.0021917819976807
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00075101852416992
(139) DESCRIBE `ports` 0.002187967300415
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00051617622375488
(141) DESCRIBE `ports` 0.0021140575408936
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00069212913513184
(143) DESCRIBE `ports` 0.0020160675048828
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.0004878044128418
(145) DESCRIBE `ports` 0.001910924911499
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00046992301940918
(147) DESCRIBE `ports` 0.001784086227417
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00046300888061523
(149) DESCRIBE `ports` 0.0017819404602051
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00046706199645996
(151) DESCRIBE `ports` 0.0019199848175049
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.0004730224609375
(153) DESCRIBE `ports` 0.0018911361694336
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00047516822814941
(155) DESCRIBE `ports` 0.0019040107727051
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0004270076751709
(157) DESCRIBE `ports` 0.0022640228271484
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.0004889965057373
(159) DESCRIBE `ports` 0.0020248889923096
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00043511390686035
(161) DESCRIBE `ports` 0.0015559196472168
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00040006637573242
(163) DESCRIBE `ports` 0.0016999244689941
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00040316581726074
(165) DESCRIBE `ports` 0.0017189979553223
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00042915344238281
(167) DESCRIBE `ports` 0.0018332004547119
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00036096572875977
(169) DESCRIBE `ports` 0.0018000602722168
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00040411949157715
(171) DESCRIBE `ports` 0.0019009113311768
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00044393539428711
(173) DESCRIBE `ports` 0.001924991607666
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00042891502380371
(175) DESCRIBE `ports` 0.0017879009246826
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00037097930908203
(177) DESCRIBE `ports` 0.001784086227417
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040507316589355
(179) DESCRIBE `ports` 0.0020170211791992
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00042819976806641
(181) DESCRIBE `specialsmultipricing` 0.0017220973968506
(182) DESCRIBE `leadpricing` 0.0016741752624512
(183) DESCRIBE `specialspricing` 0.0015981197357178
(184) DESCRIBE `cabins` 0.0014059543609619
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.00038409233093262
(186) DESCRIBE `currencies` 0.0014309883117676
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00036287307739258
(188) DESCRIBE `cruiselines` 0.0026659965515137
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00061702728271484
(190) DESCRIBE `orchid_image` 0.0021359920501709
(191) DESCRIBE `cruiselines` 0.0027081966400146
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042581558227539
(193) DESCRIBE `cruises` 0.0037500858306885
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.0006248950958252
(195) DESCRIBE `deckplans` 0.001662015914917
(196) DESCRIBE `cabins` 0.0018210411071777
(197) DESCRIBE `shipphotos` 0.0019450187683105
(198) DESCRIBE `cruiselines` 0.0023131370544434
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00045299530029297
(200) DESCRIBE `orchid_image` 0.0018219947814941
(201) DESCRIBE `cruiselines` 0.0021541118621826
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00035691261291504
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(205) DESCRIBE `cruises` 0.0037798881530762
(206) 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.00235915184021
(207) DESCRIBE `cruiselines` 0.002896785736084
(208) 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.0018529891967773
(209) DESCRIBE `ships` 0.003715991973877
(210) 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.0053679943084717
(211) DESCRIBE `cruisetypes` 0.0018088817596436
(212) DESCRIBE `destinations` 0.0025820732116699
(213) 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.0021240711212158