Tours & Packages
















































































Trip Reviews & Photos
We love hearing your stories and seeing your photos! Check out our entire fan photo gallery and upload your photos.
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 WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle
11144114131114433414141144141111114311131411331114141313311144411441131111113113111444411
*** DEVELOPMENT VERSION ***
We love hearing your stories and seeing your photos! Check out our entire fan photo gallery and upload your photos.
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 WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle | 0.01 seconds |
Query executed in: | 0.04 seconds |
Starting query: SELECT 1 | 0.25 seconds |
Query executed in: | 0.04 seconds |
Total execution: | 0.35 seconds |