or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Your 'Cruise Ship' has been chosenClear this filter or visit another page to change

Viking Emerald

Viking River Cruises
Viking Emerald

Cruise the Yangtze River on Viking Emerald, a state-of-the-art river cruise vessel. Accommodating 256 guests with full verandas, hotel-style beds in every spacious suite and stateroom, public areas bathed in light and an English-speaking crew, Viking Emerald is one of the most sophisticated river ships sailing the region.

Enquire about this cruise ship »

Viking Emerald

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

Total elapsed time: 0.065095663070679

# Query Time
(1) connect 0.00057601928710938
(2) DESCRIBE `ships` 0.0017650127410889
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'viking-emerald') LIMIT 1 0.001349925994873
(4) DESCRIBE `avid_specials` 0.00087404251098633
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 883 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011789798736572
(6) DESCRIBE `cruiselines` 0.0010042190551758
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031208992004395
(8) DESCRIBE `orchid_image` 0.00077390670776367
(9) DESCRIBE `cruiselines` 0.000946044921875
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00030803680419922
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '883') 0.00023984909057617
(12) DESCRIBE `deckplans` 0.00089216232299805
(13) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '883') ORDER BY `level` ASC 0.0015289783477783
(14) DESCRIBE `cabins` 0.00055122375488281
(15) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '883') ORDER BY `cabin_order` ASC 0.011427879333496
(16) DESCRIBE `shipphotos` 0.0007321834564209
(17) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '883') 0.00086593627929688
(18) DESCRIBE `cruises` 0.0017459392547607
(19) SELECT `cruises`.* FROM `cruises` WHERE (id IN (44827, 61464, 44826, 61463, 61459, 61460, 62005, 61461, 61462)) ORDER BY FIND_IN_SET(id, '44827,61464,44826,61463,61459,61460,62005,61461,61462') 0.001093864440918
(20) DESCRIBE `cruiselines` 0.0011801719665527
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77')) ORDER BY FIND_IN_SET(id, '77') 0.00034999847412109
(22) DESCRIBE `cruisetypes` 0.0005791187286377
(23) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.ship_id = '883') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.030172109603882
(24) DESCRIBE `destinations` 0.001201868057251
(25) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54')) ORDER BY FIND_IN_SET(id, '54') 0.00052309036254883
(26) DESCRIBE `ships` 0.0015370845794678
(27) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 883))) 0.00027108192443848
(28) DESCRIBE `ships` 0.00087904930114746
(29) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 883))) 0.00023579597473145