UK Only Cruises A selection of cruises around the British Isles.

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