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 = 351 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle
44
Tours & Packages to Indonesia - Friendly Planet Travel
Fringed by gorgeous beaches, looming volcanoes punctuate the horizon. In tourist-friendly towns, streets are clean, and restaurants and boutiques are cheerful and inviting. Nature parks teem with birds and exotics like the crab-eating macaque monkeys. Clear, calm waters make Indonesia a renowned diving destination.
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 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 = 'indonesia' AND locationType = 2 AND locationSiteId = 1
0 seconds
Query executed in:
0.01 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 = 351 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle