Scandinavia & Russia - Free Drinks Package

Receive a FREE Easy Drinks Package*

Meraviglia, Northern Europe Cruise ex Copenhagen Return

Nights	7	Ship	MSC Meraviglia
Star Rating		Departs	Copenhagen, Denmark

Sailing	2020: 3 May
Ports of Call	Copenhagen, Helsinki, St Petersburg, Tallinn, Kiel

Special Pricing SpecialsPrice (Cabins)

Sailing Dates

Select a cabin to get pricing. Pricing is approximate.

NZ $2,339

NZ $1,849

NZ $1,519

NZ $1,349

Meraviglia, Northern Europe Cruise ex Copenhagen Return

MSC Meraviglia

Valid: 1 Oct 2019 - 31 Jan 2020

- 7 night cruise on board MSC Meraviglia
- All main meals & entertainment onboard
- Port charges & taxes

BONUS:
- FREE Easy Drinks Package*

Special Conditions

*Valid for sales until 31 Jan 2020, unless sold out prior. Offer subject to availability at time of booking. Prices are per person, twin share based on best available cruise fare, inclusive of port charges & taxes. Prices are based on Bella staterooms. Daily gratuities are not included and should be paid onboard at the conclusion of your cruise before disembarkation. Airfares are additional. Prices shown here are not shown in real time. While we endeavour to keep our pricing as up-to-date as possible, the advertised prices shown here may differ from the live prices in our booking system. Easy Drinks Package includes unlimited drinks priced up to EUR/USD6 for the first 2 pax in cabin, additional passengers in cabin must purchase easy drinks package. Includes house wines by the glass, draught beer, selected spirits & cocktails, non-alcoholic cocktails, soft drinks & fruit juices by the glass, bottled mineral water, espresso, cappuccino, caffe latte, hot tea, coffee & chocolate delights. Available in all onboard bars, self-service buffet & restaurants, excluding speciality restaurants. A $350pp non-refundable deposit is due within 3 days of reservation. Final payment is due 90 days prior to departure. Offers are subject to availability, to change or be withdrawn without notice. Further conditions apply, please ask for full details at time of enquiry.

