171
2047
1
false
SELECT
Cruises.CruiseID,
Cruises.CruisePrice,
Cruises.CruiseEmbarkTime,
Cruises.CruiseName,
Cruises.CruiseDuration,
Cruises.CruiseLineId,
Cruises.CruiseEmbarkLocation,
Cruises.CruiseDisembarkLocation,
CruiseLines.CruiseLineID,
CruiseLines.CruiseLineName,
CruiseLines.CruiseLineSeoName,
Ships.ShipId,
Ships.ShipSeoName,
Ships.ShipName
FROM Cruises
INNER JOIN CruiseLines ON Cruises.CruiseLineId = CruiseLines.CruiseLineID
INNER JOIN Ships ON Cruises.ShipId = Ships.ShipId WHERE Cruises.CruiseEmbarkTime >= NOW() AND Cruises.ShipId != 99999 AND VisitAlbania = 0
AND VisitAlgeria = 0
AND VisitAmericanSamoa = 0
AND VisitAngola = 0
AND VisitAnguilla = 0
AND VisitAntarctica = 0
AND VisitAntiguaAndBarbuda = 0
AND VisitArgentina = 0
AND VisitAruba = 0
AND VisitAustralia = 0
AND VisitAustria = 0
AND VisitAlandIslands = 0
AND VisitBahamas = 0
AND VisitBahrain = 0
AND VisitBangladesh = 0
AND VisitBarbados = 0
AND VisitBelgium = 0
AND VisitBelize = 0
AND VisitBenin = 0
AND VisitBermuda = 0
AND VisitBonaire = 0
AND VisitBosniaAndHerzegovina = 0
AND VisitBotswana = 0
AND VisitBrazil = 0
AND VisitBritishVirginIslands = 0
AND VisitBruneiDarussalam = 0
AND VisitBulgaria = 0
AND VisitCambodia = 0
AND VisitCameroon = 0
AND VisitCanada = 0
AND VisitCapeVerde = 0
AND VisitCaymanIslands = 0
AND VisitCoteDIvoire = 0
AND VisitChile = 0
AND VisitChina = 0
AND VisitColombia = 0
AND VisitComoros = 0
AND VisitCookIslands = 0
AND VisitCostaRica = 0
AND VisitCroatia = 0
AND VisitCuba = 0
AND VisitCuracao = 0
AND VisitCyprus = 0
AND VisitCzechRepublic = 0
AND VisitDenmark = 0
AND VisitDjibouti = 0
AND VisitDominica = 0
AND VisitDominicanRepublic = 0
AND VisitEcuador = 0
AND VisitEgypt = 0
AND VisitElSalvador = 0
AND VisitEstonia = 0
AND VisitFalklandIslands = 0
AND VisitFaroeIslands = 0
AND VisitFiji = 0
AND VisitFinland = 0
AND VisitFrance = 0
AND VisitFrenchGuiana = 0
AND VisitFrenchPolynesia = 0
AND VisitGambia = 0
AND VisitGeorgia = 0
AND VisitGermany = 0
AND VisitGhana = 0
AND VisitGibraltar = 0
AND VisitGreece = 0
AND VisitGreenland = 0
AND VisitGrenada = 0
AND VisitGuadeloupe = 0
AND VisitGuam = 0
AND VisitGuatemala = 0
AND VisitGuernsey = 0
AND VisitGuineaBissau = 0
AND VisitHaiti = 0
AND VisitHonduras = 0
AND VisitHongKong = 0
AND VisitHungary = 0
AND VisitIceland = 0
AND VisitIndia = 0
AND VisitIndonesia = 0
AND VisitIreland = 0
AND VisitIsrael = 0
AND VisitItaly = 0
AND VisitJamaica = 0
AND VisitJapan = 0
AND VisitJersey = 0
AND VisitJordan = 0
AND VisitKenya = 0
AND VisitKiribati = 0
AND VisitLatvia = 0
AND VisitLiberia = 0
AND VisitLithuania = 0
AND VisitLuxembourg = 0
AND VisitMadagascar = 0
AND VisitMalaysia = 0
AND VisitMaldives = 0
AND VisitMalta = 0
AND VisitMarshallIslands = 0
AND VisitMartinique = 0
AND VisitMauritius = 0
AND VisitMayotte = 0
AND VisitMexico = 0
AND VisitMicronesia = 0
AND VisitMonaco = 0
AND VisitMontenegro = 0
AND VisitMontserrat = 0
AND VisitMorocco = 0
AND VisitMozambique = 0
AND VisitMyanmar = 0
AND VisitNamibia = 0
AND VisitNetherlands = 0
AND VisitNewCaledonia = 0
AND VisitNewZealand = 0
AND VisitNicaragua = 0
AND VisitNiue = 0
AND VisitNorfolkIsland = 0
AND VisitNorthernMarianaIslands = 0
AND VisitNorway = 0
AND VisitOman = 0
AND VisitPanama = 0
AND VisitPapuaNewGuinea = 0
AND VisitPeru = 0
AND VisitPhilippines = 0
AND VisitPitcairn = 0
AND VisitPoland = 0
AND VisitPortugal = 0
AND VisitPuertoRico = 0
AND VisitQatar = 0
AND VisitReunion = 0
AND VisitRomania = 0
AND VisitRussia = 0
AND VisitSaintBarthelemy = 0
AND VisitSaintHelenians = 0
AND VisitSaintKittsAndNevis = 0
AND VisitSaintLucia = 0
AND VisitSaintMartinFrenchPart = 0
AND VisitSaintPierreAndMiquelon = 0
AND VisitSaintVincentAndTheGrenadines = 0
AND VisitSamoa = 0
AND VisitSaoTomeAndPrincipe = 0
AND VisitScatteredIslands = 0
AND VisitSenegal = 0
AND VisitSerbia = 0
AND VisitSeychelles = 0
AND VisitSierraLeone = 0
AND VisitSingapore = 0
AND VisitSintMaartenDutchPart = 0
AND VisitSlovakia = 0
AND VisitSlovenia = 0
AND VisitSolomonIslands = 0
AND VisitSouthAfrica = 0
AND VisitSouthGeorgiaAndTheSouthSandwichIslands = 0
AND VisitSouthKorea = 0
AND VisitSpain = 0
AND VisitSriLanka = 0
AND VisitSuriname = 0
AND VisitSvalbardAndJanMayen = 0
AND VisitSweden = 0
AND VisitSwitzerland = 0
AND VisitTaiwan = 0
AND VisitTanzania = 0
AND VisitThailand = 0
AND VisitTimorLeste = 0
AND VisitTogo = 0
AND VisitTonga = 0
AND VisitTrinidadAndTobago = 0
AND VisitTunisia = 0
AND VisitTurkey = 0
AND VisitTurksAndCaicosIslands = 0
AND VisitUSVirginIslands = 0
AND VisitUkraine = 0
AND VisitUnitedArabEmirates = 0
AND VisitUnitedStates = 0
AND VisitUruguay = 0
AND VisitVanuatu = 0
AND VisitVenezuela = 0
AND VisitVietnam = 0
AND VisitWallisAndFutuna = 0
AND VisitWesternSahara = 0
AND VisitZimbabwe = 0
AND CruiseEmbarkTime >= NOW()
ORDER BY CruisePrice DESC
LIMIT 0, 12
Japan’s Cultural & Coastal Discovery
Crystal Endevour 3rd Oct 2023
Embark
Tokyo
Disembark
Tokyo
View CruiseIndia's Golden Triangle & the Sacred Ganges
Ganges Voyager ii 3rd Oct 2023
Embark
Kolkata (ex Calcutta)
Disembark
Kolkata (ex Calcutta)
View CruiseAutumn In Turkey
Seven Seas Voyager 3rd Oct 2023
Embark
Piraeus
Disembark
Haifa
View CruiseMediterranean Delights
Seven Seas Voyager 3rd Oct 2023
Embark
Piraeus
Disembark
Venice
View CruiseMediterranean Medley
Marella Discovery 2 3rd Oct 2023
Embark
Palma de Mallorca
Disembark
Palma de Mallorca
View CruiseAmsterdam, Cologne and the Best of Holland & Flanders River Cruise - MS Oscar Wilde
MS Oscar Wilde 3rd Oct 2023
Embark
Amsterdam
Disembark
Cologne
View CruiseThe Seine, Paris & Normandy River Cruise - MS Jane Austen
MS Jane Austen 3rd Oct 2023
Embark
Paris
Disembark
Paris
View CruiseDouro, Porto & Salamanca River Cruise - MS Douro Elegance
MS Douro Elegance 3rd Oct 2023
Embark
Porto
Disembark
Porto
View CruiseDiscover the Loire Canal In the heart of France, charming cities reveal their secrets
Raymonde 3rd Oct 2023
Embark
Briare
Disembark
Nevers
View Cruise31-Day Hawaii, Tahiti & South Pacific Crossing
Majestic Princess 3rd Oct 2023
Embark
Vancouver, British Columbia
Disembark
Sydney, New South Wales
View Cruise26-Day Hawaii, Tahiti & South Pacific Crossing
Majestic Princess 3rd Oct 2023
Embark
Vancouver, British Columbia
Disembark
Auckland
View CruiseMediterranean
Aurora 3rd Oct 2023
Embark
Southampton
Disembark
Southampton
View Cruise