or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

 
  • Katha Pandaw, Pagan Mandalay Short Cruise Downstream ex Mandalay to Pagan

    Nights 2 Ship Katha Pandaw
    Star Rating River Departs Mandalay, Myanmar
    Sailing 2018: 23 Nov, 27 Nov, 1 Dec, 5 Dec, 9 Dec, 13 Dec, 17 Dec, 21 Dec, 25 Dec, 29 Dec 2019: 2 Jan, 6 Jan, 10 Jan, 14 Jan, 18 Jan, 22 Jan, 26 Jan, 30 Jan, 3 Feb, 7 Feb, 11 Feb, 15 Feb, 19 Feb, 23 Feb, 27 Feb, 3 Mar, 7 Mar, 11 Mar, 15 Mar
    Ports of Call Mandalay, Yandabo, Pagan
    Please enquire about this cruise for pricing.
  • Ginger, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 Ship Ginger
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

    Nights 1 Ship Bhaya Classic Ships
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • VSpirit Classic, Halong Bay 1 Night ex Halong Bay Return

    Nights 1 Ship VSpirit Classic
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Jasmine, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Jasmine
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay

    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.

  • Violet, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Violet
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Ginger, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Ginger
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Ginger, Hidden Worlds ex Lan Ha Bay Return

    Nights 1 Ship Ginger
    Star Rating Specialty Departs Lan Ha Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Lan Ha Bay
    Please enquire about this cruise for pricing.
  • Jasmine, Hidden Worlds ex Lan Ha Bay Return

    Nights 1 Ship Jasmine
    Star Rating Specialty Departs Lan Ha Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Lan Ha Bay
    Please enquire about this cruise for pricing.
  • Violet, Hidden Worlds ex Lan Ha Bay Return

    Nights 1 Ship Violet
    Star Rating Specialty Departs Lan Ha Bay, Vietnam
    Sailing 2018: 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec More 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Lan Ha Bay
    Please enquire about this cruise for pricing.
 

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

Total elapsed time: 0.72114276885986

