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 (1) WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle

Active Packages - Friendly Planet Travel

*** 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!

Active Packages

Active Packages

Get ready for adventure on these tours designed for the get-up-and-go traveler! Go ahead, climb the greatest Great Wall, hike the jungles of Borneo, explore the expansive Saharan sand dunes, and so much more. We've created these action-packed itineraries that offer physical activities that we know adventure travelers love!

Search filters:
  • Interests: Active
  • including closed packages
to
to
to
clear all
Sorry, there are currently no matching packages. Try searching again for something different or less specific.
* Advertised prices may include an "Instant Savings" discount and/or sale discount, available for a limited time. Prices reflect these discounts. Advertised prices are per person, based on double occupancy; single occupancy rooms may be available for an additional charge. Advertised prices are the best available based on the least expensive travel dates, departure city, and other options, and do not include optional excursions or other optional items. Your total price will vary based upon the dates, flights, and other options you select during the booking process. For packages including flights, prices include Airline Taxes, Fees & Sept. 11th Security Fee, but do not include excess baggage fees or advance seat reservations. Prices and availability subject to change. More about our prices.

© Friendly Planet Travel   Privacy Policy
SCRIPT ERRORS:

Database errors occured on /vacation-packages/index.asp?theme=1 while opening database connection
Error #: 0
Description: Invalid connection string attribute
Native error: 0



Please notify the webmaster of this error.
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 (1) 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.03 seconds
Total execution:   0.04 seconds