or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

Your 'Cruise Line' has been chosenClear this filter or visit another page to change
  • Azamara Club Cruises

    Azamara Club Cruises

    What makes Azamara Club Cruises® different from everyone else? It’s our focus on Destination Immersion®—which lets you stay longer and experience more on every one... ... Read More »

    Star Rating 5 Star
    Enquire about this cruise line

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

Total elapsed time: 0.054048299789429

# Query Time
(1) connect 0.00065112113952637
(2) DESCRIBE `cruiselines` 0.0017318725585938
(3) SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'azamara-club-cruises') AND (orchid_available = 1) LIMIT 1 0.0010519027709961
(4) DESCRIBE `avid_specials` 0.001129150390625
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '151' AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016098022460938
(6) DESCRIBE `orchid_image` 0.0012860298156738
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00041413307189941
(8) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020408630371094
(9) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018692016601562
(10) DESCRIBE `cruises` 0.0021970272064209
(11) SELECT `cruises`.* FROM `cruises` WHERE (id IN (58845, 59192, 53368, 58833, 60165, 60166, 58846, 69389, 60168, 58847)) ORDER BY FIND_IN_SET(id, '58845,59192,53368,58833,60165,60166,58846,69389,60168,58847') 0.0013821125030518
(12) DESCRIBE `ships` 0.0028111934661865
(13) SELECT `ships`.* FROM `ships` WHERE (id IN ('616', '652', '1672')) ORDER BY FIND_IN_SET(id, '616,652,1672') 0.00070095062255859
(14) DESCRIBE `cruisetypes` 0.0010018348693848
(15) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '151') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.032140016555786
(16) DESCRIBE `destinations` 0.0010859966278076
(17) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '35', '26', '2', '28', '37', '38', '43', '45', '8', '21', '25', '30', '40', '48', '7', '10', '49')) ORDER BY FIND_IN_SET(id, '22,12,35,26,2,28,37,38,43,45,8,21,25,30,40,48,7,10,49') 0.00092911720275879
(18) DESCRIBE `cruiselines` 0.0014879703521729
(19) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003659725189209
(20) DESCRIBE `cruiselines` 0.0014090538024902
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00027203559875488