Poesia, Denmark, Germany & Norway Cruise ex Copenhagen Return

Find Your Cruise

Clear DatesSailing Dates

From

Destination Cruise Line Cruise Ship Visiting Port

Show only special deals

or, enquire about your chosen options

Poesia, Denmark, Germany & Norway Cruise ex Copenhagen Return

Nights	7	Ship	MSC Poesia
Star Rating		Departs	Copenhagen, Denmark

Sailing	2020: 23 May, 6 Jun, 20 Jun, 4 Jul, 18 Jul, 1 Aug
Ports of Call	Copenhagen, Berlin (Warnemunde), Bergen, Molde, Hellesylt, Geiranger

Select a sailing date for approximate pricing.

Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

Poesia, Denmark, Germany & Norway Cruise ex Copenhagen Return

MSC Poesia

Poetry is like the sea, lulling with gentle swells and stirring the emotions. Just as poetry brings pleasure, the magnificent MSC Poesia cruise ship introduces a new dimension of enjoyment on the high seas.

The MSC Poesia, our third Musica class ship, offers the latest eco-technology to safeguard the environment, without compromising comfort and luxury. Our beautiful ship is built to the highest and most demanding ecological standards, resulting in a truly modern cruise ship. Onboard you will discover luxury cruising at its best - a spectacular waterfall with bridges in the foyer, a Zen garden in the sushi bar and a serene 12,000 square foot spa. Then imagine yourself on a private balcony stateroom overlooking the ocean and a star-filled sky.

Designed with the hallmark Italian flair and elegance that guests associate with the MSC Cruises, staterooms onboard MSC Poesia are spacious and elegant and most have private balconies. Staterooms are elegantly decorated and passengers will appreciate the attention to detail and craftsmanship throughout the whole ship. Guests can stimulate the palate in a wine-tasting bar or relax in the casual Mojito bar. Why not enjoy an open air cinema experience under the stars on an immense screen by the pool? Thinking of brining the kids along? MSC offers an affordable family vacation where kids cruise free! They will go crazy for the Stone Age dinosaur-themed play area and even teens are catered for in the Teen’s Club.

Whether a luxury escape, family vacation, a romantic break away or simply to rediscover your sense of self, the enchanting MSC Poesia offers an unparalleled cruise vacation that is sure to inspire.

Detailed information about MSC Poesia

Star Rating
Currency Used	N/A
Cruise Type	Contemporary
Maiden Voyage	2008
Tonnage	89,600
Length	293.8 metres
Beam	32.2 metres
Passenger Capacity	3013
Crew Nationality	International
Cuisine	International

