SELECT *, COALESCE(dates.overrideshipname, tours.ship_name) AS ship_name, (SELECT Name FROM companies WHERE companies.id = companyid) AS CompanyName, dates.id AS dateid, tours.id AS TourId, (SELECT GROUP_CONCAT(DISTINCT CategoryName) FROM dates_categories WHERE TourId = tours.id AND DateId = dates.id) AS CatsByDate, (SELECT CategoryName FROM dates_categories WHERE TourId = tours.id AND DateId = dates.id ORDER BY FareAmt LIMIT 1) AS CheapestCatForDate, (SELECT PortChargeOrNonComm FROM dates_categories WHERE TourId = tours.id AND DateId = dates.id ORDER BY FareAmt LIMIT 1) AS CheapestCatPortFees FROM tours INNER JOIN dates ON dates.tourid = tours.id WHERE hide = 0 AND NOT general_destination IS NULL AND NOT general_destination = '' AND dates.StartDate >= '2025-01-26' AND tours.CompanyId = 40 ORDER BY general_destination_simplified, startdate, LandPrice

Cruise Finder
Vendor:	90-Day TickerWorld Cruises=======================American Cruise LinesAtlas Ocean VoyagesAzamaraCelebrityCelestyalCrystalCunardExplora JourneysHolland AmericaHurtigrutenLindblad ExpeditionsNCL CruisesOceaniaPaul GauguinPearl SeasPonantPrincessQuarkRegentRitz CarltonRoyal CarinbbeanScenic CruisesSeabournSilverseaStar ClippersSwan HellenicWindstarViking OceanVirgin Voyages
Date:	Any DateJanuary 2025February 2025March 2025April 2025May 2025June 2025July 2025August 2025September 2025October 2025November 2025December 2025January 2026February 2026March 2026April 2026May 2026June 2026July 2026August 2026September 2026October 2026November 2026December 2026January 2027February 2027March 2027April 2027May 2027June 2027July 2027August 2027September 2027October 2027November 2027December 2027January 2028February 2028March 2028April 2028May 2028June 2028July 2028August 2028September 2028October 2028November 2028December 2028
Length:	Any Length1-7 Nights8-14 Nights15+ Nights