BACK TO ALL EXPERIENCES

BORN TO BE WILD

ADVENTURE EXPERIENCE DAYS
For people who want to experience every part of the world we live in, freefalling through the skies, climbing the highest peaks or exploring the depths of the earth to discover hidden caves or our underwater world. To feel, smell and see amazing sights and prove to ourselves what we’re really capable of.

Get Set to Get Wet

The Ocean is the perfect playground to experience extraordinary things. We’ve only discovered a tiny 5% of the world’s oceans and you can explore British waters for yourself, by powering through them in a RIB Powerboat, riding the tops of the waves on a Surf Board and scrambling their edge with coasteering.
Browse the Bundle

Historic Heights

Reaching the summit of a mountain is a magnificent achievement and reaching the peak of 8 mountains can be a lifetime feat few have achieved. Some of the Earth’s highest mountains are at the bottom of the sea but this challenge will see you conquer those peaks stretching to the skies. Are you ready for this lifetime challenge?
Browse the Bundle

Code of Chivalry

The Medieval Knight Code of Chivalry was a good way to lead your life, with 12 of the 17 entries decribing acts of chivalry rather than combat. Go back in time and experience the practices of Medieval Britain, learning skills such as Jousting, Blacksmithing or Falconry.
Browse the Bundle

Unique Sightseeing

Most of us have seen just a quarter of Britains top 50 landmarks and may have missed unique ways to experience these sites close to. Look down on Stonehenge from a Tiger Moth Plane, power past Parliament in a Powerboat on the Thames and even cycle along Roman built Hadrian’s Wall.
Browse the Bundle

Rope Away

We are lucky to live in a country offering a great natural landscape and experience extraordinary things. Soar over quarries on the fastest Zip Line in the world, climb over beautiful natural rock formations formed over millions of year and abseil down cliffs and bridges.
Browse the Bundle

On Top of Britain

Do we really know what our Island looks like? You may not know that Ben Nevis is all that remains of an ancient volcano. Standing on top of Britain’s tallest peaks opens your eyes to the scale and beauty of this island. Ready? Take on the challenge with guided climbs up Ben Nevis, the Yorkshire Peaks, Snowden and Scafell Pike.
Browse the Bundle

Pedaling To Freedom

There are journeys and experiences that are too long to walk and just wouldn’t be the same to drive. On a bicycle you can travel three times faster than walking and experience a wonderful sense of freedom and exercise. Take to the pedals and cycle Hadrian’s Wall or even cross the water and cycle from London to Paris
Browse the Bundle

Rise From The Depths

Experience Britain from Top to Bottom. Ancient Britain was a peninsula until a tsunami flooded its land-links to Europe some 8,000 years ago and you can discover this ancient world first hand. Explore below Britain with Caving, Climb it’s natural rock formations and Trek Ben Nevis, an ancient Volcano, and Britain’s highest point.
Browse the Bundle

Britain’s Military History

It’s ironic that warfare through the ages has often brought out the best in human ingenuity, skill and technological advances; whether it’s constructing Hadrian’s Wall, Medieval Combat, operating a Tank or developing and flying the Spitfire. Ancient to modern warfare is totally engrossing and you can experience it all in this bundle.
Browse the Bundle

Power The Waves

When Frenchman Jean Lenoir installed a petrol engine in a small boat in 1863 he didn’t know what he’d started! Experience the thrill of RIB Powerboating as you discover the sights of London, explore sea caves or sail up close to sea wildlife. Just feel the power as you blast over the waves.
Browse the Bundle

The Coast is Clear

As an Island we are fortunate to have extraordinary coastal experiences. Did you know Britain’s coasts are the best places in the world for being calm enough to see amazing wildlife? You can experience this for yourself as you explore the coast on a Powerboat, scramble along it with Coasteering and ride high with the Surf.
Browse the Bundle

Learn Survival Skills

You’re in decent shape and your phone has GPS but what happens if you’re injured or stranded and the batteries die? A chance to learn some key life skills if you find yourself without that digital crutch. We can survive up to six weeks without food but water and shelter are far more important. Learn these and other key survival skills.
Browse the Bundle

Wonders of Space