# Query Time
(1) connect 0.0014691352844238
(2) DESCRIBE `cruises` 0.0043349266052246
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66098, 80325, 44275, 49177, 65920, 71154, 80326, 80327, 80328, 80329)) ORDER BY FIND_IN_SET(id, '66098,80325,44275,49177,65920,71154,80326,80327,80328,80329') 0.0026798248291016
(4) DESCRIBE `cruises` 0.0039029121398926
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66098') 0.00055098533630371
(6) DESCRIBE `ships` 0.0040290355682373
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 993))) 0.00058984756469727
(8) DESCRIBE `ships` 0.0045959949493408
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '993') 0.00049400329589844
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031113624572754
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.0016739368438721
(13) DESCRIBE `ports` 0.0020570755004883
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0010340213775635
(15) DESCRIBE `ports` 0.0020380020141602
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00082111358642578
(17) DESCRIBE `ports` 0.0024290084838867
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00062990188598633
(19) DESCRIBE `sailingdates` 0.0016179084777832
(20) DESCRIBE `ports` 0.0021538734436035
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00056600570678711
(22) DESCRIBE `ports` 0.0018391609191895
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00039911270141602
(24) DESCRIBE `ports` 0.0014510154724121
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00035810470581055
(26) DESCRIBE `ports` 0.0014290809631348
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00034189224243164
(28) DESCRIBE `ports` 0.0023298263549805
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00046801567077637
(30) DESCRIBE `ports` 0.0020408630371094
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00045514106750488
(32) DESCRIBE `avid_specials` 0.0016980171203613
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66098 and class = 'Cruise') OR (item_id = 993 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0019440650939941
(34) DESCRIBE `cruiselines` 0.0026748180389404
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00054812431335449
(36) DESCRIBE `orchid_image` 0.0025389194488525
(37) DESCRIBE `cruiselines` 0.003079891204834
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00014996528625488
(39) DESCRIBE `cruises` 0.0039680004119873
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80325') 0.00055599212646484
(41) DESCRIBE `ships` 0.0038468837738037
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.0005028247833252
(43) DESCRIBE `ships` 0.0038390159606934
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00039100646972656
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034594535827637
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(47) DESCRIBE `itineraries` 0.0032861232757568
(48) DESCRIBE `ports` 0.0024938583374023
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043916702270508
(50) DESCRIBE `ports` 0.0018501281738281
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045299530029297
(52) DESCRIBE `ports` 0.0015890598297119
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00049710273742676
(54) DESCRIBE `sailingdates` 0.0018107891082764
(55) DESCRIBE `ports` 0.0025038719177246
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049400329589844
(57) DESCRIBE `ports` 0.0020751953125
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00045680999755859
(59) DESCRIBE `ports` 0.0020351409912109
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042891502380371
(61) DESCRIBE `ports` 0.001615047454834
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00061416625976562
(63) DESCRIBE `ports` 0.0018868446350098
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043511390686035
(65) DESCRIBE `ports` 0.0021209716796875
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040197372436523
(67) DESCRIBE `avid_specials` 0.0018031597137451
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80325 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.002147912979126
(69) DESCRIBE `cruiselines` 0.002863883972168
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0012350082397461
(71) DESCRIBE `orchid_image` 0.0024259090423584
(72) DESCRIBE `cruiselines` 0.0025041103363037
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00049591064453125
(74) DESCRIBE `cruises` 0.0039839744567871
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44275') 0.00057411193847656
(76) DESCRIBE `ships` 0.003903865814209
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00060892105102539
(78) DESCRIBE `ships` 0.01071310043335
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.0077710151672363
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036907196044922
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(82) DESCRIBE `itineraries` 0.010717868804932
(83) DESCRIBE `ports` 0.0021510124206543
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0059919357299805
(85) DESCRIBE `ports` 0.0021610260009766
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00058889389038086
(87) DESCRIBE `ports` 0.0020439624786377
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004429817199707
(89) DESCRIBE `sailingdates` 0.001741886138916
(90) DESCRIBE `ports` 0.0033760070800781
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00050878524780273
(92) DESCRIBE `ports` 0.0020568370819092
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00049495697021484
(94) DESCRIBE `ports` 0.0019888877868652
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049400329589844
(96) DESCRIBE `ports` 0.0019171237945557
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00069308280944824
(98) DESCRIBE `avid_specials` 0.0073750019073486
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44275 and class = 'Cruise') OR (item_id = 1127 AND class = 'Ship') OR (item_id = 221 AND class = 'CruiseLine') OR (item_id = 35 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.0020689964294434
(100) DESCRIBE `cruiselines` 0.0030479431152344
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00066995620727539
(102) DESCRIBE `orchid_image` 0.002194881439209
(103) DESCRIBE `cruiselines` 0.011373996734619
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00051617622375488
(105) DESCRIBE `cruises` 0.0036818981170654
(106) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49177') 0.00046801567077637
(107) DESCRIBE `ships` 0.003849983215332
(108) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.0080599784851074
(109) DESCRIBE `ships` 0.0039510726928711
(110) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.0005800724029541
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034618377685547
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041604042053223
(113) DESCRIBE `itineraries` 0.0042510032653809
(114) DESCRIBE `ports` 0.0063261985778809
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039911270141602
(116) DESCRIBE `ports` 0.0016140937805176
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039100646972656
(118) DESCRIBE `ports` 0.0041048526763916
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00051593780517578
(120) DESCRIBE `sailingdates` 0.0016839504241943
(121) DESCRIBE `ports` 0.0024309158325195
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00051116943359375
(123) DESCRIBE `ports` 0.0019469261169434
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00044798851013184
(125) DESCRIBE `ports` 0.0018718242645264
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049018859863281
(127) DESCRIBE `ports` 0.0018830299377441
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0079760551452637
(129) DESCRIBE `avid_specials` 0.0020380020141602
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49177 and class = 'Cruise') OR (item_id = 1247 AND class = 'Ship') OR (item_id = 232 AND class = 'CruiseLine') OR (item_id = 35 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.0019850730895996
(131) DESCRIBE `cruiselines` 0.0029110908508301
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00058603286743164
(133) DESCRIBE `orchid_image` 0.002251148223877
(134) DESCRIBE `cruiselines` 0.0029120445251465
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.0086619853973389
(136) DESCRIBE `cruises` 0.0036780834197998
(137) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00055599212646484
(138) DESCRIBE `ships` 0.0082650184631348
(139) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00068092346191406
(140) DESCRIBE `ships` 0.011133909225464
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.0005650520324707
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035500526428223
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003349781036377
(144) DESCRIBE `itineraries` 0.0019800662994385
(145) DESCRIBE `ports` 0.0018901824951172
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0022180080413818
(147) DESCRIBE `ports` 0.0020759105682373
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0085198879241943
(149) DESCRIBE `ports` 0.0018970966339111
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042891502380371
(151) DESCRIBE `sailingdates` 0.0017039775848389
(152) DESCRIBE `ports` 0.0088191032409668
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00057101249694824
(154) DESCRIBE `ports` 0.0019948482513428
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0018620491027832
(156) DESCRIBE `ports` 0.0018990039825439
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0043239593505859
(158) DESCRIBE `ports` 0.0020370483398438
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042200088500977
(160) DESCRIBE `avid_specials` 0.0073990821838379
(161) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65920 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.0019998550415039
(162) DESCRIBE `cruiselines` 0.0028769969940186
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.005511999130249
(164) DESCRIBE `orchid_image` 0.0019440650939941
(165) DESCRIBE `cruiselines` 0.0024521350860596
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00040602684020996
(167) DESCRIBE `cruises` 0.020037889480591
(168) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.0010049343109131
(169) DESCRIBE `ships` 0.0035569667816162
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00027704238891602
(171) DESCRIBE `ships` 0.0035130977630615
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00050091743469238
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003359317779541
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038504600524902
(175) DESCRIBE `itineraries` 0.0017461776733398
(176) DESCRIBE `ports` 0.001957893371582
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047206878662109
(178) DESCRIBE `ports` 0.0017621517181396
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039005279541016
(180) DESCRIBE `ports` 0.0016539096832275
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040102005004883
(182) DESCRIBE `sailingdates` 0.0015039443969727
(183) DESCRIBE `ports` 0.002418041229248
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00060296058654785
(185) DESCRIBE `ports` 0.0015971660614014
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043582916259766
(187) DESCRIBE `ports` 0.0018818378448486
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038313865661621
(189) DESCRIBE `ports` 0.0017518997192383
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043702125549316
(191) DESCRIBE `avid_specials` 0.0017390251159668
(192) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.001708984375
(193) DESCRIBE `cruiselines` 0.0027730464935303
(194) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00050806999206543
(195) DESCRIBE `orchid_image` 0.0018229484558105
(196) DESCRIBE `cruiselines` 0.0025649070739746
(197) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00038480758666992
(198) DESCRIBE `cruises` 0.0035579204559326
(199) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80326') 0.00053310394287109
(200) DESCRIBE `ships` 0.0038259029388428
(201) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00066709518432617
(202) DESCRIBE `ships` 0.0038130283355713
(203) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00074005126953125
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00029492378234863
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036406517028809
(206) DESCRIBE `itineraries` 0.0019721984863281
(207) DESCRIBE `ports` 0.002410888671875
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0005190372467041
(209) DESCRIBE `ports` 0.00193190574646
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00054097175598145
(211) DESCRIBE `ports` 0.0023109912872314
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040578842163086
(213) DESCRIBE `sailingdates` 0.002086877822876
(214) DESCRIBE `ports` 0.0021698474884033
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00082302093505859
(216) DESCRIBE `ports` 0.0036280155181885
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0018129348754883
(218) DESCRIBE `ports` 0.002140998840332
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046896934509277
(220) DESCRIBE `ports` 0.0020408630371094
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042915344238281
(222) DESCRIBE `avid_specials` 0.0015239715576172
(223) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80326 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.0018990039825439
(224) DESCRIBE `cruiselines` 0.0024118423461914
(225) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00047206878662109
(226) DESCRIBE `orchid_image` 0.0018281936645508
(227) DESCRIBE `cruiselines` 0.0023291110992432
(228) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00042104721069336
(229) DESCRIBE `cruises` 0.0038919448852539
(230) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80327') 0.0004889965057373
(231) DESCRIBE `ships` 0.0036711692810059
(232) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00060915946960449
(233) DESCRIBE `ships` 0.0038421154022217
(234) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00042486190795898
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002601146697998
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026297569274902
(237) DESCRIBE `itineraries` 0.0018260478973389
(238) DESCRIBE `ports` 0.0016899108886719
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 7.7009201049805E-5
(240) DESCRIBE `ports` 0.0019180774688721
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00057411193847656
(242) DESCRIBE `ports` 0.0018539428710938
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00043797492980957
(244) DESCRIBE `sailingdates` 0.0016598701477051
(245) DESCRIBE `ports` 0.0021438598632812
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.0004730224609375
(247) DESCRIBE `ports` 0.0017340183258057
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00030899047851562
(249) DESCRIBE `ports` 0.0014400482177734
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00034999847412109
(251) DESCRIBE `ports` 0.0012919902801514
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00027704238891602
(253) DESCRIBE `avid_specials` 0.0011630058288574
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80327 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.0011429786682129
(255) DESCRIBE `cruiselines` 0.0020468235015869
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00039482116699219
(257) DESCRIBE `orchid_image` 0.0016820430755615
(258) DESCRIBE `cruiselines` 0.0021688938140869
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00040292739868164
(260) DESCRIBE `cruises` 0.0037288665771484
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80328') 0.0004429817199707
(262) DESCRIBE `ships` 0.0036160945892334
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00057005882263184
(264) DESCRIBE `ships` 0.0034191608428955
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.0003969669342041
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026202201843262
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026106834411621
(268) DESCRIBE `itineraries` 0.0012919902801514
(269) DESCRIBE `ports` 0.0024571418762207
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00047206878662109
(271) DESCRIBE `ports` 0.0019309520721436
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00046515464782715
(273) DESCRIBE `ports` 0.0018339157104492
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00038599967956543
(275) DESCRIBE `sailingdates` 0.0015418529510498
(276) DESCRIBE `ports` 0.0018470287322998
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00044488906860352
(278) DESCRIBE `ports` 0.0018360614776611
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00050687789916992
(280) DESCRIBE `ports` 0.0019741058349609
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00047206878662109
(282) DESCRIBE `ports` 0.0019669532775879
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00040602684020996
(284) DESCRIBE `avid_specials` 0.0017099380493164
(285) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80328 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.002316951751709
(286) DESCRIBE `cruiselines` 0.00282883644104
(287) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00058102607727051
(288) DESCRIBE `orchid_image` 0.0033161640167236
(289) DESCRIBE `cruiselines` 0.0029439926147461
(290) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00093412399291992
(291) DESCRIBE `cruises` 0.0040650367736816
(292) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80329') 0.00056004524230957
(293) DESCRIBE `ships` 0.0045208930969238
(294) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00056600570678711
(295) DESCRIBE `ships` 0.004256010055542
(296) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.0005180835723877
(297) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 6.6995620727539E-5
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028705596923828
(299) DESCRIBE `itineraries` 0.002208948135376
(300) DESCRIBE `ports` 0.0021510124206543
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00052404403686523
(302) DESCRIBE `ports` 0.001971960067749
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00048685073852539
(304) DESCRIBE `ports` 0.0019698143005371
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00047397613525391
(306) DESCRIBE `sailingdates` 0.0014760494232178
(307) DESCRIBE `ports` 0.0026099681854248
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00050592422485352
(309) DESCRIBE `ports` 0.0018248558044434
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00037693977355957
(311) DESCRIBE `ports` 0.001737117767334
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00046491622924805
(313) DESCRIBE `ports` 0.0020408630371094
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00048208236694336
(315) DESCRIBE `avid_specials` 0.0019669532775879
(316) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80329 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.0019359588623047
(317) DESCRIBE `cruiselines` 0.0028698444366455
(318) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0005190372467041
(319) DESCRIBE `orchid_image` 0.0020270347595215
(320) DESCRIBE `cruiselines` 0.0028347969055176
(321) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00047898292541504
(322) DESCRIBE `cruiselines` 0.0034730434417725
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '23', '7', '12', '20', '171', '18', '144', '8', '101', '31', '131', '50', '96', '239', '29', '103', '15', '191', '91', '206', '120', '37', '16', '114', '33', '262', '24', '268', '28', '14', '174', '221', '110', '156', '208', '187', '141', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '184', '249', '232', '159', '90', '230', '113', '182', '213', '136', '276', '47', '188', '237', '261', '57', '64', '180', '73', '248', '35', '95', '209', '52', '231', '146', '195', '116', '219', '59', '82', '119', '256', '196', '105', '134', '244', '115', '168', '170', '229', '240', '204', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,23,7,12,20,171,18,144,8,101,31,131,50,96,239,29,103,15,191,91,206,120,37,16,114,33,262,24,268,28,14,174,221,110,156,208,187,141,153,118,49,151,211,30,258,216,181,88,4,212,36,264,225,238,140,184,249,232,159,90,230,113,182,213,136,276,47,188,237,261,57,64,180,73,248,35,95,209,52,231,146,195,116,219,59,82,119,256,196,105,134,244,115,168,170,229,240,204,48,224') 0.01176905632019
(324) DESCRIBE `ships` 0.0040650367736816
(325) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '977', '1291', '258', '1199', '1359', '1599', '349', '454', '1135', '1272', '404', '780', '855', '1677', '986', '1067', '1237', '265', '1594', '837', '1607', '37', '38', '34', '22', '27', '21', '31', '378', '407', '461', '28', '770', '1376', '1588', '393', '817', '542', '39', '30', '36', '1012', '1245', '573', '1552', '1402', '1424', '35', '726', '792', '66', '585', '330', '1415', '462', '332', '1284', '1744', '113', '1422', '882', '1176', '1419', '1423', '1760', '24', '711', '1574', '9', '11', '1405', '1420', '1418', '1421', '439', '455', '434', '1215', '10', '580', '766', '1021', '1193', '1141', '78', '739', '452', '69', '81', '1454', '1572', '1372', '1682', '3', '674', '1008', '1095', '635', '678', '124', '338', '1373', '1168', '1319', '5', '335', '340', '116', '43', '253', '553', '850', '1569', '1678', '70', '1302', '148', '285', '1172', '111', '160', '451', '25', '348', '658', '944', '1260', '4', '390', '874', '966', '1159', '1247', '1259', '386', '716', '748', '385', '405', '626', '651', '1108', '616', '791', '1320', '1330', '1562', '314', '1088', '1323', '1325', '63', '389', '406', '768', '784', '286', '683', '1455', '1645', '207', '508', '582', '590', '970', '1672', '287', '327', '375', '1195', '1587', '119', '483', '526', '749', '1575', '84', '108', '291', '559', '1068', '1236', '401', '722', '854', '98', '394', '520', '1208', '1398', '1460', '163', '290', '657', '1742', '485', '1571', '1586', '150', '652', '775', '776', '1492', '403', '421', '704', '1268', '147', '151', '152', '341', '1064', '1266', '1269', '114', '1308', '123', '223', '547', '1289', '1321', '149', '1539', '325', '883', '954', '993', '105', '262', '517', '715', '958', '1711', '45', '351', '1270', '1389', '1471', '1724', '75', '1139', '1243', '1282', '1486', '1601', '1722', '1143', '1557', '1717', '545', '717', '790', '441', '1526', '1561', '1579', '1738', '324', '823', '885', '1013', '1075', '1151', '1214', '1326', '1327', '1437', '162', '333', '673', '1303', '1367', '93', '205', '516', '796', '968', '1040', '1318', '1704', '818', '1301', '1540', '82', '212', '701', '1063', '1216', '1348', '1602', '743', '988', '1043', '1218', '1344', '201', '751', '769', '852', '1137', '1144', '1217', '1262', '1343', '1676', '1740', '574', '732', '1160', '1409', '1566', '1766', '795', '884', '1283', '1452', '1453', '1604', '266', '639', '738', '1025', '1090', '1136', '1157', '1163', '1721', '448', '601', '669', '811', '1073', '1223', '1226', '1241', '1253', '1426', '1449', '14', '905', '1019', '1027', '1029', '1229', '1411', '1496', '1632', '1716', '467', '1152', '1358', '1413', '1474', '997', '1188', '1448', '1619', '74', '610', '1055', '1150', '1345', '1351', '1673', '1713', '1715', '417', '494', '836', '996', '1026', '1047', '1145', '1233', '1322', '1408', '1410', '1458', '1647', '1663', '1714', '643', '1743', '423', '453', '618', '709', '888', '973', '1034', '1149', '1231', '1366', '1404', '1522', '1580', '1609', '208', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1489', '1505', '1516', '1593', '1730', '666', '920', '921', '927', '931', '1004', '1017', '1042', '1230', '1354', '1508', '1606', '1627', '1649', '1729', '352', '493', '521', '914', '923', '1106', '1140', '1154', '1444', '1517', '1518', '1567', '499', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1514', '1674', '1708', '1751', '479', '703', '924', '972', '1001', '1020', '1052', '1175', '1352', '1515', '1521', '1596', '1723', '422', '665', '671', '781', '938', '1005', '1045', '1054', '1254', '1285', '1412', '1463', '937', '1051', '1053', '1091', '1092', '1445', '1650', '1681', '1684', '672')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,977,1291,258,1199,1359,1599,349,454,1135,1272,404,780,855,1677,986,1067,1237,265,1594,837,1607,37,38,34,22,27,21,31,378,407,461,28,770,1376,1588,393,817,542,39,30,36,1012,1245,573,1552,1402,1424,35,726,792,66,585,330,1415,462,332,1284,1744,113,1422,882,1176,1419,1423,1760,24,711,1574,9,11,1405,1420,1418,1421,439,455,434,1215,10,580,766,1021,1193,1141,78,739,452,69,81,1454,1572,1372,1682,3,674,1008,1095,635,678,124,338,1373,1168,1319,5,335,340,116,43,253,553,850,1569,1678,70,1302,148,285,1172,111,160,451,25,348,658,944,1260,4,390,874,966,1159,1247,1259,386,716,748,385,405,626,651,1108,616,791,1320,1330,1562,314,1088,1323,1325,63,389,406,768,784,286,683,1455,1645,207,508,582,590,970,1672,287,327,375,1195,1587,119,483,526,749,1575,84,108,291,559,1068,1236,401,722,854,98,394,520,1208,1398,1460,163,290,657,1742,485,1571,1586,150,652,775,776,1492,403,421,704,1268,147,151,152,341,1064,1266,1269,114,1308,123,223,547,1289,1321,149,1539,325,883,954,993,105,262,517,715,958,1711,45,351,1270,1389,1471,1724,75,1139,1243,1282,1486,1601,1722,1143,1557,1717,545,717,790,441,1526,1561,1579,1738,324,823,885,1013,1075,1151,1214,1326,1327,1437,162,333,673,1303,1367,93,205,516,796,968,1040,1318,1704,818,1301,1540,82,212,701,1063,1216,1348,1602,743,988,1043,1218,1344,201,751,769,852,1137,1144,1217,1262,1343,1676,1740,574,732,1160,1409,1566,1766,795,884,1283,1452,1453,1604,266,639,738,1025,1090,1136,1157,1163,1721,448,601,669,811,1073,1223,1226,1241,1253,1426,1449,14,905,1019,1027,1029,1229,1411,1496,1632,1716,467,1152,1358,1413,1474,997,1188,1448,1619,74,610,1055,1150,1345,1351,1673,1713,1715,417,494,836,996,1026,1047,1145,1233,1322,1408,1410,1458,1647,1663,1714,643,1743,423,453,618,709,888,973,1034,1149,1231,1366,1404,1522,1580,1609,208,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1489,1505,1516,1593,1730,666,920,921,927,931,1004,1017,1042,1230,1354,1508,1606,1627,1649,1729,352,493,521,914,923,1106,1140,1154,1444,1517,1518,1567,499,663,915,916,926,930,1003,1072,1138,1514,1674,1708,1751,479,703,924,972,1001,1020,1052,1175,1352,1515,1521,1596,1723,422,665,671,781,938,1005,1045,1054,1254,1285,1412,1463,937,1051,1053,1091,1092,1445,1650,1681,1684,672') 0.064946174621582
(326) DESCRIBE `cruisetypes` 0.0021109580993652
(327) DESCRIBE `destinations` 0.0029809474945068
(328) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '28', '26', '55', '38', '40', '7', '30', '21', '48', '11', '49', '45', '29', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,28,26,55,38,40,7,30,21,48,11,49,45,29,44,56,10,34,52,32,46') 0.004425048828125