549
6585
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
Canary Islands
Azura 9th Mar 2024
Embark
Santa Cruz de Tenerife
Disembark
Valletta
View CruiseBrisbane to Hong Kong
Arcadia 25th Feb 2024
Embark
Brisbane, Queensland
Disembark
Hong Kong
View Cruise8 Night E. Carib & Perfect Day Cruise
Mariner of the Seas 23rd Jul 2023
Embark
Port Canaveral, Florida
Disembark
Port Canaveral, Florida
View CruiseWestern Europe
Ventura 21st Oct 2023
Embark
Southampton
Disembark
Southampton
View CruiseWestern Europe
Aurora 29th Dec 2023
Embark
Southampton
Disembark
Southampton
View CruiseCanary Islands
Iona 11th Nov 2023
Embark
Southampton
Disembark
Southampton
View Cruise7 Night Multi Glacier Experience Cruise
Enchantment of the Seas 16th Jul 2023
Embark
Vancouver, British Columbia
Disembark
Vancouver, British Columbia
View CruiseCaribbean
Britannia 9th Feb 2024
Embark
Bridgetown
Disembark
Bridgetown
View CruiseColors of Provence
AmaKristina 5th Oct 2023
Embark
Avignon
Disembark
Lyon
View CruiseRhine Castles & Swiss Alps (Christmas)
AmaSerena 4th Dec 2023
Embark
Basel
Disembark
Amsterdam
View CruiseStars of South Africa
Zambezi Queen 17th Jul 2023
Embark
Cape Town
Disembark
Victoria Falls
View CruiseExperience the Northern Rhine
A'Rosa Aqua 4th Jun 2023
Embark
Cologne
Disembark
Cologne
View Cruise