0
0
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 RiverCruise = 1
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 VisitIsleOfMan = 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 = 1
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 VisitScotland = 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 VisitSouthOrkneyIslands = 0
AND VisitSouthShetlandIslands = 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