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.28297448158264

# Query Time
(1) connect 0.0012540817260742
(2) DESCRIBE `cruises` 0.0050320625305176
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.047224998474121
(4) DESCRIBE `avid_specials` 0.0025320053100586
(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.0021147727966309
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00048589706420898
(7) DESCRIBE `ships` 0.004371166229248
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00062799453735352
(9) DESCRIBE `ships` 0.0038421154022217
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00046586990356445
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037097930908203
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042009353637695
(13) DESCRIBE `itineraries` 0.0018460750579834
(14) DESCRIBE `ports` 0.002129077911377
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00058102607727051
(16) DESCRIBE `ports` 0.0017850399017334
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00052404403686523
(18) DESCRIBE `ports` 0.0017669200897217
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00044107437133789
(20) DESCRIBE `sailingdates` 0.0018470287322998
(21) DESCRIBE `ports` 0.00199294090271
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0005040168762207
(23) DESCRIBE `ports` 0.001939058303833
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00047898292541504
(25) DESCRIBE `ports` 0.0020699501037598
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00042200088500977
(27) DESCRIBE `ports` 0.002161979675293
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00038981437683105
(29) DESCRIBE `ports` 0.0018210411071777
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00041604042053223
(31) DESCRIBE `ports` 0.0019450187683105
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00042581558227539
(33) DESCRIBE `ports` 0.0018599033355713
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00046205520629883
(35) DESCRIBE `ports` 0.0023138523101807
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00062704086303711
(37) DESCRIBE `ports` 0.0042140483856201
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.0008089542388916
(39) DESCRIBE `ports` 0.0028860569000244
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00063395500183105
(41) DESCRIBE `ports` 0.0029938220977783
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00068402290344238
(43) DESCRIBE `ports` 0.0028810501098633
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00061511993408203
(45) DESCRIBE `ports` 0.0028660297393799
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00078701972961426
(47) DESCRIBE `ports` 0.0029377937316895
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00066804885864258
(49) DESCRIBE `ports` 0.0028948783874512
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00064396858215332
(51) DESCRIBE `ports` 0.0029399394989014
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00059390068054199
(53) DESCRIBE `ports` 0.0029070377349854
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.0007941722869873
(55) DESCRIBE `ports` 0.0029079914093018
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00063085556030273
(57) DESCRIBE `cruiselines` 0.0039811134338379
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00048089027404785
(59) DESCRIBE `orchid_image` 0.0022008419036865
(60) DESCRIBE `cruiselines` 0.0025680065155029
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00048589706420898
(62) DESCRIBE `cabins` 0.0027561187744141
(63) DESCRIBE `deckplans` 0.0019910335540771
(64) DESCRIBE `shipphotos` 0.0017538070678711
(65) DESCRIBE `cruises` 0.0059340000152588
(66) SELECT `cruises`.* FROM `cruises` WHERE (id IN (10657, 26401, 34151, 41754, 45165, 45750, 49614, 52231, 52233, 52645)) ORDER BY FIND_IN_SET(id, '10657,26401,34151,41754,45165,45750,49614,52231,52233,52645') 0.0024302005767822
(67) DESCRIBE `cruiselines` 0.0043749809265137
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '20', '12', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '170', '262', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '16', '208', '187', '36', '49', '47', '88', '216', '251', '151', '141', '212', '181', '4', '110', '118', '59', '30', '140', '73', '115', '147', '264', '261', '48', '159', '213', '108', '276', '209', '211', '113', '90', '57', '82', '184', '38', '95', '180', '52', '244', '35', '105', '64', '134', '257', '172', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,20,12,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,170,262,114,24,28,14,156,191,50,258,195,37,153,16,208,187,36,49,47,88,216,251,151,141,212,181,4,110,118,59,30,140,73,115,147,264,261,48,159,213,108,276,209,211,113,90,57,82,184,38,95,180,52,244,35,105,64,134,257,172,245,177') 0.0095999240875244
(69) DESCRIBE `ships` 0.005986213684082
(70) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1744', '732', '517', '726', '258', '737', '780', '1417', '855', '1324', '1588', '1717', '207', '1794', '1291', '874', '871', '1594', '977', '1199', '1572', '454', '1359', '1766', '404', '1272', '770', '22', '330', '461', '1032', '21', '974', '393', '1237', '66', '716', '1292', '1424', '28', '797', '434', '738', '1682', '553', '1134', '332', '521', '1348', '265', '333', '711', '349', '766', '1768', '1415', '1260', '11', '585', '857', '858', '1419', '1423', '9', '1422', '1501', '1677', '10', '715', '792', '1418', '1420', '1421', '739', '163', '407', '439', '25', '34', '455', '1678', '31', '36', '378', '1132', '3', '24', '39', '657', '542', '674', '1460', '1205', '1721', '1008', '1141', '1607', '520', '837', '1067', '385', '1569', '1742', '1302', '1402', '1773', '386', '966', '1852', '113', '882', '1168', '35', '160', '1012', '1372', '850', '1135', '1233', '1454', '1574', '1822', '37', '573', '626', '1455', '1505', '1811', '98', '338', '768', '1319', '1602', '1676', '610', '30', '63', '285', '451', '1021', '1373', '352', '1284', '986', '1413', '38', '817', '1259', '1733', '547', '1282', '1398', '1411', '148', '1410', '108', '111', '314', '503', '1088', '1193', '1722', '1782', '43', '375', '406', '1308', '286', '748', '1437', '526', '1108', '1323', '1579', '1711', '198', '340', '508', '627', '1320', '116', '970', '1063', '1808', '327', '1145', '1738', '124', '390', '485', '854', '883', '1325', '1586', '582', '590', '1571', '348', '1149', '394', '1028', '1208', '1266', '119', '335', '1492', '1552', '1321', '1412', '1724', '480', '616', '791', '944', '1068', '1575', '1587', '1672', '223', '1810', '70', '82', '114', '652', '704', '1157', '75', '658', '1461', '1809', '4', '147', '441', '545', '1027', '1801', '351', '462', '678', '1289', '683', '1853', '69', '162', '325', '884', '988', '78', '201', '403', '405', '601', '722', '958', '1245', '1318', '1330', '1408', '105', '401', '1188', '1820', '149', '287', '291', '790', '818', '1303', '262', '341', '389', '1073', '1139', '1236', '1486', '123', '483', '580', '651', '776', '81', '1037', '1526', '1539', '1772', '423', '1013', '1159', '1326', '1327', '1367', '1463', '1704', '1771', '673', '1151', '1172', '1540', '1554', '1555', '266', '796', '1019', '1043', '1757', '290', '1040', '1573', '45', '574', '639', '968', '1474', '1730', '1743', '635', '751', '1035', '1426', '84', '775', '795', '1160', '1217', '1223', '1681', '1715', '852', '1338', '1344', '1740', '324', '717', '1029', '1143', '1144', '1283', '1358', '1716', '1758', '972', '1095', '1163', '1206', '1226', '1229', '1343', '1409', '1452', '1453', '1604', '1663', '665', '709', '905', '1045', '1048', '1146', '1150', '151', '212', '417', '643', '644', '1405', '1483', '1673', '1807', '1833', '851', '885', '1136', '1137', '1152', '1262', '1293', '1351', '1448', '1449', '1647', '1746', '1042', '1230', '1231', '1787', '467', '769', '1026', '1051', '1109', '1749', '1791', '150', '453', '707', '1025', '1090', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '208', '448', '663', '954', '973', '1052', '1196', '1224', '1366', '1368', '1459', '1519', '1609', '1632', '1649', '1750', '1751', '1816', '559', '701', '740', '920', '996', '1044', '1049', '1050', '1148', '1274', '1294', '1322', '1329', '1354', '1360', '1361', '1362', '1601', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1055', '1071', '1072', '1339', '1580', '1599', '1714', '1788', '1823', '14', '886', '915', '916', '926', '930', '931', '1047', '1352', '1854', '205', '703', '784', '924', '1039', '1350', '1389', '1596', '1650', '93', '253', '299', '300', '422', '479', '1004', '1020', '1036', '1054', '1225', '1451', '1664', '888', '937', '965', '1626', '1674', '27', '487', '672', '999', '1256')) ORDER BY FIND_IN_SET(id, '1761,1744,732,517,726,258,737,780,1417,855,1324,1588,1717,207,1794,1291,874,871,1594,977,1199,1572,454,1359,1766,404,1272,770,22,330,461,1032,21,974,393,1237,66,716,1292,1424,28,797,434,738,1682,553,1134,332,521,1348,265,333,711,349,766,1768,1415,1260,11,585,857,858,1419,1423,9,1422,1501,1677,10,715,792,1418,1420,1421,739,163,407,439,25,34,455,1678,31,36,378,1132,3,24,39,657,542,674,1460,1205,1721,1008,1141,1607,520,837,1067,385,1569,1742,1302,1402,1773,386,966,1852,113,882,1168,35,160,1012,1372,850,1135,1233,1454,1574,1822,37,573,626,1455,1505,1811,98,338,768,1319,1602,1676,610,30,63,285,451,1021,1373,352,1284,986,1413,38,817,1259,1733,547,1282,1398,1411,148,1410,108,111,314,503,1088,1193,1722,1782,43,375,406,1308,286,748,1437,526,1108,1323,1579,1711,198,340,508,627,1320,116,970,1063,1808,327,1145,1738,124,390,485,854,883,1325,1586,582,590,1571,348,1149,394,1028,1208,1266,119,335,1492,1552,1321,1412,1724,480,616,791,944,1068,1575,1587,1672,223,1810,70,82,114,652,704,1157,75,658,1461,1809,4,147,441,545,1027,1801,351,462,678,1289,683,1853,69,162,325,884,988,78,201,403,405,601,722,958,1245,1318,1330,1408,105,401,1188,1820,149,287,291,790,818,1303,262,341,389,1073,1139,1236,1486,123,483,580,651,776,81,1037,1526,1539,1772,423,1013,1159,1326,1327,1367,1463,1704,1771,673,1151,1172,1540,1554,1555,266,796,1019,1043,1757,290,1040,1573,45,574,639,968,1474,1730,1743,635,751,1035,1426,84,775,795,1160,1217,1223,1681,1715,852,1338,1344,1740,324,717,1029,1143,1144,1283,1358,1716,1758,972,1095,1163,1206,1226,1229,1343,1409,1452,1453,1604,1663,665,709,905,1045,1048,1146,1150,151,212,417,643,644,1405,1483,1673,1807,1833,851,885,1136,1137,1152,1262,1293,1351,1448,1449,1647,1746,1042,1230,1231,1787,467,769,1026,1051,1109,1749,1791,150,453,707,1025,1090,1140,1154,1340,1458,1723,1759,1806,208,448,663,954,973,1052,1196,1224,1366,1368,1459,1519,1609,1632,1649,1750,1751,1816,559,701,740,920,996,1044,1049,1050,1148,1274,1294,1322,1329,1354,1360,1361,1362,1601,1708,1713,1805,666,914,921,923,927,1055,1071,1072,1339,1580,1599,1714,1788,1823,14,886,915,916,926,930,931,1047,1352,1854,205,703,784,924,1039,1350,1389,1596,1650,93,253,299,300,422,479,1004,1020,1036,1054,1225,1451,1664,888,937,965,1626,1674,27,487,672,999,1256') 0.092871904373169
(71) DESCRIBE `cruisetypes` 0.0021531581878662
(72) DESCRIBE `destinations` 0.0032029151916504
(73) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '45', '11', '48', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,45,11,48,21,29,52,34,10,46,56,32') 0.0034229755401611