or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Viking Delling

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

Total elapsed time: 0.87732696533203

# Query Time
(1) connect 0.0073318481445312
(2) DESCRIBE `cruises` 0.016642093658447
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.14226412773132
(4) DESCRIBE `avid_specials` 0.002593994140625
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69845 and class = 'Cruise') OR (item_id = 1145 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0022461414337158
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.0006110668182373
(7) DESCRIBE `ships` 0.0053458213806152
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00081086158752441
(9) DESCRIBE `ships` 0.005469799041748
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00070905685424805
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048995018005371
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052094459533691
(13) DESCRIBE `itineraries` 0.0030319690704346
(14) DESCRIBE `ports` 0.0030169486999512
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00074100494384766
(16) DESCRIBE `ports` 0.0028691291809082
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00069093704223633
(18) DESCRIBE `ports` 0.0028529167175293
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00054788589477539
(20) DESCRIBE `sailingdates` 0.0023260116577148
(21) DESCRIBE `ports` 0.023260116577148
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00092005729675293
(23) DESCRIBE `ports` 0.01466703414917
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0022189617156982
(25) DESCRIBE `ports` 0.003122091293335
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00071001052856445
(27) DESCRIBE `ports` 0.0030438899993896
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00079607963562012
(29) DESCRIBE `ports` 0.0027291774749756
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00063300132751465
(31) DESCRIBE `ports` 0.0026009082794189
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0007469654083252
(33) DESCRIBE `ports` 0.0398850440979
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.0021688938140869
(35) DESCRIBE `ports` 0.0027840137481689
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00062704086303711
(37) DESCRIBE `ports` 0.0039119720458984
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00067400932312012
(39) DESCRIBE `ports` 0.0048329830169678
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.017082929611206
(41) DESCRIBE `ports` 0.058063983917236
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.0028181076049805
(43) DESCRIBE `ports` 0.0040609836578369
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00071191787719727
(45) DESCRIBE `ports` 0.012657165527344
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00087404251098633
(47) DESCRIBE `ports` 0.055928945541382
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.0008549690246582
(49) DESCRIBE `ports` 0.012850999832153
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00069308280944824
(51) DESCRIBE `ports` 0.0029149055480957
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00061297416687012
(53) DESCRIBE `ports` 0.0027980804443359
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00066900253295898
(55) DESCRIBE `ports` 0.0030701160430908
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00058889389038086
(57) DESCRIBE `cruiselines` 0.0039761066436768
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00064301490783691
(59) DESCRIBE `orchid_image` 0.0036020278930664
(60) DESCRIBE `cruiselines` 0.0044929981231689
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00075006484985352
(62) DESCRIBE `cabins` 0.039034843444824
(63) DESCRIBE `deckplans` 0.002932071685791
(64) DESCRIBE `shipphotos` 0.017238855361938
(65) DESCRIBE `cruises` 0.021903038024902
(66) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34153, 34175, 34197, 34711, 40786, 41032, 49747, 52512, 52647, 52887)) ORDER BY FIND_IN_SET(id, '34153,34175,34197,34711,40786,41032,49747,52512,52647,52887') 0.0061569213867188
(67) DESCRIBE `cruiselines` 0.0046241283416748
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '144', '12', '23', '183', '20', '101', '120', '31', '18', '8', '131', '7', '96', '171', '170', '103', '206', '33', '156', '15', '50', '262', '191', '29', '195', '258', '91', '16', '37', '153', '14', '28', '24', '208', '187', '36', '114', '47', '49', '251', '141', '88', '212', '151', '181', '110', '118', '4', '264', '30', '216', '59', '140', '108', '115', '73', '159', '48', '211', '213', '147', '35', '38', '113', '276', '90', '95', '180', '57', '52', '244', '64', '172', '257', '261', '184', '82', '134', '245', '105', '177', '209')) ORDER BY FIND_IN_SET(id, '77,218,19,26,144,12,23,183,20,101,120,31,18,8,131,7,96,171,170,103,206,33,156,15,50,262,191,29,195,258,91,16,37,153,14,28,24,208,187,36,114,47,49,251,141,88,212,151,181,110,118,4,264,30,216,59,140,108,115,73,159,48,211,213,147,35,38,113,276,90,95,180,57,52,244,64,172,257,261,184,82,134,245,105,177,209') 0.02117919921875
(69) DESCRIBE `ships` 0.0066981315612793
(70) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '517', '1744', '732', '737', '1417', '726', '1324', '1554', '1588', '207', '1555', '1794', '1594', '454', '977', '1717', '521', '780', '1237', '1272', '974', '871', '258', '1032', '1359', '1424', '797', '265', '22', '404', '461', '21', '330', '770', '1292', '393', '28', '716', '1766', '1348', '1677', '1419', '1423', '520', '1420', '1422', '1418', '1421', '349', '857', '1205', '858', '1415', '1501', '333', '11', '986', '1682', '715', '738', '1067', '439', '739', '9', '10', '674', '25', '24', '855', '163', '837', '542', '1260', '1678', '455', '3', '1607', '882', '1768', '1008', '113', '407', '1402', '434', '1141', '610', '1135', '1773', '553', '480', '627', '332', '503', '792', '1742', '573', '1569', '160', '352', '386', '766', '817', '1454', '63', '1455', '66', '1721', '711', '1168', '1233', '1372', '1602', '198', '626', '657', '883', '1021', '1284', '285', '385', '585', '1413', '1410', '1599', '1302', '1411', '462', '1193', '1308', '1738', '111', '124', '526', '1259', '1266', '1320', '1323', '1579', '314', '1822', '286', '970', '1811', '43', '854', '1088', '327', '390', '582', '590', '1063', '1552', '1733', '485', '1145', '1586', '441', '748', '1068', '405', '944', '1321', '34', '38', '791', '1149', '31', '37', '119', '1492', '1722', '70', '678', '958', '1208', '1245', '1291', '1463', '1587', '1782', '14', '114', '162', '378', '406', '545', '616', '1028', '1711', '4', '351', '644', '658', '1027', '1412', '69', '335', '635', '850', '1157', '1672', '451', '1289', '1318', '1139', '1199', '1303', '1319', '401', '704', '1461', '341', '547', '722', '1108', '340', '580', '701', '1236', '1398', '105', '325', '403', '683', '1330', '601', '652', '966', '1013', '1408', '98', '148', '508', '1159', '1188', '1326', '1327', '1367', '1526', '201', '394', '651', '1151', '1575', '287', '348', '389', '818', '1172', '78', '291', '639', '1040', '39', '212', '338', '776', '1019', '1801', '30', '35', '36', '84', '123', '262', '988', '1012', '1037', '1043', '1743', '1809', '852', '1223', '1344', '1426', '1715', '27', '45', '266', '290', '673', '775', '1160', '1217', '1405', '1704', '1716', '1808', '483', '751', '1029', '1143', '1144', '1163', '1343', '1452', '1453', '1226', '1229', '1282', '1325', '1373', '1604', '574', '1358', '1724', '1730', '768', '968', '1095', '1283', '1409', '1740', '1772', '82', '905', '1035', '1137', '1152', '417', '769', '972', '1136', '1448', '108', '223', '253', '709', '1025', '1045', '1055', '1090', '1150', '1474', '151', '324', '851', '885', '1026', '1206', '1351', '150', '643', '663', '973', '1681', '1771', '116', '559', '884', '1230', '1231', '1458', '1713', '1750', '954', '1048', '1154', '1366', '1676', '1714', '1751', '1042', '1071', '1368', '1632', '1723', '208', '467', '665', '666', '924', '1049', '1196', '1322', '1360', '1361', '1362', '1459', '1708', '93', '784', '790', '920', '1051', '1052', '1140', '1148', '1483', '1609', '1649', '423', '921', '923', '996', '1293', '1301', '1580', '703', '888', '915', '1072', '1352', '1758', '147', '453', '916', '926', '930', '931', '1020', '1146', '1274', '1329', '75', '707', '1047', '1224', '1340', '1596', '1601', '1679', '1807', '1833', '205', '796', '886', '1004', '1039', '1073', '1109', '1241', '1262', '1389', '1445', '1468', '1519', '1539', '1571', '1791', '152', '422', '717', '1036', '1050', '1339', '1350', '516', '1054', '1075', '1486', '1574', '1749', '149', '730', '1044', '1294', '1759', '1767', '1788', '1806', '74', '81', '300', '656', '671', '672', '1232', '1256', '1572', '1664', '1673', '1816', '299', '1005', '1060', '1138', '1437', '1451', '1540', '1781', '1805', '420', '795', '821', '1225', '1254', '1444', '1823', '375', '448', '487', '743', '761', '982', '1011', '1663', '419', '493')) ORDER BY FIND_IN_SET(id, '1761,517,1744,732,737,1417,726,1324,1554,1588,207,1555,1794,1594,454,977,1717,521,780,1237,1272,974,871,258,1032,1359,1424,797,265,22,404,461,21,330,770,1292,393,28,716,1766,1348,1677,1419,1423,520,1420,1422,1418,1421,349,857,1205,858,1415,1501,333,11,986,1682,715,738,1067,439,739,9,10,674,25,24,855,163,837,542,1260,1678,455,3,1607,882,1768,1008,113,407,1402,434,1141,610,1135,1773,553,480,627,332,503,792,1742,573,1569,160,352,386,766,817,1454,63,1455,66,1721,711,1168,1233,1372,1602,198,626,657,883,1021,1284,285,385,585,1413,1410,1599,1302,1411,462,1193,1308,1738,111,124,526,1259,1266,1320,1323,1579,314,1822,286,970,1811,43,854,1088,327,390,582,590,1063,1552,1733,485,1145,1586,441,748,1068,405,944,1321,34,38,791,1149,31,37,119,1492,1722,70,678,958,1208,1245,1291,1463,1587,1782,14,114,162,378,406,545,616,1028,1711,4,351,644,658,1027,1412,69,335,635,850,1157,1672,451,1289,1318,1139,1199,1303,1319,401,704,1461,341,547,722,1108,340,580,701,1236,1398,105,325,403,683,1330,601,652,966,1013,1408,98,148,508,1159,1188,1326,1327,1367,1526,201,394,651,1151,1575,287,348,389,818,1172,78,291,639,1040,39,212,338,776,1019,1801,30,35,36,84,123,262,988,1012,1037,1043,1743,1809,852,1223,1344,1426,1715,27,45,266,290,673,775,1160,1217,1405,1704,1716,1808,483,751,1029,1143,1144,1163,1343,1452,1453,1226,1229,1282,1325,1373,1604,574,1358,1724,1730,768,968,1095,1283,1409,1740,1772,82,905,1035,1137,1152,417,769,972,1136,1448,108,223,253,709,1025,1045,1055,1090,1150,1474,151,324,851,885,1026,1206,1351,150,643,663,973,1681,1771,116,559,884,1230,1231,1458,1713,1750,954,1048,1154,1366,1676,1714,1751,1042,1071,1368,1632,1723,208,467,665,666,924,1049,1196,1322,1360,1361,1362,1459,1708,93,784,790,920,1051,1052,1140,1148,1483,1609,1649,423,921,923,996,1293,1301,1580,703,888,915,1072,1352,1758,147,453,916,926,930,931,1020,1146,1274,1329,75,707,1047,1224,1340,1596,1601,1679,1807,1833,205,796,886,1004,1039,1073,1109,1241,1262,1389,1445,1468,1519,1539,1571,1791,152,422,717,1036,1050,1339,1350,516,1054,1075,1486,1574,1749,149,730,1044,1294,1759,1767,1788,1806,74,81,300,656,671,672,1232,1256,1572,1664,1673,1816,299,1005,1060,1138,1437,1451,1540,1781,1805,420,795,821,1225,1254,1444,1823,375,448,487,743,761,982,1011,1663,419,493') 0.23304295539856
(71) DESCRIBE `cruisetypes` 0.0025298595428467
(72) DESCRIBE `destinations` 0.005302906036377
(73) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '37', '2', '8', '44', '53', '55', '39', '28', '38', '26', '11', '40', '48', '7', '45', '21', '29', '49', '30', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,37,2,8,44,53,55,39,28,38,26,11,40,48,7,45,21,29,49,30,34,52,10,46,56,32') 0.014523983001709