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

# Query Time
(1) connect 0.0014419555664062
(2) DESCRIBE `cruises` 0.0055780410766602
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.6098620891571
(4) DESCRIBE `avid_specials` 0.0027468204498291
(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.0014519691467285
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00050091743469238
(7) DESCRIBE `ships` 0.0051169395446777
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.0010490417480469
(9) DESCRIBE `ships` 0.0055949687957764
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00073385238647461
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049304962158203
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055384635925293
(13) DESCRIBE `itineraries` 0.0029830932617188
(14) DESCRIBE `ports` 0.003446102142334
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00062823295593262
(16) DESCRIBE `ports` 0.0030310153961182
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00067782402038574
(18) DESCRIBE `ports` 0.0026328563690186
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00075602531433105
(20) DESCRIBE `sailingdates` 0.0026769638061523
(21) DESCRIBE `ports` 0.0035419464111328
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.000885009765625
(23) DESCRIBE `ports` 0.0031108856201172
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00097799301147461
(25) DESCRIBE `ports` 0.0055718421936035
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0009920597076416
(27) DESCRIBE `ports` 0.0040299892425537
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00089406967163086
(29) DESCRIBE `ports` 0.0040338039398193
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00088882446289062
(31) DESCRIBE `ports` 0.0026319026947021
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00046205520629883
(33) DESCRIBE `ports` 0.0025870800018311
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00066304206848145
(35) DESCRIBE `ports` 0.0026090145111084
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00067687034606934
(37) DESCRIBE `ports` 0.0024771690368652
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.000701904296875
(39) DESCRIBE `ports` 0.0027000904083252
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00066184997558594
(41) DESCRIBE `ports` 0.003242015838623
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00072288513183594
(43) DESCRIBE `ports` 0.002856969833374
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00064682960510254
(45) DESCRIBE `ports` 0.0025579929351807
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00068902969360352
(47) DESCRIBE `ports` 0.0024640560150146
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00070810317993164
(49) DESCRIBE `ports` 0.0028510093688965
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00062990188598633
(51) DESCRIBE `ports` 0.002769947052002
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00060892105102539
(53) DESCRIBE `ports` 0.002730131149292
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00085210800170898
(55) DESCRIBE `ports` 0.0027668476104736
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00066781044006348
(57) DESCRIBE `cruiselines` 0.003864049911499
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00077605247497559
(59) DESCRIBE `orchid_image` 0.0032060146331787
(60) DESCRIBE `cruiselines` 0.0038299560546875
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00061917304992676
(62) DESCRIBE `cabins` 0.0040562152862549
(63) DESCRIBE `deckplans` 0.0029890537261963
(64) DESCRIBE `shipphotos` 0.0027937889099121
(65) DESCRIBE `ports` 0.0028340816497803
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00074195861816406
(67) DESCRIBE `ports` 0.0029251575469971
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00063395500183105
(69) DESCRIBE `ports` 0.002871036529541
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00067901611328125
(71) DESCRIBE `ports` 0.0029189586639404
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00074887275695801
(73) DESCRIBE `ports` 0.0030429363250732
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00063109397888184
(75) DESCRIBE `ports` 0.0025551319122314
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00059604644775391
(77) DESCRIBE `ports` 0.0025379657745361
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00060391426086426
(79) DESCRIBE `ports` 0.0024938583374023
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00053000450134277
(81) DESCRIBE `ports` 0.0024750232696533
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00059700012207031
(83) DESCRIBE `ports` 0.0025029182434082
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00060701370239258
(85) DESCRIBE `ports` 0.0025558471679688
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.0005640983581543
(87) DESCRIBE `ports` 0.0023748874664307
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.0005800724029541
(89) DESCRIBE `ports` 0.0020821094512939
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00058794021606445
(91) DESCRIBE `ports` 0.0027730464935303
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00068402290344238
(93) DESCRIBE `ports` 0.0033779144287109
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00080013275146484
(95) DESCRIBE `ports` 0.0034899711608887
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00084996223449707
(97) DESCRIBE `ports` 0.0034208297729492
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00066804885864258
(99) DESCRIBE `ports` 0.0029518604278564
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.0010790824890137
(101) DESCRIBE `ports` 0.0025920867919922
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00073599815368652
(103) DESCRIBE `ports` 0.0024828910827637
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00060391426086426
(105) DESCRIBE `ports` 0.0025949478149414
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00058197975158691
(107) DESCRIBE `ports` 0.0024662017822266
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00052595138549805
(109) DESCRIBE `ports` 0.0024428367614746
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00059914588928223
(111) DESCRIBE `ports` 0.002993106842041
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00064802169799805
(113) DESCRIBE `ports` 0.0033400058746338
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00080490112304688
(115) DESCRIBE `ports` 0.0029110908508301
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00066781044006348
(117) DESCRIBE `ports` 0.0027768611907959
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00067806243896484
(119) DESCRIBE `cruises` 0.0059230327606201
(120) 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.0032711029052734
(121) DESCRIBE `cruiselines` 0.0044891834259033
(122) 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.0090689659118652
(123) DESCRIBE `ships` 0.0051469802856445
(124) 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.08092212677002
(125) DESCRIBE `cruisetypes` 0.0027239322662354
(126) DESCRIBE `destinations` 0.0036900043487549
(127) 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.0033869743347168