SELECT DISTINCT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourIsNew, tourBookable, tourPage, tourVersionNum, tourLargeImg, tourMap, tourSaleCode, tourLandMinDuration, tourLandMaxDuration, tourLandMinEarlyBookPrice, tourLandMaxEarlyBookPrice, tourLandMinSalePrice, tourLandMaxSalePrice, tourAirMinDuration, tourAirMaxDuration, tourAirMinEarlyBookPrice, tourAirMaxEarlyBookPrice, tourAirMinSalePrice, tourAirMaxSalePrice, tourMinEarlyBookDiscount, tourMaxEarlyBookDiscount, tourMinSaleDiscount, tourMaxSaleDiscount, tourMinTotalDiscount, tourMaxTotalDiscount, ISNULL(tourAirMinSalePrice,tourLandMinSalePrice) AS tourMinSalePrice, DENSE_RANK() OVER(PARTITION BY tourPage, tourCategory ORDER BY tourVersionNum ASC) AS tourVersionOrder FROM toursActiveCache t INNER JOIN tourThemes ON ttTourId = tourId AND ttThemeId IN (8) WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) AND tourBookable = 1 ORDER BY tourMinSalePrice, tourFeatureTitle
44431
Small Ship Cruise Packages - Friendly Planet Travel
Few travel experiences can rival the romance of small ship ocean cruising. Accessing the hidden nooks and ports that big-box cruise ships can't reach, sailing into tiny towns and picturesque villages. Witness every day how the sea has shaped the rocky shorelines and sheer cliffs, the seasonal cuisine and cultural mindset of the places you visit. There's not much more to say except…Bon Voyage!
Ancient Athens, then a 3 day cruise to Mykonos, Kusadasi, Ephesus, Patmos, Santorini & Crete; independent adventure with flights & hotel included. Optional Classical Greece extension.
Athens, then a 4-day cruise to Mykonos, Kuşadası, Patmos, Rhodes, Crete & Santorini; travel on your own with flights & hotel included. Optional Classical Greece extension.
Athens, then a 7-day cruise of the Greek Isles plus Kuşadası, Turkey; independent travel with flights & hotel included. Optional Classical Greece extension.
from $3899 w/ Flights from $3199 Tour Only 12 days
2 nights in Split & a 7-night cruise with medieval Trogir, the island of Korčula, Dubrovnik, the "Pearl of the Adriatic," & historic Hvar; optional extension to Zagreb & Plitvice Lakes
We love hearing your stories and seeing your photos! Check out our entire fan photo gallery and upload your photos.
Check out independent, verified reviews from real travelers on Feefo.
Execution time
Starting query: SELECT DISTINCT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourIsNew, tourBookable, tourPage, tourVersionNum, tourLargeImg, tourMap, tourSaleCode, tourLandMinDuration, tourLandMaxDuration, tourLandMinEarlyBookPrice, tourLandMaxEarlyBookPrice, tourLandMinSalePrice, tourLandMaxSalePrice, tourAirMinDuration, tourAirMaxDuration, tourAirMinEarlyBookPrice, tourAirMaxEarlyBookPrice, tourAirMinSalePrice, tourAirMaxSalePrice, tourMinEarlyBookDiscount, tourMaxEarlyBookDiscount, tourMinSaleDiscount, tourMaxSaleDiscount, tourMinTotalDiscount, tourMaxTotalDiscount, ISNULL(tourAirMinSalePrice,tourLandMinSalePrice) AS tourMinSalePrice, DENSE_RANK() OVER(PARTITION BY tourPage, tourCategory ORDER BY tourVersionNum ASC) AS tourVersionOrder FROM toursActiveCache t INNER JOIN tourThemes ON ttTourId = tourId AND ttThemeId IN (8) WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) AND tourBookable = 1 ORDER BY tourMinSalePrice, tourFeatureTitle