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

Itinerary for Cruise Delling, Lyon & Provence ex Lyon to Avignon

Select a sailing date:

Day Port Arrive Depart
Day 1 Lyon, France
Day 2 Lyon, France
Day 3 Lyon, France
Day 4 Vienne, France
Day 4 Tournon, France
Day 5 Viviers, France
Day 6 Avignon, France
Day 7 Arles, France
Day 8 Avignon, France

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

Total elapsed time: 0.59902667999268

# Query Time
(1) connect 0.0013308525085449
(2) DESCRIBE `cruises` 0.0078420639038086
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.072517156600952
(4) DESCRIBE `avid_specials` 0.0035529136657715
(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.0043580532073975
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00086498260498047
(7) DESCRIBE `ships` 0.0095000267028809
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.0015029907226562
(9) DESCRIBE `ships` 0.010530948638916
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.0032739639282227
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0070371627807617
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.024824142456055
(13) DESCRIBE `itineraries` 0.0058472156524658
(14) DESCRIBE `ports` 0.012310028076172
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00085186958312988
(16) DESCRIBE `ports` 0.0029239654541016
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00075912475585938
(18) DESCRIBE `ports` 0.0027878284454346
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00064587593078613
(20) DESCRIBE `sailingdates` 0.0026669502258301
(21) DESCRIBE `ports` 0.002903938293457
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00071907043457031
(23) DESCRIBE `ports` 0.0030019283294678
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00067305564880371
(25) DESCRIBE `ports` 0.0029990673065186
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00068807601928711
(27) DESCRIBE `ports` 0.0029468536376953
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00058794021606445
(29) DESCRIBE `ports` 0.0030429363250732
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0011570453643799
(31) DESCRIBE `ports` 0.0029020309448242
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00066781044006348
(33) DESCRIBE `ports` 0.0030901432037354
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00075387954711914
(35) DESCRIBE `ports` 0.0032780170440674
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00072598457336426
(37) DESCRIBE `ports` 0.0031580924987793
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00076794624328613
(39) DESCRIBE `ports` 0.0035598278045654
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00065088272094727
(41) DESCRIBE `ports` 0.0032389163970947
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00070595741271973
(43) DESCRIBE `ports` 0.0028989315032959
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00059795379638672
(45) DESCRIBE `ports` 0.0028338432312012
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00070714950561523
(47) DESCRIBE `ports` 0.0028090476989746
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00069403648376465
(49) DESCRIBE `ports` 0.0029637813568115
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00068283081054688
(51) DESCRIBE `ports` 0.0027971267700195
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.0006248950958252
(53) DESCRIBE `ports` 0.0028738975524902
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00081014633178711
(55) DESCRIBE `ports` 0.0029668807983398
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00068092346191406
(57) DESCRIBE `cruiselines` 0.0041708946228027
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00087285041809082
(59) DESCRIBE `orchid_image` 0.003389835357666
(60) DESCRIBE `cruiselines` 0.0043251514434814
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0013730525970459
(62) DESCRIBE `cabins` 0.0034110546112061
(63) DESCRIBE `deckplans` 0.0028550624847412
(64) DESCRIBE `shipphotos` 0.0029809474945068
(65) DESCRIBE `ports` 0.0033819675445557
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00080990791320801
(67) DESCRIBE `ports` 0.0050950050354004
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0020508766174316
(69) DESCRIBE `ports` 0.0097928047180176
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0016210079193115
(71) DESCRIBE `ports` 0.0047688484191895
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0007779598236084
(73) DESCRIBE `ports` 0.0026521682739258
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00068402290344238
(75) DESCRIBE `ports` 0.0034279823303223
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00078511238098145
(77) DESCRIBE `ports` 0.0033590793609619
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00093603134155273
(79) DESCRIBE `ports` 0.0031490325927734
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00067806243896484
(81) DESCRIBE `ports` 0.0030949115753174
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00071096420288086
(83) DESCRIBE `ports` 0.0038540363311768
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00077199935913086
(85) DESCRIBE `ports` 0.0028650760650635
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00070095062255859
(87) DESCRIBE `ports` 0.0030570030212402
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00092506408691406
(89) DESCRIBE `ports` 0.0030550956726074
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00072503089904785
(91) DESCRIBE `ports` 0.0031158924102783
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00084710121154785
(93) DESCRIBE `ports` 0.0029218196868896
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00068497657775879
(95) DESCRIBE `ports` 0.002997875213623
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00067901611328125
(97) DESCRIBE `ports` 0.0030291080474854
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00063991546630859
(99) DESCRIBE `ports` 0.0036249160766602
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00080299377441406
(101) DESCRIBE `ports` 0.0032980442047119
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00072216987609863
(103) DESCRIBE `ports` 0.0029330253601074
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00059199333190918
(105) DESCRIBE `ports` 0.0037651062011719
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00091695785522461
(107) DESCRIBE `ports` 0.0030560493469238
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00097298622131348
(109) DESCRIBE `ports` 0.003126859664917
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00066590309143066
(111) DESCRIBE `ports` 0.0028469562530518
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00061893463134766
(113) DESCRIBE `ports` 0.0027449131011963
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00061202049255371
(115) DESCRIBE `ports` 0.002547025680542
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00056290626525879
(117) DESCRIBE `ports` 0.0027608871459961
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00074887275695801
(119) DESCRIBE `cruises` 0.0057458877563477
(120) SELECT `cruises`.* FROM `cruises` WHERE (id IN (28929, 34149, 34167, 34187, 49599, 50054, 52647, 56511, 57661, 57720)) ORDER BY FIND_IN_SET(id, '28929,34149,34167,34187,49599,50054,52647,56511,57661,57720') 0.0027568340301514
(121) DESCRIBE `cruiselines` 0.0044329166412354
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '183', '101', '8', '31', '120', '131', '29', '96', '103', '15', '206', '91', '262', '33', '114', '24', '170', '14', '28', '156', '258', '191', '50', '195', '153', '37', '208', '16', '187', '49', '36', '88', '251', '47', '151', '216', '212', '141', '181', '118', '4', '110', '59', '140', '147', '30', '261', '48', '73', '213', '211', '276', '209', '159', '115', '264', '82', '113', '108', '57', '95', '90', '184', '244', '52', '180', '64', '38', '35', '105', '134', '257', '245')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,183,101,8,31,120,131,29,96,103,15,206,91,262,33,114,24,170,14,28,156,258,191,50,195,153,37,208,16,187,49,36,88,251,47,151,216,212,141,181,118,4,110,59,140,147,30,261,48,73,213,211,276,209,159,115,264,82,113,108,57,95,90,184,244,52,180,64,38,35,105,134,257,245') 0.027187824249268
(123) DESCRIBE `ships` 0.0057640075683594
(124) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '258', '1324', '517', '737', '780', '1417', '1588', '1717', '855', '871', '207', '1766', '1794', '1291', '1572', '874', '977', '454', '404', '1594', '770', '1359', '1272', '1199', '66', '22', '21', '330', '461', '738', '393', '1032', '1134', '1424', '434', '265', '553', '716', '974', '28', '332', '1237', '1292', '333', '1682', '1768', '797', '521', '349', '1260', '1348', '1419', '1423', '1422', '1418', '1420', '1421', '766', '1415', '711', '715', '163', '792', '9', '455', '11', '1678', '10', '25', '407', '585', '739', '439', '674', '857', '858', '1132', '1501', '1677', '657', '3', '24', '34', '378', '542', '1460', '39', '1008', '31', '36', '520', '1721', '1852', '1569', '966', '1233', '1141', '1742', '1822', '385', '1505', '1811', '1607', '1676', '386', '1168', '1302', '1372', '35', '1012', '1402', '1455', '626', '768', '850', '1373', '1773', '837', '98', '986', '817', '1319', '113', '338', '451', '1205', '1282', '1413', '1602', '573', '882', '1410', '1782', '160', '1021', '1135', '1259', '1411', '352', '547', '1067', '1454', '1574', '1733', '285', '610', '1284', '1398', '37', '148', '314', '375', '1063', '1437', '30', '63', '111', '198', '508', '1145', '108', '883', '1193', '1308', '1722', '627', '1088', '286', '1149', '1808', '340', '748', '406', '526', '970', '1028', '1320', '1323', '1579', '1711', '38', '43', '124', '485', '1325', '327', '394', '1068', '1586', '348', '582', '854', '1810', '116', '390', '1157', '1321', '1412', '1492', '1724', '590', '1461', '1571', '1809', '616', '1208', '1575', '1672', '1738', '1801', '82', '119', '223', '462', '652', '1108', '1853', '351', '944', '1027', '114', '791', '1587', '147', '704', '884', '1318', '1408', '1820', '75', '678', '1266', '70', '78', '503', '545', '658', '683', '1139', '1486', '1552', '4', '201', '325', '335', '401', '441', '958', '1188', '81', '149', '291', '722', '988', '1289', '1330', '1772', '162', '790', '1326', '1327', '1771', '287', '403', '580', '601', '776', '1073', '1367', '105', '389', '423', '651', '1037', '1043', '1151', '1757', '818', '1040', '1236', '1303', '1704', '69', '341', '1013', '1019', '1539', '123', '262', '266', '1172', '796', '1223', '45', '290', '405', '639', '673', '1474', '1526', '1740', '84', '751', '1029', '1159', '1338', '1540', '1715', '1743', '1758', '480', '852', '1035', '1160', '1163', '1206', '1344', '1426', '483', '795', '968', '972', '1146', '1150', '1217', '1226', '1229', '1452', '1453', '1604', '1681', '1716', '324', '417', '635', '643', '717', '1143', '1144', '1245', '1283', '1343', '1358', '1483', '1573', '1807', '1833', '574', '709', '775', '851', '905', '1048', '1136', '1262', '1293', '1448', '1746', '1042', '1045', '1230', '1231', '1787', '467', '885', '1026', '1051', '1095', '1137', '1663', '1749', '1791', '1140', '1154', '1340', '1351', '1409', '1458', '1723', '1759', '1806', '663', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1730', '1751', '559', '665', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1463', '1647', '1673', '1708', '1713', '1805', '151', '448', '666', '914', '921', '923', '927', '1025', '1044', '1055', '1072', '1090', '1196', '1339', '1601', '1714', '1788', '1823', '886', '915', '916', '926', '930', '931', '1152', '1322', '1449', '1649', '1750', '1854', '208', '212', '453', '703', '924', '1047', '1052', '1109', '1596', '1650', '1816', '299', '300', '422', '740', '769', '1004', '1020', '1036', '1039', '1054', '1225', '1352', '1451', '1519', '1580', '150', '937', '1294', '487', '672', '707', '888', '1256', '1301', '93', '205', '479', '671', '821', '1071', '1232', '1389', '1445', '1664', '516', '1005', '1060', '1329', '1350', '1626', '1792', '1821', '420', '644', '761')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,258,1324,517,737,780,1417,1588,1717,855,871,207,1766,1794,1291,1572,874,977,454,404,1594,770,1359,1272,1199,66,22,21,330,461,738,393,1032,1134,1424,434,265,553,716,974,28,332,1237,1292,333,1682,1768,797,521,349,1260,1348,1419,1423,1422,1418,1420,1421,766,1415,711,715,163,792,9,455,11,1678,10,25,407,585,739,439,674,857,858,1132,1501,1677,657,3,24,34,378,542,1460,39,1008,31,36,520,1721,1852,1569,966,1233,1141,1742,1822,385,1505,1811,1607,1676,386,1168,1302,1372,35,1012,1402,1455,626,768,850,1373,1773,837,98,986,817,1319,113,338,451,1205,1282,1413,1602,573,882,1410,1782,160,1021,1135,1259,1411,352,547,1067,1454,1574,1733,285,610,1284,1398,37,148,314,375,1063,1437,30,63,111,198,508,1145,108,883,1193,1308,1722,627,1088,286,1149,1808,340,748,406,526,970,1028,1320,1323,1579,1711,38,43,124,485,1325,327,394,1068,1586,348,582,854,1810,116,390,1157,1321,1412,1492,1724,590,1461,1571,1809,616,1208,1575,1672,1738,1801,82,119,223,462,652,1108,1853,351,944,1027,114,791,1587,147,704,884,1318,1408,1820,75,678,1266,70,78,503,545,658,683,1139,1486,1552,4,201,325,335,401,441,958,1188,81,149,291,722,988,1289,1330,1772,162,790,1326,1327,1771,287,403,580,601,776,1073,1367,105,389,423,651,1037,1043,1151,1757,818,1040,1236,1303,1704,69,341,1013,1019,1539,123,262,266,1172,796,1223,45,290,405,639,673,1474,1526,1740,84,751,1029,1159,1338,1540,1715,1743,1758,480,852,1035,1160,1163,1206,1344,1426,483,795,968,972,1146,1150,1217,1226,1229,1452,1453,1604,1681,1716,324,417,635,643,717,1143,1144,1245,1283,1343,1358,1483,1573,1807,1833,574,709,775,851,905,1048,1136,1262,1293,1448,1746,1042,1045,1230,1231,1787,467,885,1026,1051,1095,1137,1663,1749,1791,1140,1154,1340,1351,1409,1458,1723,1759,1806,663,954,1224,1366,1368,1459,1609,1632,1730,1751,559,665,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1463,1647,1673,1708,1713,1805,151,448,666,914,921,923,927,1025,1044,1055,1072,1090,1196,1339,1601,1714,1788,1823,886,915,916,926,930,931,1152,1322,1449,1649,1750,1854,208,212,453,703,924,1047,1052,1109,1596,1650,1816,299,300,422,740,769,1004,1020,1036,1039,1054,1225,1352,1451,1519,1580,150,937,1294,487,672,707,888,1256,1301,93,205,479,671,821,1071,1232,1389,1445,1664,516,1005,1060,1329,1350,1626,1792,1821,420,644,761') 0.15955996513367
(125) DESCRIBE `cruisetypes` 0.0024001598358154
(126) DESCRIBE `destinations` 0.0037870407104492
(127) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '2', '9', '8', '44', '55', '39', '53', '26', '38', '28', '40', '30', '49', '11', '21', '7', '45', '29', '48', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,2,9,8,44,55,39,53,26,38,28,40,30,49,11,21,7,45,29,48,52,34,10,46,56,32') 0.0043590068817139