*** DEVELOPMENT VERSION ***

Hot Travel Deals

Limited Time Extra Savings

Sorry, there are no last-minute deals right now, but check back soon!
* 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
Execution time
Starting query:
SELECT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourPage, tourVersionNum, tourLargeImg, tourFeatureImg, dateId, dateLandOnly, dateDeparts, dateReturns, dateRegularPrice, dateRegularPrice - dateDiscount - dateCouponDiscount AS dateCouponPrice, dateDiscount + dateCouponDiscount AS dateTotalDiscount, COUNT(*) OVER(PARTITION BY tourId) AS dateCount, ROW_NUMBER() OVER(PARTITION BY tourId ORDER BY dategtwyDeparts, dateLandOnly) AS dateNum FROM ( SELECT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourPage, tourVersionNum, tourLargeImg, tourFeatureImg, dateId, CAST(dateDeparts AS date) AS dateDeparts, CAST(dateReturns AS date) AS dateReturns, CAST(dategtwyDeparts AS date) AS dategtwyDeparts, CAST(dategtwyReturns AS date) AS dategtwyReturns, dategtwyDuration, dateLandOnly, datePrice+dategtwyPrice AS dateRegularPrice, dateDiscount, (CASE WHEN ctLimitedDates = 0 OR cdDateId IS NOT NULL THEN COALESCE(cdDiscount,couponDiscount,0) ELSE 0 END) AS dateCouponDiscount FROM ( SELECT tourId, tourSiteId, tourName, tourVersionName, tourCallToBook, tourEnabled, tourIsPublic, tourLandTour, tourSeaCruise, tourRiverCruise, tourCategory, tourScheduled, tourEscorted, tourDays, tourSpecialExpires, tourNewUntil, COALESCE(tourFeatureTitle,tourName) AS tourFeatureTitle, tourSubhead, tourPage, tourIncludesFlights, tourFeatureImg, tourLargeImg, tourHeroImg, tourActive, tourBookable, tourDays AS tourDuration, (CASE WHEN tourPage IS NULL THEN 1 ELSE ROW_NUMBER() OVER(PARTITION BY tourPage ORDER BY tourEnabled DESC, tourIsPublic DESC, tourBookable DESC, tourVersionDefault DESC, tourId DESC) END) AS tourVersionNum FROM tours WHERE tourSiteId = 1 AND tourEnabled = 1 AND tourBookable = 1 ) t INNER JOIN vTourDatesAndGatewaysAvailable dg ON tourId = dateTourId AND dateBookable = 1 AND dategtwyDisabled = 0 AND (dateLandOnly = 1 OR dategtwyOrder = 1) LEFT JOIN vSaleToursAvailable b ON ctTourId = tourId AND couponSiteId = 1 AND couponOrder = 1 LEFT JOIN couponDates ON cdCouponCode = couponCode AND cdSiteId = 1 AND (couponLimitedTours = 0 OR ctTourId = tourId) AND cdDateId = dateId WHERE tourSiteId = 1 AND tourActive = 1 AND tourCategory IN (1,3,4) AND tourIsPublic = 1 AND tourPage IS NOT NULL AND dateFeatured = 1 ) a ORDER BY dategtwyDeparts, tourFeatureTitle, dateLandOnly		 0 seconds
Query executed in: 0.06 seconds
Starting query:
SELECT 1		 0 seconds
Query executed in: 0.04 seconds
Total execution:   0.1 seconds