#	Query	Time
(1)	connect	0.0010051727294922
(2)	DESCRIBE `cruises`	0.0044169425964355
(3)	SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'poesia-denmark-germany-norway-cruise-ex-copenhagen-return') AND (orchid_available = 1) LIMIT 1	0.057992935180664
(4)	DESCRIBE `avid_specials`	0.002446174621582
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 83916 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 25 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.002004861831665
(6)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '83916')	0.00049591064453125
(7)	DESCRIBE `ships`	0.0042150020599365
(8)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674)))	0.00067996978759766
(9)	DESCRIBE `ships`	0.0039031505584717
(10)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674')	0.00062704086303711
(11)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00047397613525391
(12)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00047707557678223
(13)	DESCRIBE `itineraries`	0.0022189617156982
(14)	DESCRIBE `ports`	0.0025298595428467
(15)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.0005650520324707
(16)	DESCRIBE `ports`	0.0020041465759277
(17)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00044894218444824
(18)	DESCRIBE `ports`	0.0019299983978271
(19)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00052380561828613
(20)	DESCRIBE `sailingdates`	0.0019669532775879
(21)	DESCRIBE `ports`	0.0021970272064209
(22)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00051093101501465
(23)	DESCRIBE `ports`	0.0019760131835938
(24)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00043201446533203
(25)	DESCRIBE `ports`	0.0018680095672607
(26)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561)))	0.00042009353637695
(27)	DESCRIBE `ports`	0.0019199848175049
(28)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561')	0.00056004524230957
(29)	DESCRIBE `ports`	0.0019729137420654
(30)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228)))	0.00042295455932617
(31)	DESCRIBE `ports`	0.0019931793212891
(32)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228')	0.0004279613494873
(33)	DESCRIBE `ports`	0.0025069713592529
(34)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523)))	0.00060701370239258
(35)	DESCRIBE `ports`	0.001884937286377
(36)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523')	0.00039482116699219
(37)	DESCRIBE `ports`	0.0017280578613281
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223)))	0.00044703483581543
(39)	DESCRIBE `ports`	0.0017631053924561
(40)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223')	0.00036787986755371
(41)	DESCRIBE `ports`	0.001802921295166
(42)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226)))	0.00050687789916992
(43)	DESCRIBE `ports`	0.0017421245574951
(44)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226')	0.00042104721069336
(45)	DESCRIBE `ports`	0.0017261505126953
(46)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00043487548828125
(47)	DESCRIBE `ports`	0.0018010139465332
(48)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00040078163146973
(49)	DESCRIBE `cruiselines`	0.0026679039001465
(50)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))	0.00043296813964844
(51)	DESCRIBE `orchid_image`	0.0030460357666016
(52)	DESCRIBE `cruiselines`	0.0039150714874268
(53)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')	0.0006108283996582
(54)	DESCRIBE `cabins`	0.0020828247070312
(55)	DESCRIBE `deckplans`	0.0018990039825439
(56)	DESCRIBE `shipphotos`	0.002377986907959
(57)	DESCRIBE `cruiselines`	0.0038959980010986
(58)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))	0.00067782402038574
(59)	DESCRIBE `orchid_image`	0.0028970241546631
(60)	DESCRIBE `cruiselines`	0.0035169124603271
(61)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')	0.00055718421936035
(62)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00049090385437012
(63)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00047397613525391
(64)	DESCRIBE `cruises`	0.0052390098571777
(65)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 29952, 34157, 38147, 38149, 40591, 40596, 45258, 45258, 45260)) ORDER BY FIND_IN_SET(id, '29613,29952,34157,38147,38149,40591,40596,45258,45258,45260')	0.0019409656524658
(66)	DESCRIBE `cruiselines`	0.0038940906524658
(67)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '49', '36', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '115', '261', '48', '213', '159', '264', '276', '209', '211', '108', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,49,36,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,115,261,48,213,159,264,276,209,211,108,113,90,57,82,184,95,38,180,52,244,105,35,64,134,257,245,172')	0.0073790550231934
(68)	DESCRIBE `ships`	0.0053248405456543
(69)	SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '1324', '855', '1588', '1717', '207', '1794', '1291', '871', '874', '977', '1594', '454', '1199', '1572', '1766', '404', '1359', '1272', '770', '22', '330', '461', '1032', '21', '393', '974', '66', '716', '1237', '28', '1292', '797', '1424', '434', '738', '1134', '1682', '553', '332', '521', '265', '1348', '333', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '585', '1422', '1418', '1420', '1421', '9', '715', '11', '792', '857', '858', '1501', '10', '1677', '163', '407', '439', '455', '739', '25', '1132', '1678', '34', '31', '36', '378', '674', '3', '24', '39', '657', '542', '1460', '520', '1008', '1721', '1205', '1141', '1607', '837', '1569', '385', '1067', '1742', '1302', '1852', '386', '966', '1402', '1773', '882', '1168', '1233', '1372', '113', '160', '1822', '35', '850', '1012', '1505', '1811', '338', '626', '768', '1454', '1455', '1574', '1676', '98', '1135', '1319', '1602', '573', '37', '1373', '63', '285', '451', '610', '1021', '30', '352', '986', '817', '1284', '1413', '1733', '547', '1259', '1282', '1398', '1411', '38', '1410', '1782', '111', '148', '314', '1193', '108', '375', '1088', '1722', '43', '286', '406', '503', '1437', '508', '627', '748', '1108', '198', '340', '526', '1063', '1308', '1320', '1323', '1579', '1711', '1808', '970', '1145', '883', '1325', '116', '124', '327', '485', '854', '1586', '348', '390', '582', '1149', '1738', '394', '590', '1571', '1028', '1208', '119', '1266', '1492', '335', '1068', '1575', '1724', '223', '944', '1412', '1552', '1672', '1810', '82', '616', '791', '1157', '1321', '1587', '75', '114', '652', '704', '1461', '1809', '70', '1801', '147', '351', '441', '462', '4', '480', '545', '658', '678', '1027', '1853', '683', '988', '1289', '78', '162', '201', '325', '601', '884', '69', '401', '403', '722', '1318', '1330', '1408', '1820', '105', '291', '405', '790', '958', '1245', '341', '1139', '1188', '1303', '1486', '149', '389', '776', '1236', '81', '123', '262', '287', '580', '818', '1073', '1772', '483', '651', '1326', '1327', '1539', '1704', '1771', '1037', '1159', '1367', '1526', '423', '673', '1013', '1043', '1151', '1540', '1757', '266', '796', '1019', '1040', '1172', '45', '290', '639', '968', '1463', '1474', '1573', '635', '1223', '1730', '1743', '84', '574', '751', '775', '795', '852', '1160', '1426', '1681', '1740', '1029', '1035', '1217', '1338', '1344', '1715', '1758', '324', '717', '1163', '1206', '1716', '709', '972', '1095', '1143', '1144', '1146', '1150', '1226', '1229', '1283', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '417', '643', '1483', '1807', '1833', '151', '665', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '212', '885', '1042', '1045', '1230', '1231', '1449', '1787', '467', '644', '1026', '1051', '1137', '1152', '1351', '1405', '1647', '1749', '1791', '769', '1109', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '150', '453', '663', '954', '1025', '1090', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '1816', '208', '448', '559', '701', '920', '973', '996', '1049', '1050', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1649', '1708', '1713', '1805', '666', '740', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1714', '1750', '1788', '1823', '707', '886', '915', '916', '926', '930', '931', '1071', '1294', '1580', '1854', '703', '924', '1047', '1052', '1389', '1596', '1650', '93', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '1599', '1664', '205', '253', '479', '784', '937', '487', '672', '888', '965', '1256', '1301', '1626', '1674', '1679', '14', '671', '821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,1324,855,1588,1717,207,1794,1291,871,874,977,1594,454,1199,1572,1766,404,1359,1272,770,22,330,461,1032,21,393,974,66,716,1237,28,1292,797,1424,434,738,1134,1682,553,332,521,265,1348,333,766,1768,349,711,1415,1260,1419,1423,585,1422,1418,1420,1421,9,715,11,792,857,858,1501,10,1677,163,407,439,455,739,25,1132,1678,34,31,36,378,674,3,24,39,657,542,1460,520,1008,1721,1205,1141,1607,837,1569,385,1067,1742,1302,1852,386,966,1402,1773,882,1168,1233,1372,113,160,1822,35,850,1012,1505,1811,338,626,768,1454,1455,1574,1676,98,1135,1319,1602,573,37,1373,63,285,451,610,1021,30,352,986,817,1284,1413,1733,547,1259,1282,1398,1411,38,1410,1782,111,148,314,1193,108,375,1088,1722,43,286,406,503,1437,508,627,748,1108,198,340,526,1063,1308,1320,1323,1579,1711,1808,970,1145,883,1325,116,124,327,485,854,1586,348,390,582,1149,1738,394,590,1571,1028,1208,119,1266,1492,335,1068,1575,1724,223,944,1412,1552,1672,1810,82,616,791,1157,1321,1587,75,114,652,704,1461,1809,70,1801,147,351,441,462,4,480,545,658,678,1027,1853,683,988,1289,78,162,201,325,601,884,69,401,403,722,1318,1330,1408,1820,105,291,405,790,958,1245,341,1139,1188,1303,1486,149,389,776,1236,81,123,262,287,580,818,1073,1772,483,651,1326,1327,1539,1704,1771,1037,1159,1367,1526,423,673,1013,1043,1151,1540,1757,266,796,1019,1040,1172,45,290,639,968,1463,1474,1573,635,1223,1730,1743,84,574,751,775,795,852,1160,1426,1681,1740,1029,1035,1217,1338,1344,1715,1758,324,717,1163,1206,1716,709,972,1095,1143,1144,1146,1150,1226,1229,1283,1343,1358,1409,1452,1453,1604,1663,417,643,1483,1807,1833,151,665,851,905,1048,1136,1262,1293,1448,1673,1746,212,885,1042,1045,1230,1231,1449,1787,467,644,1026,1051,1137,1152,1351,1405,1647,1749,1791,769,1109,1140,1154,1340,1458,1723,1759,1806,150,453,663,954,1025,1090,1224,1366,1368,1459,1609,1632,1751,1816,208,448,559,701,920,973,996,1049,1050,1148,1274,1329,1354,1360,1361,1362,1519,1601,1649,1708,1713,1805,666,740,914,921,923,927,1044,1055,1072,1196,1322,1339,1714,1750,1788,1823,707,886,915,916,926,930,931,1071,1294,1580,1854,703,924,1047,1052,1389,1596,1650,93,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,1599,1664,205,253,479,784,937,487,672,888,965,1256,1301,1626,1674,1679,14,671,821')	0.065027952194214
(70)	DESCRIBE `cruisetypes`	0.0023400783538818
(71)	DESCRIBE `destinations`	0.0031020641326904
(72)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,21,48,29,52,34,10,46,56,32')	0.0044260025024414

