Website Banners (5)
SELECT bc.special_message, bc.offer_listing, bc.package_start_date, bc.strike_price,bl.reff_code,bc.basepoke_id,bc.offer_short_summery,bl.ship_id,bc.cruise_id,bc.offer_title,bc.cruise_nights,bc.offer_price,bc.departure_date FROM discovercru_basepoke_list as bl INNER JOIN discovercru_basepoke_cruises as bc ON bl.id = bc.basepoke_id WHERE bl.bl_cruise_id = bc.cruise_id AND bc.offer_start_date < curdate() and bc.offer_end_date > curdate() and bc.departure_date > '2020-02-26 16:07:47' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY bc.offer_order DESC LIMIT 0,9
  • First
  • Previous
  • 1
  • 2
  • 3
  • Next
  • Last
New York Stay & Caribbean Charms Cruise
ship - MSC Divina
Departs: 04 March 2021 | 10 Nights
Cruise Itinerary - Miami, Florida | At Sea | San Juan | San Juan | Road Town | Philipsburg | At Sea | NassauMiami, Florida
Quote Ref: 29490
South America & Chilean Fjords Discovery
ship - MS Westerdam
Departs: 29 October 2020 | 15 Nights
Cruise Itinerary - San Antonio, Santiago, Chile | At Sea | Puerto Montt | Puerto Chacabuco | At Sea | At Sea | At Sea | Punta Aren ...Buenos Aires, Argentina
Quote Ref: 61583
Rio De Janeiro Stay and Grand Voyage to Southampton
ship - MSC Preziosa
Departs: 26 March 2021 | 18 Nights
Cruise Itinerary - Rio de Janeiro, Brazil | Buzios | At Sea | Ilheus(Bahia) | Bahia de Salvador | At Sea | At Sea | At Sea | ...Southampton, England
Quote Ref: 5968
Mediterranean Gems & Caribbean Delights
ship - MSC Divina
Departs: 05 January 2021 | 24 Nights
Cruise Itinerary - Barcelona, Spain | Ajaccio | Livorno (Florence/Pisa) | Genoa | Marseille | At Sea | Valencia | AT S ...Livorno (Florence/Pisa), Italy
Quote Ref: 644
Las Vegas & Los Angeles Stay and Pacific Coastal Cruise
ship - Norwegian Joy
Departs: 14 April 2020 | 12 Nights
Cruise Itinerary - LOS ANGELES | At Sea | SAN FRANCISCO | At Sea | VANCOUVERVANCOUVER
Quote Ref: 75544
New Orleans, Miami & Caribbean Explorer
ship - Explorer of the Seas
Departs: 24 November 2020 | 10 Nights
Cruise Itinerary - Miami, Florida | At Sea | Labadee (Labadie) | At Sea | NassauMiami, Florida
Quote Ref: 51764
Singapore Stay & Treasures of Thailand & Vietnam
ship - Celebrity Eclipse
Departs: 09 November 2020 | 15 Nights
Cruise Itinerary - Singapore, Singapore | At Sea | At Sea | Chan May | At Sea | Nha Trang | Phu My | At Sea | Ko Samui | B ...Singapore, Singapore
Quote Ref: 57615
Dubai Stay & Arabian Gulf Adventure
ship - Oceana
Departs: 11 December 2020 | 9 Nights
Cruise Itinerary - Dubai | Dubai | Abu Dhabi | At Sea | Muscat | Muscat | KhasabDubai
Quote Ref: 21758
San Francisco Stay & Alaskan Miracles
ship - Carnival Miracle
Departs: 09 May 2020 | 12 Nights
Cruise Itinerary - San Francisco, California | At Sea | At Sea | Juneau | Skagway | Icy Strait | Endicott Arm | At Sea | Victor ...San Francisco, California
Quote Ref: 2213
  • First
  • Previous
  • 1
  • 2
  • 3
  • Next
  • Last