or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Princess Cruises
Majestic Princess
Majestic Princess

Valid: 28 Apr 2018 - 31 May 2018

- 12 night cruise aboard Majestic Princess
- Main meals & entertainment onboard
- Port charges & government fees

BONUS:
- Receive AUD$50 onboard credit per stateroom
- Assorted canapes
- Chocolate dipped strawberries
- One photo or photo credit per stateroom, excludes Platinum Studio

Special Conditions

Valid for sales until 31 May 2018 unless sold out prior. Fares are cruise only, per person, twin share in NZD, inclusive of all discounts, taxes, fees & port expenses (which are subject to change). Valid for new bookings & not combinable with any other offer. Subject to availability at time of booking. ONBOARD CREDIT is in currency specified, per stateroom, is non-transferable, non-refundable & non-redeemable for cash & cannot be used at the medical centre or casino. Further conditions apply. Price/offer is subject to change or may be withdrawn without prior notice.

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

Total elapsed time: 0.22928309440613

# Query Time
(1) connect 0.00056099891662598
(2) DESCRIBE `specials` 0.0033318996429443
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'spotlight-on-princess-new-year-cruise-aboard-majestic-princess') AND (orchid_available = 1) LIMIT 1 0.012824058532715
(4) DESCRIBE `cruises` 0.0022690296173096
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76235))) 0.00048494338989258
(6) DESCRIBE `avid_specials` 0.0009920597076416
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1425883 and class = 'Special') OR (item_id = 76235 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 43 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.0017299652099609
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1425883') 0.00029993057250977
(9) DESCRIBE `ships` 0.0021650791168213
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00039482116699219
(11) DESCRIBE `ships` 0.0019941329956055
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00029182434082031
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(15) DESCRIBE `itineraries` 0.0010581016540527
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '76235') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0041038990020752
(17) DESCRIBE `ports` 0.0014529228210449
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037002563476562
(19) DESCRIBE `ports` 0.0011370182037354
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030899047851562
(21) DESCRIBE `ports` 0.00085997581481934
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00021982192993164
(23) DESCRIBE `specialsailingdates` 0.00064611434936523
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1425883') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0010969638824463
(25) DESCRIBE `sailingdates` 0.00089788436889648
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478486))) 0.00025200843811035
(27) DESCRIBE `ports` 0.00077700614929199
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00024080276489258
(29) DESCRIBE `ports` 0.00067901611328125
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0001978874206543
(31) DESCRIBE `ports` 0.00072216987609863
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020790100097656
(33) DESCRIBE `ports` 0.0007469654083252
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00018501281738281
(35) DESCRIBE `ports` 0.00070500373840332
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00020980834960938
(37) DESCRIBE `ports` 0.0007481575012207
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00019097328186035
(39) DESCRIBE `ports` 0.00074291229248047
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00027203559875488
(41) DESCRIBE `ports` 0.0010368824005127
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00023913383483887
(43) DESCRIBE `ports` 0.00088310241699219
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00026702880859375
(45) DESCRIBE `ports` 0.001101016998291
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00031900405883789
(47) DESCRIBE `ports` 0.0011100769042969
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00034904479980469
(49) DESCRIBE `ports` 0.0010430812835693
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00026321411132812
(51) DESCRIBE `ports` 0.0010008811950684
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029802322387695
(53) DESCRIBE `ports` 0.0010337829589844
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00025320053100586
(55) DESCRIBE `ports` 0.0010330677032471
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002899169921875
(57) DESCRIBE `ports` 0.0010099411010742
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025296211242676
(59) DESCRIBE `specialsmultipricing` 0.00096392631530762
(60) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1425883' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00070595741271973
(61) DESCRIBE `leadpricing` 0.0009758472442627
(62) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1425883') LIMIT 1 0.00030899047851562
(63) DESCRIBE `specials` 0.0031058788299561
(64) SELECT `specials`.* FROM `specials` WHERE (id= '1425883') AND (specials.orchid_available = 1) LIMIT 1 0.00063395500183105
(65) DESCRIBE `currencies` 0.00095796585083008
(66) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.0024940967559814
(67) DESCRIBE `cruiselines` 0.0018141269683838
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003669261932373
(69) DESCRIBE `orchid_image` 0.0011959075927734
(70) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '23') 0.057410001754761
(71) DESCRIBE `cruiselines` 0.0018401145935059
(72) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031495094299316
(73) DESCRIBE `cruises` 0.0023250579833984
(74) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76235') 0.00032806396484375
(75) DESCRIBE `deckplans` 0.0011711120605469
(76) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '1409') ORDER BY `level` ASC 0.0040719509124756
(77) DESCRIBE `cabins` 0.0011999607086182
(78) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '1409') ORDER BY `cabin_order` ASC 0.033428907394409
(79) DESCRIBE `shipphotos` 0.0013101100921631
(80) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '1409') 0.001533031463623
(81) DESCRIBE `cruiselines` 0.0015828609466553
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00032901763916016
(83) DESCRIBE `orchid_image` 0.0010969638824463
(84) DESCRIBE `cruiselines` 0.0013449192047119
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028610229492188
(86) DESCRIBE `cruises` 0.0024199485778809
(87) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45259, 74553, 69528, 67892, 67011, 66859, 48300, 66414, 56791)) ORDER BY FIND_IN_SET(id, '45258,45259,74553,69528,67892,67011,66859,48300,66414,56791') 0.0048680305480957
(88) DESCRIBE `cruiselines` 0.0015990734100342
(89) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '18', '101', '23', '26', '218', '29', '8', '24', '33', '151', '191', '14', '37', '262')) ORDER BY FIND_IN_SET(id, '47,18,101,23,26,218,29,8,24,33,151,191,14,37,262') 0.00074601173400879
(90) DESCRIBE `ships` 0.002263069152832
(91) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '888', '75', '78', '1303', '147', '287', '683', '717', '262', '1139', '1676', '45', '111', '160', '163', '678', '66', '105', '119', '253', '333', '335', '338', '349', '390', '406', '451', '580', '616', '669', '722', '765', '1032', '1205', '1302', '1323', '1409', '1492', '1579', '1672')) ORDER BY FIND_IN_SET(id, '517,888,75,78,1303,147,287,683,717,262,1139,1676,45,111,160,163,678,66,105,119,253,333,335,338,349,390,406,451,580,616,669,722,765,1032,1205,1302,1323,1409,1492,1579,1672') 0.0018010139465332
(92) DESCRIBE `cruisetypes` 0.0011539459228516
(93) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.is_special = 1) AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.030871868133545
(94) DESCRIBE `destinations` 0.0011389255523682
(95) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '50', '35', '2', '7', '22', '12', '11', '49', '8', '48', '53', '37', '38', '54', '55')) ORDER BY FIND_IN_SET(id, '43,50,35,2,7,22,12,11,49,8,48,53,37,38,54,55') 0.00073599815368652