Query

Time

(1)

connect

0.0010051727294922

(2)

DESCRIBE `cruises`

0.0044169425964355

(3)

SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'poesia-denmark-germany-norway-cruise-ex-copenhagen-return') AND (orchid_available = 1) LIMIT 1

0.057992935180664

(4)

DESCRIBE `avid_specials`

0.002446174621582

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 83916 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 25 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.002004861831665

(6)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '83916')

0.00049591064453125

(7)

DESCRIBE `ships`

0.0042150020599365

(8)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674)))

0.00067996978759766

(9)

DESCRIBE `ships`

0.0039031505584717

(10)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674')

0.00062704086303711

(11)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00047397613525391

(12)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00047707557678223

(13)

DESCRIBE `itineraries`

0.0022189617156982

(14)

DESCRIBE `ports`

0.0025298595428467

(15)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))

0.0005650520324707

(16)

DESCRIBE `ports`

0.0020041465759277

(17)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))

0.00044894218444824

(18)

DESCRIBE `ports`

0.0019299983978271

(19)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')

0.00052380561828613

(20)

DESCRIBE `sailingdates`

0.0019669532775879

(21)

DESCRIBE `ports`

0.0021970272064209

(22)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))

0.00051093101501465

(23)

DESCRIBE `ports`

0.0019760131835938

