or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Carnival Cruise Line
Carnival Splendor
Carnival Splendor

Valid: 12 Nov 2018 - 15 Dec 2018

7-Night cruise and accommodation aboard Carnival Splendor
All meals included during your cruise
Entertainment and activities while cruising
Supervised children's club
Many bars throughout the ship
Adults only area
Splash zone and Water Park with hydroslides
Port taxes and government fees

1-Night pre-cruise accommodation at The Westin Long Beach
1-Night post-cruise accommodation at The Westin Long Beach
Flights: Return economy class airfares from Auckland to Long Beach flying Hawaiian Airlines
Private Transfers: Airport to Hotel – Hotel to Port and vice versa

Special Conditions

Price shown is in NZD based on 02 February 2019 cruise departure, twin share. Includes cruise, accommodation, flights and transfers, as described above. Correct as at 03 October 2018. Airfares are ex Auckland to Long Beach return only on Hawaiian Airlines, subject to availability. Airfare taxes are included and are subject to change. Special airline conditions apply. Cruise based on twin share in interior stateroom (category 4B), includes port charges, government taxes and all applicable discounts. Onboard gratuities are additional. Accommodation based on Traditional Room, inclusive of taxes. Included Transfers were correct as at 01/10/18. All fares and taxes are subject to change without notice up until full payment is received. Subject to availability and currency fluctuations. Credit card payments will incur a fee. Additional conditions may apply. Valid for sale till 21/11/2018 unless sold out prior

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

Total elapsed time: 0.16115283966064

# Query Time
(1) connect 0.001183032989502
(2) DESCRIBE `specials` 0.005673885345459
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '9-night-mexican-riviera-cruise-package-from-long-beach-return') AND (orchid_available = 1) LIMIT 1 0.0028738975524902
(4) DESCRIBE `cruises` 0.0038900375366211
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67917))) 0.0015270709991455
(6) DESCRIBE `avid_specials` 0.0024580955505371
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1488100 and class = 'Special') OR (item_id = 67917 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0044319629669189
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1488100') 0.00081801414489746
(9) DESCRIBE `ships` 0.0054879188537598
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.0012478828430176
(11) DESCRIBE `ships` 0.0038180351257324
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00052809715270996
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030183792114258
(15) DESCRIBE `itineraries` 0.001816987991333
(16) DESCRIBE `ports` 0.0030200481414795
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00070810317993164
(18) DESCRIBE `ports` 0.0023820400238037
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00073003768920898
(20) DESCRIBE `ports` 0.0023128986358643
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034594535827637
(22) DESCRIBE `specialsailingdates` 0.0017402172088623
(23) DESCRIBE `sailingdates` 0.0023009777069092
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428527))) 0.0019748210906982
(25) DESCRIBE `ports` 0.0030801296234131
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00075888633728027
(27) DESCRIBE `ports` 0.0058770179748535
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00051498413085938
(29) DESCRIBE `ports` 0.0019600391387939
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0012798309326172
(31) DESCRIBE `ports` 0.0035929679870605
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00058078765869141
(33) DESCRIBE `ports` 0.0022740364074707
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00083494186401367
(35) DESCRIBE `ports` 0.0018868446350098
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.0005190372467041
(37) DESCRIBE `ports` 0.0024881362915039
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00058794021606445
(39) DESCRIBE `ports` 0.0023069381713867
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00058603286743164
(41) DESCRIBE `ports` 0.0020880699157715
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00050497055053711
(43) DESCRIBE `ports` 0.0023159980773926
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00052618980407715
(45) DESCRIBE `specialsmultipricing` 0.0023560523986816
(46) DESCRIBE `leadpricing` 0.0017809867858887
(47) DESCRIBE `specialspricing` 0.0014889240264893
(48) DESCRIBE `cabins` 0.0021419525146484
(49) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 6322))) 0.0013580322265625
(50) DESCRIBE `currencies` 0.0022881031036377
(51) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00041508674621582
(52) DESCRIBE `cruiselines` 0.0034630298614502
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00066900253295898
(54) DESCRIBE `orchid_image` 0.0029900074005127
(55) DESCRIBE `cruiselines` 0.0029940605163574
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00050806999206543
(57) DESCRIBE `cruises` 0.0037009716033936
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67917') 0.00054216384887695
(59) DESCRIBE `deckplans` 0.0019371509552002
(60) DESCRIBE `cabins` 0.0023288726806641
(61) DESCRIBE `shipphotos` 0.0028932094573975
(62) DESCRIBE `cruiselines` 0.0035059452056885
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0013811588287354
(64) DESCRIBE `orchid_image` 0.0037021636962891
(65) DESCRIBE `cruiselines` 0.0044941902160645
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0006098747253418
(67) DESCRIBE `cruises` 0.0037000179290771
(68) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67295, 72995, 69895, 80004, 67917, 80005, 78125, 66816, 77957, 75551)) ORDER BY FIND_IN_SET(id, '67295,72995,69895,80004,67917,80005,78125,66816,77957,75551') 0.002094030380249
(69) DESCRIBE `cruiselines` 0.0026769638061523
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('91', '151', '23', '29', '8', '15', '37', '187', '262', '4', '20', '26', '33', '218')) ORDER BY FIND_IN_SET(id, '91,151,23,29,8,15,37,187,262,4,20,26,33,218') 0.0015530586242676
(71) DESCRIBE `ships` 0.0061099529266357
(72) SELECT `ships`.* FROM `ships` WHERE (id IN ('451', '148', '394', '652', '683', '780', '1108', '1454', '1474', '1672', '4', '163', '223', '287', '485', '616', '669', '678', '1284', '1319', '1402')) ORDER BY FIND_IN_SET(id, '451,148,394,652,683,780,1108,1454,1474,1672,4,163,223,287,485,616,669,678,1284,1319,1402') 0.0043740272521973
(73) DESCRIBE `cruisetypes` 0.0021121501922607
(74) DESCRIBE `destinations` 0.0028879642486572
(75) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '22', '8', '2', '25', '26', '35', '53')) ORDER BY FIND_IN_SET(id, '43,40,22,8,2,25,26,35,53') 0.0016410350799561