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

# Query Time
(1) connect 0.00096011161804199
(2) DESCRIBE `cruises` 0.0042939186096191
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.030861854553223
(4) DESCRIBE `avid_specials` 0.0017809867858887
(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.0011961460113525
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00035905838012695
(7) DESCRIBE `ships` 0.0035521984100342
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00067305564880371
(9) DESCRIBE `ships` 0.0035750865936279
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00040578842163086
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038409233093262
(13) DESCRIBE `itineraries` 0.0017340183258057
(14) DESCRIBE `ports` 0.0017690658569336
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00043392181396484
(16) DESCRIBE `ports` 0.0020909309387207
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00049304962158203
(18) DESCRIBE `ports` 0.0020530223846436
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00037693977355957
(20) DESCRIBE `sailingdates` 0.0015590190887451
(21) DESCRIBE `ports` 0.0019359588623047
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00050616264343262
(23) DESCRIBE `ports` 0.0019760131835938
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00040197372436523
(25) DESCRIBE `ports` 0.0018279552459717
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0004270076751709
(27) DESCRIBE `ports` 0.0017969608306885
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00039291381835938
(29) DESCRIBE `ports` 0.0017678737640381
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00041294097900391
(31) DESCRIBE `ports` 0.0018219947814941
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0003669261932373
(33) DESCRIBE `ports` 0.0018000602722168
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00042605400085449
(35) DESCRIBE `ports` 0.0018620491027832
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00043487548828125
(37) DESCRIBE `ports` 0.0018558502197266
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00041913986206055
(39) DESCRIBE `ports` 0.0019469261169434
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00037407875061035
(41) DESCRIBE `ports` 0.0017280578613281
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00080204010009766
(43) DESCRIBE `ports` 0.0028879642486572
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00057888031005859
(45) DESCRIBE `ports` 0.0026860237121582
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00057816505432129
(47) DESCRIBE `ports` 0.0026540756225586
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.0005800724029541
(49) DESCRIBE `ports` 0.0019149780273438
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00040698051452637
(51) DESCRIBE `ports` 0.0017480850219727
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00037622451782227
(53) DESCRIBE `ports` 0.0017580986022949
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00039196014404297
(55) DESCRIBE `ports` 0.0018668174743652
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00038504600524902
(57) DESCRIBE `cruiselines` 0.0027420520782471
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00045108795166016
(59) DESCRIBE `orchid_image` 0.0021271705627441
(60) DESCRIBE `cruiselines` 0.002626895904541
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00040602684020996
(62) DESCRIBE `cabins` 0.0021469593048096
(63) DESCRIBE `deckplans` 0.0017659664154053
(64) DESCRIBE `shipphotos` 0.00187087059021
(65) DESCRIBE `cruises` 0.005155086517334
(66) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4425, 4425, 6056, 6056, 34157, 38579, 40785, 40852, 40900, 41006)) ORDER BY FIND_IN_SET(id, '4425,4425,6056,6056,34157,38579,40785,40852,40900,41006') 0.0011711120605469
(67) DESCRIBE `cruiselines` 0.0034298896789551
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '12', '144', '183', '20', '18', '101', '120', '31', '8', '131', '96', '7', '15', '103', '91', '29', '206', '170', '262', '33', '114', '24', '28', '156', '50', '14', '191', '258', '195', '37', '16', '153', '208', '36', '187', '49', '47', '216', '88', '251', '141', '151', '212', '181', '110', '4', '118', '59', '264', '30', '115', '140', '73', '48', '159', '108', '261', '147', '213', '209', '113', '276', '211', '38', '35', '90', '57', '82', '184', '95', '180', '52', '244', '105', '172', '64', '257', '134', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,12,144,183,20,18,101,120,31,8,131,96,7,15,103,91,29,206,170,262,33,114,24,28,156,50,14,191,258,195,37,16,153,208,36,187,49,47,216,88,251,141,151,212,181,110,4,118,59,264,30,115,140,73,48,159,108,261,147,213,209,113,276,211,38,35,90,57,82,184,95,180,52,244,105,172,64,257,134,245,177') 0.0077769756317139
(69) DESCRIBE `ships` 0.0040459632873535
(70) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1744', '732', '517', '737', '1417', '726', '258', '855', '1588', '780', '207', '1717', '1291', '1794', '1324', '454', '1594', '1199', '874', '977', '1237', '871', '1272', '1359', '1572', '974', '404', '1032', '22', '461', '21', '770', '1766', '330', '797', '393', '1424', '1292', '1554', '1555', '716', '28', '66', '521', '1682', '1348', '434', '553', '349', '333', '738', '332', '1423', '1677', '1419', '1422', '1134', '1420', '711', '766', '1418', '1421', '857', '858', '1501', '715', '1415', '265', '11', '9', '792', '10', '439', '1260', '739', '1205', '25', '407', '585', '24', '1768', '163', '455', '542', '674', '1067', '1678', '657', '3', '837', '1607', '1132', '1460', '503', '1008', '882', '1574', '1141', '1302', '1721', '1773', '113', '520', '1402', '385', '1135', '1569', '386', '986', '1742', '850', '966', '1168', '63', '160', '573', '1233', '1372', '1454', '1319', '1602', '610', '626', '1852', '98', '1021', '1455', '285', '1373', '817', '1284', '198', '352', '1822', '338', '1413', '1505', '1811', '111', '480', '1398', '1411', '1676', '1259', '1410', '1193', '116', '286', '547', '1733', '108', '314', '768', '1738', '124', '148', '526', '1088', '1320', '1323', '1579', '43', '340', '883', '1437', '508', '748', '970', '1108', '1308', '854', '1266', '1325', '1552', '1722', '327', '390', '627', '1571', '1782', '582', '590', '1145', '1575', '462', '485', '1063', '1586', '1711', '348', '406', '1245', '1492', '394', '944', '1028', '1724', '791', '1149', '1208', '1321', '1412', '70', '119', '335', '616', '405', '658', '1587', '1672', '114', '162', '1027', '4', '69', '704', '1463', '82', '441', '545', '652', '1068', '1289', '451', '678', '958', '1157', '31', '34', '38', '75', '351', '37', '105', '722', '1461', '325', '401', '1303', '1318', '1330', '78', '378', '403', '601', '884', '1159', '1408', '1809', '683', '1236', '1801', '201', '262', '291', '341', '651', '389', '644', '1139', '1188', '1367', '1526', '1853', '14', '36', '580', '988', '1013', '1151', '1540', '287', '1073', '1172', '1808', '123', '639', '790', '818', '1019', '1037', '1326', '1327', '1820', '423', '483', '635', '776', '1405', '1573', '1599', '1704', '81', '266', '673', '1282', '1743', '1772', '290', '796', '852', '1160', '1426', '1539', '1715', '212', '1043', '1217', '1344', '45', '574', '775', '968', '1040', '1223', '1474', '1716', '1730', '84', '751', '1095', '1143', '1144', '1163', '1226', '1229', '1343', '1358', '1452', '1453', '1604', '324', '795', '1029', '1035', '1681', '1757', '1771', '39', '1045', '1409', '30', '35', '709', '1012', '1137', '1283', '1338', '1449', '905', '1048', '1152', '1647', '1663', '1740', '417', '972', '1136', '1150', '1206', '1448', '1673', '151', '223', '769', '885', '1025', '1090', '1483', '27', '150', '643', '701', '851', '1055', '253', '665', '1026', '1293', '1351', '1750', '1758', '1146', '1262', '1713', '1042', '1071', '1140', '1154', '1230', '1231', '1329', '1458', '1714', '1807', '1833', '448', '453', '663', '707', '784', '954', '973', '1049', '1109', '1322', '1366', '1519', '1580', '1632', '1751', '208', '666', '740', '1052', '1148', '1196', '1340', '1368', '1459', '1708', '1723', '1787', '147', '205', '467', '1050', '1051', '1360', '1361', '1362', '1389', '1749', '1791', '93', '559', '703', '920', '1224', '1274', '1294', '1350', '1609', '1649', '1759', '1806', '717', '886', '921', '923', '1020', '1044', '1301', '1339', '1352', '1354', '1674', '1816', '888', '914', '915', '927', '996', '1039', '1072', '1601', '1679', '1805', '479', '916', '926', '930', '931', '1036', '1047', '1664', '1788', '1823', '149', '730', '924', '1468', '1596', '1767', '1854', '152', '965', '1004', '1054', '1075', '1241', '1445', '1486', '1626', '1650', '299', '300', '422', '821')) ORDER BY FIND_IN_SET(id, '1761,1744,732,517,737,1417,726,258,855,1588,780,207,1717,1291,1794,1324,454,1594,1199,874,977,1237,871,1272,1359,1572,974,404,1032,22,461,21,770,1766,330,797,393,1424,1292,1554,1555,716,28,66,521,1682,1348,434,553,349,333,738,332,1423,1677,1419,1422,1134,1420,711,766,1418,1421,857,858,1501,715,1415,265,11,9,792,10,439,1260,739,1205,25,407,585,24,1768,163,455,542,674,1067,1678,657,3,837,1607,1132,1460,503,1008,882,1574,1141,1302,1721,1773,113,520,1402,385,1135,1569,386,986,1742,850,966,1168,63,160,573,1233,1372,1454,1319,1602,610,626,1852,98,1021,1455,285,1373,817,1284,198,352,1822,338,1413,1505,1811,111,480,1398,1411,1676,1259,1410,1193,116,286,547,1733,108,314,768,1738,124,148,526,1088,1320,1323,1579,43,340,883,1437,508,748,970,1108,1308,854,1266,1325,1552,1722,327,390,627,1571,1782,582,590,1145,1575,462,485,1063,1586,1711,348,406,1245,1492,394,944,1028,1724,791,1149,1208,1321,1412,70,119,335,616,405,658,1587,1672,114,162,1027,4,69,704,1463,82,441,545,652,1068,1289,451,678,958,1157,31,34,38,75,351,37,105,722,1461,325,401,1303,1318,1330,78,378,403,601,884,1159,1408,1809,683,1236,1801,201,262,291,341,651,389,644,1139,1188,1367,1526,1853,14,36,580,988,1013,1151,1540,287,1073,1172,1808,123,639,790,818,1019,1037,1326,1327,1820,423,483,635,776,1405,1573,1599,1704,81,266,673,1282,1743,1772,290,796,852,1160,1426,1539,1715,212,1043,1217,1344,45,574,775,968,1040,1223,1474,1716,1730,84,751,1095,1143,1144,1163,1226,1229,1343,1358,1452,1453,1604,324,795,1029,1035,1681,1757,1771,39,1045,1409,30,35,709,1012,1137,1283,1338,1449,905,1048,1152,1647,1663,1740,417,972,1136,1150,1206,1448,1673,151,223,769,885,1025,1090,1483,27,150,643,701,851,1055,253,665,1026,1293,1351,1750,1758,1146,1262,1713,1042,1071,1140,1154,1230,1231,1329,1458,1714,1807,1833,448,453,663,707,784,954,973,1049,1109,1322,1366,1519,1580,1632,1751,208,666,740,1052,1148,1196,1340,1368,1459,1708,1723,1787,147,205,467,1050,1051,1360,1361,1362,1389,1749,1791,93,559,703,920,1224,1274,1294,1350,1609,1649,1759,1806,717,886,921,923,1020,1044,1301,1339,1352,1354,1674,1816,888,914,915,927,996,1039,1072,1601,1679,1805,479,916,926,930,931,1036,1047,1664,1788,1823,149,730,924,1468,1596,1767,1854,152,965,1004,1054,1075,1241,1445,1486,1626,1650,299,300,422,821') 0.05772590637207
(71) DESCRIBE `cruisetypes` 0.002112865447998
(72) DESCRIBE `destinations` 0.002446174621582
(73) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '43', '37', '9', '2', '25', '8', '44', '55', '53', '39', '38', '28', '30', '26', '40', '7', '48', '45', '11', '49', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,43,37,9,2,25,8,44,55,53,39,38,28,30,26,40,7,48,45,11,49,21,29,52,34,10,46,56,32') 0.0025970935821533