Filter Your SearchDeparts FromShow me allSELECT DISTINCT airports.id, airports.airport_name, airports.airport_code, airports.airport_country FROM airports, latecards, selected_operators, latecard_variable WHERE latecards.latecard_disabled=0 AND latecards.latecard_enddate >= '2020-06-06' AND selected_operators.user_id = 2143 AND latecards.latecard_user_id=selected_operators.operator_id AND latecards.id=latecard_variable.latecard_id AND airports.id=latecard_variable.variable_feature ORDER BY airports.airport_nameAberdeenBelfastBirminghamBournemouthBristolCardiffDublinEast MidlandsEdinburghEurostar - St PancrasGlasgowInvernessJerseyJoin at HotelLeeds/BradfordLondon AirportsLondon GatwickLondon HeathrowLondon LutonLondon StanstedManchesterNewcastle Upon TyneNewquay AirportSouthampton PortTypesShow me allSELECT DISTINCT holiday_types.id, holiday_types.holiday_type FROM holiday_types, latecard_holiday_type,latecards, selected_operators WHERE latecards.latecard_disabled=0 AND latecards.latecard_enddate >= '2020-06-06' AND selected_operators.user_id = 2143 AND latecards.latecard_user_id=selected_operators.operator_id AND latecards.id=latecard_holiday_type.latecards_id AND holiday_types.id=latecard_holiday_type.holiday_type_id ORDER BY holiday_types.holiday_type ASCAdventure CruisingAll InclusiveApartment HolidayBeach HolidaysChristmas MarketsCities & Short BreaksCruise & StayCruise - Ocean & RiverDisney HolidaysDiving HolidaysDriving HolidaysFamily CruisingFamily HolidaysHoneymoon-WeddingHotelLuxury CruisingLuxury HolidaysRail HolidaysSafariSingle HolidaysSun HolidaysTouring & Escorted ToursUK & IrelandVilla HolidayRegionShow me allSELECT DISTINCT wp_id, wp_continent_name, wpc_id, wpc_country_name, wpc_continent_id FROM wp_property_continent, wp_property_country, latecards, selected_operators WHERE latecards.latecard_disabled=0 AND latecards.latecard_enddate >= '2020-06-06' AND selected_operators.user_id = 2143 AND latecards.latecard_user_id=selected_operators.operator_id AND wp_property_country.wpc_id = latecards.latecard_country AND wp_property_continent.wp_id = wp_property_country.wpc_continent_id ORDER BY wp_property_continent.wp_continent_name ASCAfricaSouth AfricaIndonesiaSouth KoreaIndiaSri LankaThailandJapanVietnamCambodiaSingaporeAustraliaNew ZealandCruise: WorldwideFranceGreecePortugalLaplandCzech RepublicTurkeyAustriaCyprusCruise: UKCanary IslandsSpainCroatiaCruise: MediterraneanBulgariaCruise: BalticHungaryCruise: European RiverMaltaMadeiraGermanyMonacoItalyUKMaldivesMauritiusSeychellesAbu DhabiDubaiCaribbeanCruise: North AmericaAlaskaCanadaUSACruise: AlaskaCruise: South America BrazilPeruMonthShow me allSELECT DATE_FORMAT(latecards.latecard_holiday_startdate,'%M') month, DATE_FORMAT(latecards.latecard_holiday_startdate,'%m') month_num,DATE_FORMAT(latecards.latecard_holiday_startdate, '%Y') year FROM latecards , selected_operators WHERE latecards.latecard_disabled=0 AND latecards.latecard_enddate >= '2020-06-06' AND latecards.latecard_holiday_startdate > '2020-06-06' AND selected_operators.user_id = 2143 AND latecards.latecard_user_id=selected_operators.operator_id group by YEAR(latecards.latecard_holiday_startdate), MONTH(latecards.latecard_holiday_startdate) order by YEAR(latecards.latecard_holiday_startdate), MONTH(latecards.latecard_holiday_startdate) ASCJune 2020July 2020August 2020September 2020October 2020November 2020December 2020January 2021February 2021March 2021April 2021May 2021June 2021July 2021August 2021September 2021October 2021PricePrice filterLow to HighHigh to LowGO
by net effect