American Samoa destinations

TUI: up to 10% off holidays booked online

Sale

Book online with TUI & save up to 10% on holidays
FREE child places available for select holidays
Pay £0 deposit holidays with direct debit

Go to TUI deal >>

View all TUI offers

TUI deal finder

Destination

All American Samoa destinations

Pago Pago

SELECT DealsWidgets2Brands.WidgetID, DealsWidgets2Brands.DestID, DealsWidgets2Brands.RegionCode, Regions.RegionTitle, Regions.ShortName As 'DestName', Regions.TheFlag, AffiliateMerchants.MerchantID, AffiliateMerchants.MerchantName, AffiliateMerchants.MerchantLogo, DealsWidgets2Brands.DestURL, AffiliateMerchants.TopFlag, DealsWidgets.ProductType, DealsWidgets.ProductID FROM DealsWidgets2Brands, AffiliateMerchants, Regions, DealsWidgets WHERE DealsWidgets.WidgetID=DealsWidgets2Brands.WidgetID AND DealsWidgets2Brands.RegionCode=Regions.RegionCode AND DealsWidgets2Brands.MerchantID=AffiliateMerchants.MerchantID AND DealsWidgets2Brands.ShowFlag=1 AND AffiliateMerchants.ShowFlag=1 AND DealsWidgets2Brands.RegionCode="AQ" AND DealsWidgets2Brands.ResortID=0 AND AffiliateMerchants.MerchantRank<20 AND DealsWidgets.ProductID>0 ORDER BY AffiliateMerchants.MerchantRank;

SELECT DealsWidgets2Brands.WidgetID, DealsWidgets2Brands.DestID, DealsWidgets2Brands.RegionCode, Regions.RegionTitle, Regions.TheFlag, AffiliateMerchants.MerchantID, AffiliateMerchants.MerchantName, AffiliateMerchants.MerchantLogo, DealsWidgets2Brands.DestURL, AffiliateMerchants.TopFlag, DealsWidgets.ProductType, DealsWidgets.ProductID FROM DealsWidgets2Brands, AffiliateMerchants, Regions, DealsWidgets WHERE DealsWidgets.WidgetID=DealsWidgets2Brands.WidgetID AND DealsWidgets2Brands.RegionCode=Regions.RegionCode AND DealsWidgets2Brands.MerchantID=AffiliateMerchants.MerchantID AND DealsWidgets2Brands.ShowFlag=1 AND AffiliateMerchants.ShowFlag=1 AND DealsWidgets2Brands.RegionCode="AQ" AND DealsWidgets2Brands.ResortID=0 AND AffiliateMerchants.MerchantRank>=20 AND DealsWidgets.ProductID>0 AND AffiliateMerchants.MerchantID<>299 ORDER BY DealsWidgets.ProductID, AffiliateMerchants.MerchantRank;