The mystery of space enthalls us all. Discover more at the world class National Space Centre with the UK’s largest domed 360º planetarium. Encounter a 1960’s rocket in a 42 metre Rocket Tower and real Moon Rock. Learn about the planets in our Solar System and explore the Universe, taking a trip through a wormhole and finding out about life in Space.
Browse the Bundle
Latest Bundle

Britain’s Military History

It’s ironic that warfare through the ages has often brought out the best in human ingenuity, skill and technological advances; whether it’s constructing Hadrian’s Wall, Medieval Combat, operating a Tank or developing and flying the Spitfire. Ancient to modern warfare is totally engrossing and you can experience it all in this bundle.
Browse the Bundle
Debug Message - Perch Runway 3.0.11
[48] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: [slug:category]
Using master page: /templates/pages/category.php
Page arguments:
Array
(
    [0] => /adventure
    [category] => adventure
    [1] => adventure
)
[1] SELECT * FROM perch3_pages WHERE pagePath='/category' LIMIT 1
[63] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141540
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-10-18 03:30:00' AND saleTo>'2019-10-18 03:30:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/adventure/') ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
Rescoping to perch:category
Using sub-template: /templates/shop/products/product_tags.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/adventure/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_meta.html
Missing variant.
[63] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=141540
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=141540 ORDER BY itemID ASC
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141540
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[104] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=2 ORDER BY catTreePosition ASC
[104] Using template: /templates/categories/category_main_menu.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='filters' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=3 ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/filter_menu.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='explore-main' LIMIT 1
[8] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=1 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/category' LIMIT 1
[8] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='my-experiences' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=5 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=5 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='explore-side' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[1] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='products/adventure/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_background.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=14) AND setID=2 ORDER BY catTreePosition ASC
[13] Using template: /templates/categories/category_icons.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=14 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=14) AND setID=2 ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
Rescoping to perch:category
Using sub-template: /templates/shop/products/product_tags.html
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=14 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=14) ORDER BY catTreePosition ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/get-set-to-get-wet/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/get-set-to-get-wet/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('73', '202', '996') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=202 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=202 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='202' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/historic-heights/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/historic-heights/'))
[4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('178', '151', '144', '169') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[9] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=178 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=178 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='178' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='178' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/code-of-chivalry/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/code-of-chivalry/'))
[4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('214', '427', '80', '665') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[7] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/unique-sightseeing/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/unique-sightseeing/'))
[7] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('129', '213', '721', '209', '226', '210', '1049') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/rope-away/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/rope-away/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('234', '361', '1078') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/on-top-of-britain/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/on-top-of-britain/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('129', '178', '169') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[9] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=178 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=178 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='178' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='178' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/pedaling-to-freedom/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/pedaling-to-freedom/'))
[2] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('729', '721') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/rise-from-the-depths/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/rise-from-the-depths/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('234', '1022', '296') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=234 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=234 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='234' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/britains-military-history/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/britains-military-history/'))
[4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('1054', '1024', '214', '721') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/power-the-waves/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/power-the-waves/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('996', '5', '209') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=5 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=5 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='5' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[3] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/the-coast-is-clear/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/the-coast-is-clear/'))
[3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('73', '202', '5') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[2] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=5 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=5 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='5' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/learn-survival-skills/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/learn-survival-skills/'))
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('757') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[1] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/adventure/wonders-of-space/%' OR idx.indexKey='_category' AND idx.indexValue='products/adventure/wonders-of-space/'))
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='price' AND idx.itemID IN ('1052') WHERE 1=1 AND ((idx.indexKey='status' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl GROUP BY itemID, sortval ORDER BY sortval * 1 ASC
[13] Using template: /templates/categories/category_list.html
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT main.* FROM perch3_categories main WHERE 1=1 AND (catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID!=0 AND catPath REGEXP '[[:<:]]adventure[[:>:]]') ORDER BY catID DESC LIMIT 0, 1
[13] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/categories/recent_category.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-info' LIMIT 1
[5] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=3 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=3 AND p.pagePath='/category' LIMIT 1
[5] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-account' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
Request time: 5.4692
Process time: 5.4568
Memory: 3.6783