(24)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')

0.00043201446533203

(25)

DESCRIBE `ports`

0.0018680095672607

(26)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561)))

0.00042009353637695

(27)

DESCRIBE `ports`

0.0019199848175049

(28)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561')

0.00056004524230957

(29)

DESCRIBE `ports`

0.0019729137420654

(30)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228)))

0.00042295455932617

(31)

DESCRIBE `ports`

0.0019931793212891

(32)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228')

0.0004279613494873

(33)

DESCRIBE `ports`

0.0025069713592529

(34)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523)))

0.00060701370239258

(35)

DESCRIBE `ports`

0.001884937286377

(36)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523')

0.00039482116699219

(37)

DESCRIBE `ports`

0.0017280578613281

(38)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223)))

0.00044703483581543

(39)

DESCRIBE `ports`

0.0017631053924561

(40)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223')

0.00036787986755371

(41)

DESCRIBE `ports`

0.001802921295166

(42)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226)))

0.00050687789916992

(43)

DESCRIBE `ports`

0.0017421245574951

(44)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226')

0.00042104721069336

(45)

DESCRIBE `ports`

0.0017261505126953

(46)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))

0.00043487548828125

(47)

DESCRIBE `ports`

0.0018010139465332

(48)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')

0.00040078163146973

(49)

DESCRIBE `cruiselines`

0.0026679039001465

(50)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))

0.00043296813964844

(51)

DESCRIBE `orchid_image`

0.0030460357666016

(52)

DESCRIBE `cruiselines`

0.0039150714874268

(53)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')

0.0006108283996582

(54)

DESCRIBE `cabins`

0.0020828247070312

(55)

DESCRIBE `deckplans`

0.0018990039825439

(56)

