or, enquire about your chosen options

Recently Viewed Cruises

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”
  6. Frequently Asked Questions

Sign up to our newsletter and become the first to know about our latest deals and promotions

Sign Up Now
Delling, Lyon & Provence ex Lyon to Avignon - Cruise Cabin types

Viking Delling

Book Now 0800 60 82 60
  • TIA

Copyright © 2010 Cruise Factor Limited
All rights reserved

PO Box 5081,
Mt Maunganui 3150

 

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

# Query Time
(1) connect 0.0011169910430908
(2) DESCRIBE `cruises` 0.0033049583435059
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'delling-lyon-provence-2018-ex-lyon-to-avignon') AND (orchid_available = 1) LIMIT 1 0.067336082458496
(4) DESCRIBE `avid_specials` 0.0015249252319336
(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.0016970634460449
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00061202049255371
(7) DESCRIBE `ships` 0.0028040409088135
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00039410591125488
(9) DESCRIBE `ships` 0.0025830268859863
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00030183792114258
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026988983154297
(13) DESCRIBE `itineraries` 0.0012350082397461
(14) DESCRIBE `ports` 0.0013730525970459
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00033783912658691
(16) DESCRIBE `ports` 0.0013971328735352
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00045204162597656
(18) DESCRIBE `ports` 0.0014920234680176
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00031280517578125
(20) DESCRIBE `sailingdates` 0.0011940002441406
(21) DESCRIBE `ports` 0.0018517971038818
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00042390823364258
(23) DESCRIBE `ports` 0.0014309883117676
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00030517578125
(25) DESCRIBE `ports` 0.0013740062713623
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00031208992004395
(27) DESCRIBE `ports` 0.0013089179992676
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00032591819763184
(29) DESCRIBE `ports` 0.001338005065918
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00030994415283203
(31) DESCRIBE `ports` 0.00124192237854
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00027799606323242
(33) DESCRIBE `ports` 0.0012609958648682
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00032901763916016
(35) DESCRIBE `ports` 0.0014450550079346
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00034093856811523
(37) DESCRIBE `ports` 0.0012748241424561
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.0002899169921875
(39) DESCRIBE `ports` 0.0012750625610352
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00027894973754883
(41) DESCRIBE `ports` 0.0013411045074463
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00029087066650391
(43) DESCRIBE `ports` 0.0014350414276123
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00028300285339355
(45) DESCRIBE `ports` 0.0014569759368896
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00034093856811523
(47) DESCRIBE `ports` 0.0014829635620117
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00033187866210938
(49) DESCRIBE `ports` 0.0015659332275391
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.0003049373626709
(51) DESCRIBE `ports` 0.0014159679412842
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00028109550476074
(53) DESCRIBE `ports` 0.0012531280517578
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00031113624572754
(55) DESCRIBE `ports` 0.0012340545654297
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00032711029052734
(57) DESCRIBE `cruiselines` 0.0018000602722168
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031399726867676
(59) DESCRIBE `orchid_image` 0.0013978481292725
(60) DESCRIBE `cruiselines` 0.0019149780273438
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00032997131347656
(62) DESCRIBE `cabins` 0.0015318393707275
(63) DESCRIBE `deckplans` 0.0016670227050781
(64) DESCRIBE `shipphotos` 0.001554012298584
(65) DESCRIBE `cruises` 0.0033938884735107
(66) SELECT `cruises`.* FROM `cruises` WHERE (id IN (21450, 29602, 32923, 33074, 33075, 33084, 33087, 33089, 33090, 33092)) ORDER BY FIND_IN_SET(id, '21450,29602,32923,33074,33075,33084,33087,33089,33090,33092') 0.00099897384643555
(67) DESCRIBE `cruiselines` 0.0025770664215088
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '183', '12', '144', '20', '23', '18', '7', '131', '8', '101', '96', '171', '103', '156', '31', '262', '15', '29', '191', '120', '91', '258', '33', '50', '28', '251', '14', '114', '49', '206', '212', '24', '37', '187', '16', '36', '47', '170', '110', '118', '181', '208', '195', '153', '151', '30', '88', '108', '141', '159', '140', '59', '73', '90', '216', '4', '35', '264', '147', '211', '113', '57', '180', '38', '64', '48', '213', '257', '261', '276', '115', '95', '184', '52', '105', '244', '82', '209', '134', '177', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,183,12,144,20,23,18,7,131,8,101,96,171,103,156,31,262,15,29,191,120,91,258,33,50,28,251,14,114,49,206,212,24,37,187,16,36,47,170,110,118,181,208,195,153,151,30,88,108,141,159,140,59,73,90,216,4,35,264,147,211,113,57,180,38,64,48,213,257,261,276,115,95,184,52,105,244,82,209,134,177,245') 0.010382890701294
(69) DESCRIBE `ships` 0.003087043762207
(70) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '977', '1588', '1744', '1555', '1594', '454', '1794', '517', '1237', '1272', '780', '974', '1359', '258', '1717', '1032', '1292', '22', '461', '797', '21', '330', '770', '393', '986', '28', '1677', '404', '407', '674', '1348', '1205', '1415', '716', '207', '1260', '1599', '11', '333', '739', '10', '439', '9', '349', '480', '1067', '715', '1135', '521', '882', '1607', '553', '766', '1008', '737', '1291', '24', '265', '1455', '817', '25', '1199', '792', '711', '1742', '3', '610', '352', '1768', '332', '63', '462', '1372', '66', '520', '1417', '113', '626', '1068', '657', '855', '14', '1738', '585', '1163', '1302', '748', '1413', '1526', '1411', '34', '38', '738', '1410', '1721', '31', '37', '526', '1323', '1579', '542', '837', '1320', '1773', '314', '378', '573', '1063', '970', '43', '327', '390', '854', '1402', '1569', '582', '590', '1259', '81', '452', '1454', '1682', '163', '958', '1013', '1088', '1586', '791', '212', '1284', '1319', '1193', '1208', '1157', '114', '1492', '1552', '401', '441', '1308', '39', '335', '580', '1266', '1587', '30', '36', '84', '405', '455', '850', '1012', '1245', '1678', '35', '351', '1326', '1327', '27', '406', '545', '547', '1461', '386', '1236', '1412', '1420', '1422', '340', '722', '385', '451', '658', '1040', '1398', '1418', '1421', '1424', '601', '1303', '1419', '1423', '162', '325', '1043', '1408', '148', '508', '683', '966', '1172', '1330', '1575', '1782', '1168', '1289', '287', '389', '434', '639', '1108', '1711', '1740', '78', '201', '160', '1021', '1743', '124', '394', '776', '852', '111', '119', '627', '775', '1019', '1344', '1715', '485', '559', '1037', '1159', '1217', '1325', '1716', '338', '1160', '1229', '1343', '1452', '1453', '1604', '751', '1426', '285', '673', '678', '1226', '1373', '45', '266', '1095', '1137', '1405', '105', '1358', '1448', '1704', '286', '403', '857', '858', '1136', '1150', '1501', '253', '818', '851', '69', '701', '768', '905', '968', '1141', '1283', '1801', '98', '291', '651', '1809', '151', '223', '574', '643', '1139', '1230', '1231', '1574', '1713', '324', '616', '1055', '1458', '1714', '82', '108', '150', '341', '348', '790', '954', '1474', '663', '709', '1360', '1361', '1368', '1459', '1609', '1632', '1672', '1708', '75', '467', '769', '884', '1049', '1206', '1362', '1724', '1751', '1808', '4', '375', '885', '1035', '1042', '1223', '1722', '1750', '1767', '149', '652', '1051', '1148', '1409', '944', '1322', '123', '1321', '70', '262', '290', '1301', '644', '665', '703', '784', '1020', '1483', '1771', '423', '1047', '1293', '1580', '116', '152', '483', '516', '1445', '1572', '1601', '1681', '147', '421', '422', '1054', '1486', '707', '1262', '1282', '1581', '93', '198', '1052', '1318', '1437', '1676', '1679', '1781', '796', '886', '1539', '1766', '1036', '1075', '717', '1045', '1060', '1064', '1143', '1673', '74', '420', '704', '1048', '1444', '1465', '1684', '973', '1073', '1151', '1389', '205', '419', '656', '883', '982', '1039', '1367', '1146', '1232', '1254', '1571', '503', '1050', '1350', '1540', '1195', '1749', '1791', '635', '795', '808', '1806', '479', '494', '687', '761', '1044', '1772', '1144', '1297', '1647', '1706', '1805', '1807', '493', '965', '1025', '1029', '1053', '1090', '1158', '1404', '1645', '1709', '1788', '733', '767', '972', '1027', '1316', '1342', '1624', '1674', '695', '1241', '1626', '1697', '1730', '240', '979', '988', '1028', '1113', '1155', '1156', '1295', '1340', '1341', '1471', '996', '1089', '1188', '1296', '299', '300', '888', '1024', '1233', '1351', '1451', '1710', '692', '997', '1026', '1142', '1145', '1196', '1339', '1640', '1757', '666', '685', '962', '1034', '1038', '1138', '1149', '1298', '1345', '1366', '1631', '1792')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,977,1588,1744,1555,1594,454,1794,517,1237,1272,780,974,1359,258,1717,1032,1292,22,461,797,21,330,770,393,986,28,1677,404,407,674,1348,1205,1415,716,207,1260,1599,11,333,739,10,439,9,349,480,1067,715,1135,521,882,1607,553,766,1008,737,1291,24,265,1455,817,25,1199,792,711,1742,3,610,352,1768,332,63,462,1372,66,520,1417,113,626,1068,657,855,14,1738,585,1163,1302,748,1413,1526,1411,34,38,738,1410,1721,31,37,526,1323,1579,542,837,1320,1773,314,378,573,1063,970,43,327,390,854,1402,1569,582,590,1259,81,452,1454,1682,163,958,1013,1088,1586,791,212,1284,1319,1193,1208,1157,114,1492,1552,401,441,1308,39,335,580,1266,1587,30,36,84,405,455,850,1012,1245,1678,35,351,1326,1327,27,406,545,547,1461,386,1236,1412,1420,1422,340,722,385,451,658,1040,1398,1418,1421,1424,601,1303,1419,1423,162,325,1043,1408,148,508,683,966,1172,1330,1575,1782,1168,1289,287,389,434,639,1108,1711,1740,78,201,160,1021,1743,124,394,776,852,111,119,627,775,1019,1344,1715,485,559,1037,1159,1217,1325,1716,338,1160,1229,1343,1452,1453,1604,751,1426,285,673,678,1226,1373,45,266,1095,1137,1405,105,1358,1448,1704,286,403,857,858,1136,1150,1501,253,818,851,69,701,768,905,968,1141,1283,1801,98,291,651,1809,151,223,574,643,1139,1230,1231,1574,1713,324,616,1055,1458,1714,82,108,150,341,348,790,954,1474,663,709,1360,1361,1368,1459,1609,1632,1672,1708,75,467,769,884,1049,1206,1362,1724,1751,1808,4,375,885,1035,1042,1223,1722,1750,1767,149,652,1051,1148,1409,944,1322,123,1321,70,262,290,1301,644,665,703,784,1020,1483,1771,423,1047,1293,1580,116,152,483,516,1445,1572,1601,1681,147,421,422,1054,1486,707,1262,1282,1581,93,198,1052,1318,1437,1676,1679,1781,796,886,1539,1766,1036,1075,717,1045,1060,1064,1143,1673,74,420,704,1048,1444,1465,1684,973,1073,1151,1389,205,419,656,883,982,1039,1367,1146,1232,1254,1571,503,1050,1350,1540,1195,1749,1791,635,795,808,1806,479,494,687,761,1044,1772,1144,1297,1647,1706,1805,1807,493,965,1025,1029,1053,1090,1158,1404,1645,1709,1788,733,767,972,1027,1316,1342,1624,1674,695,1241,1626,1697,1730,240,979,988,1028,1113,1155,1156,1295,1340,1341,1471,996,1089,1188,1296,299,300,888,1024,1233,1351,1451,1710,692,997,1026,1142,1145,1196,1339,1640,1757,666,685,962,1034,1038,1138,1149,1298,1345,1366,1631,1792') 0.04735803604126
(71) DESCRIBE `cruisetypes` 0.0016629695892334
(72) DESCRIBE `destinations` 0.0015840530395508
(73) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '9', '43', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '21', '40', '7', '48', '45', '29', '44', '30', '10', '34', '46', '52', '32', '56')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,9,43,2,37,8,39,53,26,28,38,49,55,11,21,40,7,48,45,29,44,30,10,34,46,52,32,56') 0.0021049976348877