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
11131141431113444134411111111444111344311134111111411134441343111111111131311114444441113311
*** DEVELOPMENT VERSION ***
This is quite embarrassing, but our website database is currently having issues. That means most stuff related to our tours & packages won't work, including webpages, online bookings, search results and lists of our packages. We are working to fix this as quickly as we can, so please check back soon!
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.21 seconds |
Query executed in: | 0.04 seconds |
Total execution: | 0.32 seconds |