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

Oceania Cruises
Regatta
Regatta

Valid: 17 Oct 2018 - 17 Dec 2018

• One-way Economy Class Flight from Auckland to Sydney
• 12 night cruise onboard Regatta from Sydney to Auckland
• All meals & entertainment onboard
• Specialty restaurants & room service
• Unlimited soft drinks, bottled water, coffees, teas & juices
• Air & Port charges, taxes & gratuities

OLife Ultimate promotion bonus:(Passengers 1 & 2 ONLY):
• Complimentary House Beverage Package (Unlimited Champagne, wine & beer at dinner & lunch).
• Four Complimentary selected shore excursions (to be confirmed on confirmation).
• On board credit of up to US$400 per person

Special Conditions

Offer subject to availability at time of booking and for new bookings only. Prices can be withdrawn at any time without prior notice. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Prices maybe subject to currency fluctuations and are based on cash or bank transfer. 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. Extra deposit maybe required for the cost of the airfare.

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

Total elapsed time: 0.16177153587341

# Query Time
(1) connect 0.0011940002441406
(2) DESCRIBE `specials` 0.0063979625701904
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'oceania-luxury-cruise-fly-package-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0031871795654297
(4) DESCRIBE `cruises` 0.0038149356842041
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80005))) 0.0007469654083252
(6) DESCRIBE `avid_specials` 0.0019230842590332
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1492181 and class = 'Special') OR (item_id = 80005 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0019500255584717
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1492181') 0.0004880428314209
(9) DESCRIBE `ships` 0.0040450096130371
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00069093704223633
(11) DESCRIBE `ships` 0.0041539669036865
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00052499771118164
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036001205444336
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(15) DESCRIBE `itineraries` 0.0017220973968506
(16) DESCRIBE `ports` 0.0020980834960938
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051689147949219
(18) DESCRIBE `ports` 0.0019330978393555
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070810317993164
(20) DESCRIBE `ports` 0.0020930767059326
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037789344787598
(22) DESCRIBE `specialsailingdates` 0.0018210411071777
(23) DESCRIBE `sailingdates` 0.0017530918121338
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494408))) 0.00074100494384766
(25) DESCRIBE `ports` 0.0018839836120605
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045585632324219
(27) DESCRIBE `ports` 0.0019428730010986
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042891502380371
(29) DESCRIBE `ports` 0.0018680095672607
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(31) DESCRIBE `ports` 0.0028622150421143
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047922134399414
(33) DESCRIBE `ports` 0.0017650127410889
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00042104721069336
(35) DESCRIBE `ports` 0.0016140937805176
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00037097930908203
(37) DESCRIBE `ports` 0.0016829967498779
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00039982795715332
(39) DESCRIBE `ports` 0.0016269683837891
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00038003921508789
(41) DESCRIBE `ports` 0.0017080307006836
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00044989585876465
(43) DESCRIBE `ports` 0.0017859935760498
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00060296058654785
(45) DESCRIBE `ports` 0.0027639865875244
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036382675170898
(47) DESCRIBE `ports` 0.0028221607208252
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00046801567077637
(49) DESCRIBE `ports` 0.0020058155059814
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00048398971557617
(51) DESCRIBE `ports` 0.0019550323486328
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0004420280456543
(53) DESCRIBE `ports` 0.0019447803497314
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00050497055053711
(55) DESCRIBE `ports` 0.0019781589508057
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00046992301940918
(57) DESCRIBE `ports` 0.0018680095672607
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00041103363037109
(59) DESCRIBE `ports` 0.0022079944610596
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0004580020904541
(61) DESCRIBE `ports` 0.0017359256744385
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00049090385437012
(63) DESCRIBE `ports` 0.0017590522766113
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00072002410888672
(65) DESCRIBE `ports` 0.002439022064209
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00064492225646973
(67) DESCRIBE `ports` 0.0023429393768311
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00049686431884766
(69) DESCRIBE `specialsmultipricing` 0.001953125
(70) DESCRIBE `leadpricing` 0.0020270347595215
(71) DESCRIBE `specials` 0.0053079128265381
(72) DESCRIBE `currencies` 0.0016829967498779
(73) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00043296813964844
(74) DESCRIBE `cruiselines` 0.0026261806488037
(75) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00053906440734863
(76) DESCRIBE `orchid_image` 0.0024089813232422
(77) DESCRIBE `cruiselines` 0.0028171539306641
(78) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00077915191650391
(79) DESCRIBE `cruises` 0.0032680034637451
(80) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80005') 0.0004580020904541
(81) DESCRIBE `deckplans` 0.0017321109771729
(82) DESCRIBE `cabins` 0.0019540786743164
(83) DESCRIBE `shipphotos` 0.0019009113311768
(84) DESCRIBE `cruiselines` 0.0030710697174072
(85) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00062704086303711
(86) DESCRIBE `orchid_image` 0.0022718906402588
(87) DESCRIBE `cruiselines` 0.0026400089263916
(88) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00050210952758789
(89) DESCRIBE `cruises` 0.0042030811309814
(90) 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.0022740364074707
(91) DESCRIBE `cruiselines` 0.0029590129852295
(92) 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.0018880367279053
(93) DESCRIBE `ships` 0.0036709308624268
(94) 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.0029549598693848
(95) DESCRIBE `cruisetypes` 0.0020451545715332
(96) DESCRIBE `destinations` 0.0027909278869629
(97) 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.0014588832855225