or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  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

Ponant
Le Lyrial
Le Lyrial

Valid: 20 Dec 2017 - 31 Jan 2018

7-Night expedition voyage aboard Le Lyrial
Superb dining, with all main meals included during your cruise.
Captains welcome cocktail and gala dinner.
Open Bar (pouring wines, house champagne, alcohol except premium brands... list available upon request).
Evening entertainment and events onboard.
24hr room service.
Water sports activities (except scuba diving) using the ships equipment.
Port taxes and government fees.

Highlights:
• A kid-friendly, family cruise, with specific entertainment;
• UNESCO World Heritage Sites: the lagoon of Venice, the old towns of Dubrovnik and Kotor;
• A cruise featuring culture and history, sailing along the turquoise waters of the Adriatic Sea to visit three countries (Italy, Croatia and Montenegro);
• Two all-new ports of call: Trieste and its many Neo-Classical and Viennese palaces, and Cres and its medieval architecture;
• An overnight stay in Venice to really enjoy the 'Most Serene City'.

Special Conditions

Cruise costs are in New Zealand Dollars (NZD). Offer subject to availability at time of booking. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Prices are subject to currency fluctuations and are based on cash or cheque. Itinerary changes may apply. 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. Cruise Line reserves the right to re-instate the fuel supplement for all guests up to US$9 per person per day if the price of light sweet crude on the New York Mercantile Exchange (NYMEX) exceeds US$70 per barrel. Please consult cruise line website for current information.

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

Total elapsed time: 0.10547089576721

