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

# Query Time
(1) connect 0.00099492073059082
(2) DESCRIBE `cruises` 0.0043289661407471
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.032542943954468
(4) DESCRIBE `avid_specials` 0.001878023147583
(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.0011138916015625
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00042510032653809
(7) DESCRIBE `ships` 0.0038619041442871
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00053191184997559
(9) DESCRIBE `ships` 0.0037338733673096
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00039410591125488
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039386749267578
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004429817199707
(13) DESCRIBE `itineraries` 0.0019679069519043
(14) DESCRIBE `ports` 0.0017960071563721
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00047779083251953
(16) DESCRIBE `ports` 0.0017209053039551
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00040221214294434
(18) DESCRIBE `ports` 0.0017879009246826
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00037097930908203
(20) DESCRIBE `sailingdates` 0.0016388893127441
(21) DESCRIBE `ports` 0.0021641254425049
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00044894218444824
(23) DESCRIBE `ports` 0.0020959377288818
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00056099891662598
(25) DESCRIBE `ports` 0.0026018619537354
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00051307678222656
(27) DESCRIBE `ports` 0.0020239353179932
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00037908554077148
(29) DESCRIBE `ports` 0.0020029544830322
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0004270076751709
(31) DESCRIBE `ports` 0.0017869472503662
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00037503242492676
(33) DESCRIBE `ports` 0.002295970916748
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00072312355041504
(35) DESCRIBE `ports` 0.0025629997253418
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00041317939758301
(37) DESCRIBE `ports` 0.0018830299377441
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00039982795715332
(39) DESCRIBE `ports` 0.0018360614776611
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00037789344787598
(41) DESCRIBE `ports` 0.0017890930175781
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00043296813964844
(43) DESCRIBE `ports` 0.0017919540405273
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00037598609924316
(45) DESCRIBE `ports` 0.0018279552459717
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00046706199645996
(47) DESCRIBE `ports` 0.0018091201782227
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00039315223693848
(49) DESCRIBE `ports` 0.0017940998077393
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00038909912109375
(51) DESCRIBE `ports` 0.0020279884338379
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00037097930908203
(53) DESCRIBE `ports` 0.0020301342010498
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00040793418884277
(55) DESCRIBE `ports` 0.0017440319061279
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00037097930908203
(57) DESCRIBE `cruiselines` 0.0025250911712646
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00045585632324219
(59) DESCRIBE `orchid_image` 0.0021860599517822
(60) DESCRIBE `cruiselines` 0.0027971267700195
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00040292739868164
(62) DESCRIBE `cabins` 0.0019130706787109
(63) DESCRIBE `deckplans` 0.0017540454864502
(64) DESCRIBE `shipphotos` 0.0021398067474365
(65) DESCRIBE `cruises` 0.0041840076446533
(66) SELECT `cruises`.* FROM `cruises` WHERE (id IN (8256, 20573, 34153, 34164, 34205, 39342, 40593, 41693, 47265, 52716)) ORDER BY FIND_IN_SET(id, '8256,20573,34153,34164,34205,39342,40593,41693,47265,52716') 0.0013949871063232
(67) DESCRIBE `cruiselines` 0.0030810832977295
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '183', '7', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '91', '206', '33', '170', '262', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '16', '153', '208', '187', '36', '49', '47', '88', '216', '251', '151', '141', '212', '181', '4', '110', '118', '59', '30', '140', '264', '73', '115', '48', '147', '261', '159', '108', '213', '276', '209', '211', '113', '90', '38', '57', '82', '184', '35', '95', '180', '52', '244', '105', '64', '134', '172', '257', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,183,7,18,101,8,120,31,131,29,96,15,103,91,206,33,170,262,114,24,28,14,156,191,50,258,195,37,16,153,208,187,36,49,47,88,216,251,151,141,212,181,4,110,118,59,30,140,264,73,115,48,147,261,159,108,213,276,209,211,113,90,38,57,82,184,35,95,180,52,244,105,64,134,172,257,245,177') 0.0056328773498535
(69) DESCRIBE `ships` 0.0051710605621338
(70) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1744', '732', '517', '726', '737', '258', '1417', '780', '855', '1717', '207', '1324', '1588', '1794', '1291', '1594', '874', '1199', '454', '871', '977', '1572', '1359', '1272', '404', '1766', '1237', '974', '22', '330', '461', '770', '1032', '21', '393', '797', '716', '1292', '1424', '28', '66', '434', '1682', '521', '1348', '553', '738', '1134', '332', '333', '265', '711', '349', '766', '857', '1415', '858', '1260', '1501', '9', '11', '792', '1419', '1420', '1423', '1768', '1422', '10', '34', '439', '585', '739', '1418', '1421', '1677', '25', '36', '378', '407', '31', '163', '715', '455', '24', '1205', '1678', '3', '542', '674', '1132', '657', '39', '1460', '837', '882', '1141', '1607', '1008', '1721', '1067', '520', '1402', '1302', '1773', '1569', '1742', '35', '385', '1012', '113', '386', '966', '1574', '850', '1135', '1372', '37', '160', '1168', '1852', '30', '63', '573', '610', '1233', '1454', '626', '1319', '1554', '1555', '1602', '98', '338', '768', '1455', '1822', '285', '1021', '1505', '1811', '38', '1676', '451', '986', '1284', '1373', '352', '503', '1398', '1259', '1411', '1413', '1733', '547', '148', '817', '1193', '1410', '43', '108', '111', '198', '314', '406', '1088', '1282', '286', '375', '1722', '748', '1437', '1782', '116', '340', '526', '1308', '1320', '1323', '1579', '970', '1108', '1738', '508', '1325', '1711', '327', '480', '627', '854', '1266', '124', '390', '582', '1028', '1063', '1571', '1586', '1808', '485', '590', '1145', '883', '1552', '119', '348', '394', '1149', '1208', '1321', '1492', '335', '616', '944', '1412', '1724', '791', '1575', '1587', '70', '223', '462', '658', '704', '1672', '114', '1068', '1245', '4', '75', '82', '652', '1027', '1810', '69', '351', '441', '545', '1157', '1289', '147', '405', '678', '1461', '1809', '162', '683', '1801', '325', '401', '722', '1318', '1408', '78', '403', '884', '958', '1330', '1853', '105', '201', '601', '988', '1463', '149', '287', '291', '341', '1188', '1303', '262', '389', '1236', '1820', '651', '776', '790', '818', '1159', '123', '483', '580', '1073', '1139', '1367', '1486', '1526', '1539', '81', '1013', '1037', '1151', '1172', '1540', '266', '423', '673', '1019', '1704', '1772', '1326', '1327', '1730', '1771', '290', '639', '1573', '45', '574', '796', '968', '1043', '1426', '1474', '1743', '1757', '635', '1035', '1040', '1160', '1715', '84', '644', '751', '852', '1217', '1344', '1681', '775', '795', '1716', '212', '324', '717', '1095', '1143', '1144', '1223', '1226', '1229', '1338', '1343', '1358', '1452', '1453', '1604', '972', '1048', '1283', '1405', '1409', '1663', '1740', '709', '905', '1029', '1045', '1163', '1758', '14', '665', '1137', '1206', '1449', '151', '885', '1146', '1150', '1152', '1647', '1673', '417', '643', '701', '1136', '1262', '1351', '1448', '1483', '1807', '1833', '150', '769', '851', '1025', '1090', '1109', '1293', '1746', '707', '973', '1042', '1230', '1231', '1750', '1787', '208', '448', '453', '467', '1026', '1051', '1052', '1140', '1329', '1749', '1791', '740', '1071', '1154', '1196', '1322', '1340', '1458', '1519', '1599', '1649', '1713', '1723', '1759', '1806', '253', '663', '954', '1044', '1049', '1055', '1224', '1366', '1368', '1459', '1580', '1609', '1632', '1714', '1751', '1816', '27', '559', '920', '996', '1050', '1148', '1274', '1294', '1354', '1360', '1361', '1362', '1389', '1601', '1708', '1805', '205', '666', '784', '886', '914', '921', '923', '927', '1047', '1072', '1339', '1350', '1352', '1788', '1823', '93', '915', '916', '926', '930', '931', '1036', '1854', '479', '703', '888', '924', '965', '1039', '1301', '1596', '1650', '1664', '1674', '1679', '299', '300', '422', '1004', '1020', '1054', '1225', '1451', '1468', '1626', '937', '1445')) ORDER BY FIND_IN_SET(id, '1761,1744,732,517,726,737,258,1417,780,855,1717,207,1324,1588,1794,1291,1594,874,1199,454,871,977,1572,1359,1272,404,1766,1237,974,22,330,461,770,1032,21,393,797,716,1292,1424,28,66,434,1682,521,1348,553,738,1134,332,333,265,711,349,766,857,1415,858,1260,1501,9,11,792,1419,1420,1423,1768,1422,10,34,439,585,739,1418,1421,1677,25,36,378,407,31,163,715,455,24,1205,1678,3,542,674,1132,657,39,1460,837,882,1141,1607,1008,1721,1067,520,1402,1302,1773,1569,1742,35,385,1012,113,386,966,1574,850,1135,1372,37,160,1168,1852,30,63,573,610,1233,1454,626,1319,1554,1555,1602,98,338,768,1455,1822,285,1021,1505,1811,38,1676,451,986,1284,1373,352,503,1398,1259,1411,1413,1733,547,148,817,1193,1410,43,108,111,198,314,406,1088,1282,286,375,1722,748,1437,1782,116,340,526,1308,1320,1323,1579,970,1108,1738,508,1325,1711,327,480,627,854,1266,124,390,582,1028,1063,1571,1586,1808,485,590,1145,883,1552,119,348,394,1149,1208,1321,1492,335,616,944,1412,1724,791,1575,1587,70,223,462,658,704,1672,114,1068,1245,4,75,82,652,1027,1810,69,351,441,545,1157,1289,147,405,678,1461,1809,162,683,1801,325,401,722,1318,1408,78,403,884,958,1330,1853,105,201,601,988,1463,149,287,291,341,1188,1303,262,389,1236,1820,651,776,790,818,1159,123,483,580,1073,1139,1367,1486,1526,1539,81,1013,1037,1151,1172,1540,266,423,673,1019,1704,1772,1326,1327,1730,1771,290,639,1573,45,574,796,968,1043,1426,1474,1743,1757,635,1035,1040,1160,1715,84,644,751,852,1217,1344,1681,775,795,1716,212,324,717,1095,1143,1144,1223,1226,1229,1338,1343,1358,1452,1453,1604,972,1048,1283,1405,1409,1663,1740,709,905,1029,1045,1163,1758,14,665,1137,1206,1449,151,885,1146,1150,1152,1647,1673,417,643,701,1136,1262,1351,1448,1483,1807,1833,150,769,851,1025,1090,1109,1293,1746,707,973,1042,1230,1231,1750,1787,208,448,453,467,1026,1051,1052,1140,1329,1749,1791,740,1071,1154,1196,1322,1340,1458,1519,1599,1649,1713,1723,1759,1806,253,663,954,1044,1049,1055,1224,1366,1368,1459,1580,1609,1632,1714,1751,1816,27,559,920,996,1050,1148,1274,1294,1354,1360,1361,1362,1389,1601,1708,1805,205,666,784,886,914,921,923,927,1047,1072,1339,1350,1352,1788,1823,93,915,916,926,930,931,1036,1854,479,703,888,924,965,1039,1301,1596,1650,1664,1674,1679,299,300,422,1004,1020,1054,1225,1451,1468,1626,937,1445') 0.073440074920654
(71) DESCRIBE `cruisetypes` 0.0021140575408936
(72) DESCRIBE `destinations` 0.0035760402679443
(73) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '38', '40', '26', '28', '30', '7', '49', '45', '48', '11', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,43,25,37,9,2,8,44,55,53,39,38,40,26,28,30,7,49,45,48,11,21,29,52,34,10,46,56,32') 0.0039310455322266