#	Query	Time
(1)	connect	0.0009918212890625
(2)	DESCRIBE `specials`	0.0061759948730469
(3)	SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'scandinavia-russia-free-drinks-package') AND (orchid_available = 1) LIMIT 1	0.0016279220581055
(4)	DESCRIBE `cruises`	0.0037581920623779
(5)	SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76894)))	0.00062894821166992
(6)	DESCRIBE `avid_specials`	0.0016839504241943
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1634764 and class = 'Special') OR (item_id = 76894 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 26 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.0011739730834961
(8)	SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1634764')	0.00037693977355957
(9)	DESCRIBE `ships`	0.0038919448852539
(10)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359)))	0.00049901008605957
(11)	DESCRIBE `ships`	0.0040550231933594
(12)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359')	0.00058603286743164
(13)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00036096572875977
(14)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00034189224243164
(15)	DESCRIBE `itineraries`	0.0019171237945557
(16)	DESCRIBE `ports`	0.0018279552459717
(17)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00049304962158203
(18)	DESCRIBE `ports`	0.0021629333496094
(19)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00044798851013184
(20)	DESCRIBE `ports`	0.0017399787902832
(21)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00043392181396484
(22)	DESCRIBE `specialsailingdates`	0.001439094543457
(23)	DESCRIBE `sailingdates`	0.0020790100097656
(24)	SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 521223)))	0.0006401538848877
(25)	DESCRIBE `ports`	0.00187087059021
(26)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00045204162597656
(27)	DESCRIBE `ports`	0.0017712116241455
(28)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00041103363037109
(29)	DESCRIBE `ports`	0.0018081665039062
(30)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235)))	0.00041317939758301
(31)	DESCRIBE `ports`	0.0019340515136719
(32)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235')	0.00038981437683105
(33)	DESCRIBE `ports`	0.0017549991607666
(34)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233)))	0.00047707557678223
(35)	DESCRIBE `ports`	0.0018198490142822
(36)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233')	0.00046801567077637
(37)	DESCRIBE `ports`	0.0022919178009033
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236)))	0.00054693222045898
(39)	DESCRIBE `ports`	0.0019149780273438
(40)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236')	0.00040197372436523
(41)	DESCRIBE `ports`	0.0019979476928711
(42)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869)))	0.00059700012207031
(43)	DESCRIBE `ports`	0.0020620822906494
(44)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '869')	0.00052905082702637
(45)	DESCRIBE `ports`	0.0017669200897217
(46)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238)))	0.00043201446533203
(47)	DESCRIBE `ports`	0.0017859935760498
(48)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238')	0.00046801567077637
(49)	DESCRIBE `specialsmultipricing`	0.0017879009246826
(50)	DESCRIBE `leadpricing`	0.0020809173583984
(51)	DESCRIBE `specialspricing`	0.0019378662109375
(52)	DESCRIBE `cabins`	0.0019640922546387
(53)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11804)))	0.0005638599395752
(54)	DESCRIBE `cabins`	0.0018501281738281
(55)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11802)))	0.00043797492980957
(56)	DESCRIBE `cabins`	0.0020360946655273
(57)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11800)))	0.00044107437133789
(58)	DESCRIBE `cabins`	0.0018348693847656
(59)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11799)))	0.0004878044128418
(60)	DESCRIBE `currencies`	0.0017120838165283
(61)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.0003659725189209
(62)	DESCRIBE `currencies`	0.0015089511871338
(63)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00042819976806641
(64)	DESCRIBE `currencies`	0.001561164855957
(65)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00037908554077148
(66)	DESCRIBE `currencies`	0.0016119480133057
(67)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00036096572875977
(68)	DESCRIBE `cruiselines`	0.0025959014892578
(69)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))	0.00041413307189941
(70)	DESCRIBE `orchid_image`	0.0019950866699219
(71)	DESCRIBE `cruiselines`	0.0037479400634766
(72)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')	0.00062417984008789
(73)	DESCRIBE `cruises`	0.0050969123840332
(74)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76894')	0.00059914588928223
(75)	DESCRIBE `deckplans`	0.0018961429595947
(76)	DESCRIBE `cabins`	0.0018270015716553
(77)	DESCRIBE `shipphotos`	0.0017199516296387
(78)	DESCRIBE `cruiselines`	0.0025749206542969
(79)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19)))	0.00061202049255371
(80)	DESCRIBE `orchid_image`	0.0020439624786377
(81)	DESCRIBE `cruiselines`	0.0024840831756592
(82)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19')	0.00049686431884766
(83)	DESCRIBE `cruises`	0.0057640075683594
(84)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')	0.0014128684997559
(85)	DESCRIBE `cruiselines`	0.0027270317077637
(86)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')	0.0020098686218262
(87)	DESCRIBE `ships`	0.0037219524383545
(88)	SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')	0.012021064758301
(89)	DESCRIBE `cruisetypes`	0.0022668838500977
(90)	DESCRIBE `destinations`	0.0023229122161865
(91)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')	0.001863956451416

Query

Time

(1)

connect

0.0009918212890625

(2)

DESCRIBE `specials`

0.0061759948730469

(3)

SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'scandinavia-russia-free-drinks-package') AND (orchid_available = 1) LIMIT 1

0.0016279220581055

(4)

DESCRIBE `cruises`

0.0037581920623779

(5)

SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76894)))

0.00062894821166992

(6)

DESCRIBE `avid_specials`

0.0016839504241943

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1634764 and class = 'Special') OR (item_id = 76894 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 26 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.0011739730834961

(8)

SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1634764')

0.00037693977355957

(9)

DESCRIBE `ships`

0.0038919448852539

(10)

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

0.00049901008605957

(11)

DESCRIBE `ships`

0.0040550231933594

(12)

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

0.00058603286743164

(13)

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

0.00036096572875977

(14)

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

0.00034189224243164

(15)

DESCRIBE `itineraries`

0.0019171237945557

(16)

DESCRIBE `ports`

0.0018279552459717

(17)

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

0.00049304962158203

(18)

DESCRIBE `ports`

0.0021629333496094

(19)

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

0.00044798851013184

(20)

DESCRIBE `ports`

0.0017399787902832

(21)

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

0.00043392181396484

(22)

DESCRIBE `specialsailingdates`

0.001439094543457

(23)

DESCRIBE `sailingdates`

0.0020790100097656

(24)

SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 521223)))