# Query Time
(1) connect 0.00050711631774902
(2) DESCRIBE `specials` 0.0024569034576416
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '7-night-in-the-heart-of-the-adriatic-luxury-cruise-from-venice-return') AND (orchid_available = 1) LIMIT 1 0.00067996978759766
(4) DESCRIBE `cruises` 0.0013811588287354
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74006))) 0.00029206275939941
(6) DESCRIBE `avid_specials` 0.00067019462585449
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1384771 and class = 'Special') OR (item_id = 74006 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 22 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.0010051727294922
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1384771') 0.00020503997802734
(9) DESCRIBE `ships` 0.001554012298584
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00026583671569824
(11) DESCRIBE `ships` 0.0013401508331299
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00020194053649902
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020289421081543
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016880035400391
(15) DESCRIBE `itineraries` 0.00074982643127441
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74006') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014359951019287
(17) DESCRIBE `ports` 0.0011210441589355
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003058910369873
(19) DESCRIBE `ports` 0.00095200538635254
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001990795135498
(21) DESCRIBE `ports` 0.00083184242248535
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029087066650391
(23) DESCRIBE `specialsailingdates` 0.00097107887268066
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1384771') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00077199935913086
(25) DESCRIBE `sailingdates` 0.0009620189666748
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465922))) 0.00026798248291016
(27) DESCRIBE `ports` 0.0009918212890625
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027704238891602
(29) DESCRIBE `ports` 0.00081896781921387
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00024986267089844
(31) DESCRIBE `ports` 0.00069189071655273
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1251))) 0.00026178359985352
(33) DESCRIBE `ports` 0.00086212158203125
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1251') 0.00024104118347168
(35) DESCRIBE `ports` 0.00077509880065918
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.0002288818359375
(37) DESCRIBE `ports` 0.00094008445739746
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00024700164794922
(39) DESCRIBE `ports` 0.00096607208251953
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0002288818359375
(41) DESCRIBE `ports` 0.00090909004211426
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0001981258392334
(43) DESCRIBE `ports` 0.00080704689025879
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00023794174194336
(45) DESCRIBE `ports` 0.00089693069458008
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00022101402282715
(47) DESCRIBE `ports` 0.0011539459228516
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00038695335388184
(49) DESCRIBE `ports` 0.0011060237884521
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028395652770996
(51) DESCRIBE `ports` 0.00097203254699707
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2456))) 0.00031685829162598
(53) DESCRIBE `ports` 0.001054048538208
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2456') 0.00025486946105957
(55) DESCRIBE `ports` 0.0010011196136475
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00026202201843262
(57) DESCRIBE `ports` 0.00094485282897949
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00024509429931641
(59) DESCRIBE `ports` 0.00094103813171387
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2799))) 0.00028109550476074
(61) DESCRIBE `ports` 0.00094294548034668
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2799') 0.00026607513427734
(63) DESCRIBE `ports` 0.00094509124755859
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027298927307129
(65) DESCRIBE `ports` 0.0008389949798584
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020098686218262
(67) DESCRIBE `specialsmultipricing` 0.00088191032409668
(68) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1384771' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00028800964355469
(69) DESCRIBE `leadpricing` 0.00080013275146484
(70) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1384771') LIMIT 1 0.00023698806762695
(71) DESCRIBE `specialspricing` 0.00089502334594727
(72) SELECT `specialspricing`.* FROM `specialspricing` WHERE (special_id = '1384771') 0.00069785118103027
(73) DESCRIBE `cabins` 0.00090503692626953
(74) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 10956))) 0.00025296211242676
(75) DESCRIBE `currencies` 0.0006258487701416
(76) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00019216537475586
(77) DESCRIBE `cruiselines` 0.00097203254699707
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00023388862609863
(79) DESCRIBE `orchid_image` 0.00084400177001953
(80) DESCRIBE `cruiselines` 0.0014281272888184
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.0003049373626709
(82) DESCRIBE `cruises` 0.0021131038665771
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74006') 0.00030207633972168
(84) DESCRIBE `deckplans` 0.00087594985961914
(85) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '1262') ORDER BY `level` ASC 0.0037848949432373
(86) DESCRIBE `cabins` 0.0010700225830078
(87) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '1262') ORDER BY `cabin_order` ASC 0.025829076766968
(88) DESCRIBE `shipphotos` 0.00091004371643066
(89) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '1262') 0.0012121200561523
(90) DESCRIBE `cruiselines` 0.0010538101196289
(91) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0002439022064209
(92) DESCRIBE `orchid_image` 0.000762939453125
(93) DESCRIBE `cruiselines` 0.00099301338195801
(94) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00020003318786621
(95) DESCRIBE `cruises` 0.0019099712371826
(96) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74349, 74350, 63787, 66352, 74351, 61581, 63789, 65446, 67892, 64898)) ORDER BY FIND_IN_SET(id, '74349,74350,63787,66352,74351,61581,63789,65446,67892,64898') 0.00082206726074219
(97) DESCRIBE `cruiselines` 0.0011370182037354
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '18', '114', '24', '30', '33', '216', '23', '36', '151', '191', '15', '26', '8', '4', '29', '37', '47', '19', '20', '212')) ORDER BY FIND_IN_SET(id, '218,18,114,24,30,33,216,23,36,151,191,15,26,8,4,29,37,47,19,20,212') 0.00084805488586426
(99) DESCRIBE `ships` 0.0015771389007568
(100) SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '479', '780', '1539', '151', '163', '338', '1032', '1168', '1672', '4', '5', '25', '82', '150', '439', '451', '461', '547', '616', '1205', '1262', '3', '21', '22', '27', '74', '152', '262', '333', '390', '517', '582', '657', '683', '854', '970', '1159', '1303', '81', '84', '111', '149', '160', '253', '287', '290', '335', '340', '349', '389', '401', '403', '404', '406', '573', '585', '669', '776', '792', '968', '1073', '1189', '1266', '1282', '1284', '1302', '1320', '1398', '1402', '1415', '1526', '1571', '1579', '1673')) ORDER BY FIND_IN_SET(id, '855,479,780,1539,151,163,338,1032,1168,1672,4,5,25,82,150,439,451,461,547,616,1205,1262,3,21,22,27,74,152,262,333,390,517,582,657,683,854,970,1159,1303,81,84,111,149,160,253,287,290,335,340,349,389,401,403,404,406,573,585,669,776,792,968,1073,1189,1266,1282,1284,1302,1320,1398,1402,1415,1526,1571,1579,1673') 0.0031239986419678
(101) DESCRIBE `cruisetypes` 0.001147985458374
(102) DESCRIBE `destinations` 0.0014309883117676
(103) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '43', '22', '8', '35', '2', '9', '26', '53', '48', '55', '37', '54', '25', '40', '49', '11', '21', '28', '29', '39')) ORDER BY FIND_IN_SET(id, '12,43,22,8,35,2,9,26,53,48,55,37,54,25,40,49,11,21,28,29,39') 0.0010511875152588