DESCRIBE `shipphotos`

0.002377986907959

(57)

DESCRIBE `cruiselines`

0.0038959980010986

(58)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))

0.00067782402038574

(59)

DESCRIBE `orchid_image`

0.0028970241546631

(60)

DESCRIBE `cruiselines`

0.0035169124603271

(61)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')

0.00055718421936035

(62)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00049090385437012

(63)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00047397613525391

(64)

DESCRIBE `cruises`

0.0052390098571777

(65)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 29952, 34157, 38147, 38149, 40591, 40596, 45258, 45258, 45260)) ORDER BY FIND_IN_SET(id, '29613,29952,34157,38147,38149,40591,40596,45258,45258,45260')

0.0019409656524658

(66)

DESCRIBE `cruiselines`

0.0038940906524658

(67)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '49', '36', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '115', '261', '48', '213', '159', '264', '276', '209', '211', '108', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,49,36,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,115,261,48,213,159,264,276,209,211,108,113,90,57,82,184,95,38,180,52,244,105,35,64,134,257,245,172')

0.0073790550231934

(68)

DESCRIBE `ships`

0.0053248405456543

(69)

SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '1324', '855', '1588', '1717', '207', '1794', '1291', '871', '874', '977', '1594', '454', '1199', '1572', '1766', '404', '1359', '1272', '770', '22', '330', '461', '1032', '21', '393', '974', '66', '716', '1237', '28', '1292', '797', '1424', '434', '738', '1134', '1682', '553', '332', '521', '265', '1348', '333', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '585', '1422', '1418', '1420', '1421', '9', '715', '11', '792', '857', '858', '1501', '10', '1677', '163', '407', '439', '455', '739', '25', '1132', '1678', '34', '31', '36', '378', '674', '3', '24', '39', '657', '542', '1460', '520', '1008', '1721', '1205', '1141', '1607', '837', '1569', '385', '1067', '1742', '1302', '1852', '386', '966', '1402', '1773', '882', '1168', '1233', '1372', '113', '160', '1822', '35', '850', '1012', '1505', '1811', '338', '626', '768', '1454', '1455', '1574', '1676', '98', '1135', '1319', '1602', '573', '37', '1373', '63', '285', '451', '610', '1021', '30', '352', '986', '817', '1284', '1413', '1733', '547', '1259', '1282', '1398', '1411', '38', '1410', '1782', '111', '148', '314', '1193', '108', '375', '1088', '1722', '43', '286', '406', '503', '1437', '508', '627', '748', '1108', '198', '340', '526', '1063', '1308', '1320', '1323', '1579', '1711', '1808', '970', '1145', '883', '1325', '116', '124', '327', '485', '854', '1586', '348', '390', '582', '1149', '1738', '394', '590', '1571', '1028', '1208', '119', '1266', '1492', '335', '1068', '1575', '1724', '223', '944', '1412', '1552', '1672', '1810', '82', '616', '791', '1157', '1321', '1587', '75', '114', '652', '704', '1461', '1809', '70', '1801', '147', '351', '441', '462', '4', '480', '545', '658', '678', '1027', '1853', '683', '988', '1289', '78', '162', '201', '325', '601', '884', '69', '401', '403', '722', '1318', '1330', '1408', '1820', '105', '291', '405', '790', '958', '1245', '341', '1139', '1188', '1303', '1486', '149', '389', '776', '1236', '81', '123', '262', '287', '580', '818', '1073', '1772', '483', '651', '1326', '1327', '1539', '1704', '1771', '1037', '1159', '1367', '1526', '423', '673', '1013', '1043', '1151', '1540', '1757', '266', '796', '1019', '1040', '1172', '45', '290', '639', '968', '1463', '1474', '1573', '635', '1223', '1730', '1743', '84', '574', '751', '775', '795', '852', '1160', '1426', '1681', '1740', '1029', '1035', '1217', '1338', '1344', '1715', '1758', '324', '717', '1163', '1206', '1716', '709', '972', '1095', '1143', '1144', '1146', '1150', '1226', '1229', '1283', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '417', '643', '1483', '1807', '1833', '151', '665', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '212', '885', '1042', '1045', '1230', '1231', '1449', '1787', '467', '644', '1026', '1051', '1137', '1152', '1351', '1405', '1647', '1749', '1791', '769', '1109', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '150', '453', '663', '954', '1025', '1090', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '1816', '208', '448', '559', '701', '920', '973', '996', '1049', '1050', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1649', '1708', '1713', '1805', '666', '740', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1714', '1750', '1788', '1823', '707', '886', '915', '916', '926', '930', '931', '1071', '1294', '1580', '1854', '703', '924', '1047', '1052', '1389', '1596', '1650', '93', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '1599', '1664', '205', '253', '479', '784', '937', '487', '672', '888', '965', '1256', '1301', '1626', '1674', '1679', '14', '671', '821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,1324,855,1588,1717,207,1794,1291,871,874,977,1594,454,1199,1572,1766,404,1359,1272,770,22,330,461,1032,21,393,974,66,716,1237,28,1292,797,1424,434,738,1134,1682,553,332,521,265,1348,333,766,1768,349,711,1415,1260,1419,1423,585,1422,1418,1420,1421,9,715,11,792,857,858,1501,10,1677,163,407,439,455,739,25,1132,1678,34,31,36,378,674,3,24,39,657,542,1460,520,1008,1721,1205,1141,1607,837,1569,385,1067,1742,1302,1852,386,966,1402,1773,882,1168,1233,1372,113,160,1822,35,850,1012,1505,1811,338,626,768,1454,1455,1574,1676,98,1135,1319,1602,573,37,1373,63,285,451,610,1021,30,352,986,817,1284,1413,1733,547,1259,1282,1398,1411,38,1410,1782,111,148,314,1193,108,375,1088,1722,43,286,406,503,1437,508,627,748,1108,198,340,526,1063,1308,1320,1323,1579,1711,1808,970,1145,883,1325,116,124,327,485,854,1586,348,390,582,1149,1738,394,590,1571,1028,1208,119,1266,1492,335,1068,1575,1724,223,944,1412,1552,1672,1810,82,616,791,1157,1321,1587,75,114,652,704,1461,1809,70,1801,147,351,441,462,4,480,545,658,678,1027,1853,683,988,1289,78,162,201,325,601,884,69,401,403,722,1318,1330,1408,1820,105,291,405,790,958,1245,341,1139,1188,1303,1486,149,389,776,1236,81,123,262,287,580,818,1073,1772,483,651,1326,1327,1539,1704,1771,1037,1159,1367,1526,423,673,1013,1043,1151,1540,1757,266,796,1019,1040,1172,45,290,639,968,1463,1474,1573,635,1223,1730,1743,84,574,751,775,795,852,1160,1426,1681,1740,1029,1035,1217,1338,1344,1715,1758,324,717,1163,1206,1716,709,972,1095,1143,1144,1146,1150,1226,1229,1283,1343,1358,1409,1452,1453,1604,1663,417,643,1483,1807,1833,151,665,851,905,1048,1136,1262,1293,1448,1673,1746,212,885,1042,1045,1230,1231,1449,1787,467,644,1026,1051,1137,1152,1351,1405,1647,1749,1791,769,1109,1140,1154,1340,1458,1723,1759,1806,150,453,663,954,1025,1090,1224,1366,1368,1459,1609,1632,1751,1816,208,448,559,701,920,973,996,1049,1050,1148,1274,1329,1354,1360,1361,1362,1519,1601,1649,1708,1713,1805,666,740,914,921,923,927,1044,1055,1072,1196,1322,1339,1714,1750,1788,1823,707,886,915,916,926,930,931,1071,1294,1580,1854,703,924,1047,1052,1389,1596,1650,93,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,1599,1664,205,253,479,784,937,487,672,888,965,1256,1301,1626,1674,1679,14,671,821')

0.065027952194214

(70)

DESCRIBE `cruisetypes`

0.0023400783538818

(71)

DESCRIBE `destinations`

0.0031020641326904

(72)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,21,48,29,52,34,10,46,56,32')

0.0044260025024414

Recently Viewed Cruises

Poesia, Denmark, Germany & Norway Cruise ex Copenhagen Return

MSC Poesia

Detailed information about MSC Poesia

Database Profiling Report