17
201
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
Hawaii: Inter-island
Pride of America 11th Jan 2025
Embark
Honolulu, Hawaii
Disembark
Honolulu, Hawaii
View CruiseAlaska: Glacier Bay, Skagway & Juneau
Norwegian Encore 13th Oct 2024
Embark
Seattle, Washington
Disembark
Seattle, Washington
View CruiseCanada & New England: Newport & Portland
Norwegian Breakaway 13th Oct 2024
Embark
New York, New York
Disembark
New York, New York
View CruiseAlaska: Glacier Bay, Skagway & Juneau
Norwegian Bliss 12th Oct 2024
Embark
Seattle, Washington
Disembark
Seattle, Washington
View CruiseBermuda
Norwegian Joy 11th Oct 2024
Embark
New York, New York
Disembark
New York, New York
View CruiseCanada & New England to Boston
Norwegian Gem 11th Oct 2024
Embark
Quebec City, Québec
Disembark
Boston, Massachusetts
View CruiseAlaska: Glacier Bay, Skagway & Juneau
Norwegian Jewel 10th Oct 2024
Embark
Seattle, Washington
Disembark
Seattle, Washington
View CruiseMediterranean: Italy, France & Greece to Barcelona
Norwegian Escape 10th Oct 2024
Embark
Venice
Disembark
Barcelona
View CruiseBermuda
Norwegian Joy 7th Oct 2024
Embark
New York, New York
Disembark
New York, New York
View CruiseGreek Isles: Santorini, Mykonos & Croatia
Norwegian Pearl 6th Oct 2024
Embark
Venice
Disembark
Venice
View CruiseGreek Isles: Santorini, Athens & Florence
Norwegian Epic 6th Oct 2024
Embark
Civitavecchia
Disembark
Civitavecchia
View CruiseBaltic: Germany, Russia, Sweden & Finland
Norwegian Getaway 13th Oct 2024
Embark
Copenhagen
Disembark
Copenhagen
View Cruise