Starting query:
SELECT locationId, locationName, locationParentId, locationCode2, locationHTMLTitle, locationMetaDesc, locationDesc, locationHighlights, locationLargeImage, showId AS locationSlideshowId, showLastModified AS locationSlideshowVer, slideImg AS locationSlideshowFirstImg, locationVideoIDs, locationFAQs, locationEntryReqs, locationFactsOverview, locationFactsHealth, locationFactsWeather, locationFactsClothing, locationFactsDining, locationFactsTipping, locationFactsMoney, locationFactsShopping, locationFactsPower, locationFactsTechnology, locationFactsPhotography, locationFactsTidbits, locationOmitFromMenus FROM locations LEFT JOIN ( SELECT showId, ROUND(CAST(s.lastModified AS float),4) AS showLastModified, slideImg, ROW_NUMBER() OVER (PARTITION BY showId ORDER BY slideOrder ASC) AS RowNum FROM slideshows s INNER JOIN slideshowImages i ON showId = slideShowId ) s ON showId = locationSlideshowId AND s.RowNum = 1 WHERE locationPage = 'canada' AND locationType = 2 AND locationSiteId = 1 | 0 seconds |
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 LEFT JOIN tourLocations ON tourId = tlTourId LEFT JOIN locations ON tlLocationId = locationId AND locationType = 2 AND locationSiteId = 1 LEFT JOIN locationAssns ON laLocationId = locationId WHERE tourSiteId = 1 AND tourIsPublic = 1 AND locationId = 565 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle | 0 seconds |
Canada