0.0006401538848877

(25)

DESCRIBE `ports`

0.00187087059021

(26)

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

0.00045204162597656

(27)

DESCRIBE `ports`

0.0017712116241455

(28)

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

0.00041103363037109

(29)

DESCRIBE `ports`

0.0018081665039062

(30)

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

0.00041317939758301

(31)

DESCRIBE `ports`

0.0019340515136719

(32)

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

0.00038981437683105

(33)

DESCRIBE `ports`

0.0017549991607666

(34)

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

0.00047707557678223

(35)

DESCRIBE `ports`

0.0018198490142822

(36)

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

0.00046801567077637

(37)

DESCRIBE `ports`

0.0022919178009033

(38)

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

0.00054693222045898

(39)

DESCRIBE `ports`

0.0019149780273438

(40)

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

0.00040197372436523

(41)

DESCRIBE `ports`

0.0019979476928711

(42)

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

0.00059700012207031

(43)

DESCRIBE `ports`

0.0020620822906494

(44)

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

0.00052905082702637

(45)

DESCRIBE `ports`

0.0017669200897217

(46)

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

0.00043201446533203

(47)

DESCRIBE `ports`

0.0017859935760498

(48)

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

0.00046801567077637

(49)

DESCRIBE `specialsmultipricing`

0.0017879009246826

(50)

DESCRIBE `leadpricing`

0.0020809173583984

(51)

DESCRIBE `specialspricing`

0.0019378662109375

(52)

DESCRIBE `cabins`

0.0019640922546387

(53)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11804)))

0.0005638599395752

(54)

DESCRIBE `cabins`

0.0018501281738281

(55)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11802)))

0.00043797492980957

(56)

DESCRIBE `cabins`

0.0020360946655273

(57)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11800)))

0.00044107437133789

(58)

DESCRIBE `cabins`

0.0018348693847656

(59)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11799)))

0.0004878044128418

(60)

DESCRIBE `currencies`

0.0017120838165283

(61)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.0003659725189209

(62)

DESCRIBE `currencies`

0.0015089511871338

(63)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00042819976806641

(64)

DESCRIBE `currencies`

0.001561164855957

(65)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00037908554077148

(66)

DESCRIBE `currencies`

0.0016119480133057

(67)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00036096572875977

(68)

DESCRIBE `cruiselines`

0.0025959014892578

(69)

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

0.00041413307189941

(70)

DESCRIBE `orchid_image`

0.0019950866699219

(71)

DESCRIBE `cruiselines`

0.0037479400634766

(72)

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

0.00062417984008789

(73)

DESCRIBE `cruises`

0.0050969123840332

(74)

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

0.00059914588928223

(75)

DESCRIBE `deckplans`

0.0018961429595947

(76)

DESCRIBE `cabins`

0.0018270015716553

(77)

DESCRIBE `shipphotos`

0.0017199516296387

(78)

DESCRIBE `cruiselines`

0.0025749206542969

(79)

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

0.00061202049255371

(80)

DESCRIBE `orchid_image`

0.0020439624786377

(81)

DESCRIBE `cruiselines`

0.0024840831756592

(82)

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

0.00049686431884766

(83)

DESCRIBE `cruises`

0.0057640075683594

(84)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')

0.0014128684997559

(85)

DESCRIBE `cruiselines`

0.0027270317077637

(86)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')

0.0020098686218262

(87)

DESCRIBE `ships`

0.0037219524383545

(88)

SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')

0.012021064758301

(89)

DESCRIBE `cruisetypes`

0.0022668838500977

(90)

DESCRIBE `destinations`

0.0023229122161865

(91)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')

0.001863956451416

My Favourite Cruises