Corporate Experiences

Your Interest

Up to Price (£0 to £500+)

£

Unique Team Building

More in Unique Team Building →

Indoor Corporate Events

More in Indoor Corporate Events →

Outdoor Team Building

More in Outdoor Team Building →
Latest Bundle

Enhance Your Corporate Image

How we present ourselves can reflect our abilities and make a statement about our competence, professionalism and creativity. Learn about your natural colouring, build & style personality to portray the image you want and feel confident when choosing clothes.
NUMBERS: 6+ People
DURATION: 1.5 to 3 Hours
BENEFITS: Confidence Building, Team Building & Development, Corporate Entertainment
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] => /corporate
    [category] => corporate
    [1] => corporate
)
[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=141555
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141555
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-10-18 03:59:00' AND saleTo>'2019-10-18 03:59: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/corporate/') 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/corporate/') 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=141555
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141555
[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=141555
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=141555 ORDER BY itemID ASC
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141555
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141555
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141555
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141555
[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/corporate/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_background.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=177) AND setID=2 ORDER BY catTreePosition ASC
[3] Using template: /templates/categories/category_icons_corporate.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=177) 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
[105] SELECT catID, catPath FROM perch3_categories
[4] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=52) ORDER BY catTreePosition 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/corporate/unique-team-building/jousting-tournament/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/unique-team-building/jousting-tournament/'))
[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 ('1786') 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/corporate/unique-team-building/forge-team-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/unique-team-building/forge-team-challenge/'))
[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 ('1787') 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/corporate/unique-team-building/excavate-a-medieval-city/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/unique-team-building/excavate-a-medieval-city/'))
[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 ('1788') 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/corporate/unique-team-building/enhance-your-corporate-image/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/unique-team-building/enhance-your-corporate-image/'))
[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 ('1789') 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
[4] Using template: /templates/categories/category_carousel_list.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/corporate/unique-team-building/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_list_title.html
[11] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=148) ORDER BY catTreePosition 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/corporate/indoor/private-brewery-tour/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/private-brewery-tour/'))
[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 ('2001') 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/corporate/indoor/london-job-treasure-hunt-in-classic-minis/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/london-job-treasure-hunt-in-classic-minis/'))
[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 ('2012') 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/corporate/indoor/escape-game-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/escape-game-challenge/'))
[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 ('2017') 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/corporate/indoor/take-on-the-british-bake-off-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/take-on-the-british-bake-off-challenge/'))
[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 ('2022') 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/corporate/indoor/can-you-survive-a-night-of-murder-mystery-dining/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/can-you-survive-a-night-of-murder-mystery-dining/'))
[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 ('2021') 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/corporate/indoor/crystal-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/crystal-challenge/'))
[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 ('2024') 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/corporate/indoor/bring-the-house-down-in-casino-royale/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/bring-the-house-down-in-casino-royale/'))
[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 ('2019') 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/corporate/indoor/the-apprentice/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/the-apprentice/'))
[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 ('2025') 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/corporate/indoor/film-making-team-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/film-making-team-challenge/'))
[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 ('2023') 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/corporate/indoor/forge-team-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/forge-team-challenge/'))
[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 ('1787') 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/corporate/indoor/enhance-your-corporate-image/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/enhance-your-corporate-image/'))
[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 ('1789') 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
[11] Using template: /templates/categories/category_carousel_list.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/corporate/indoor/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_list_title.html
[14] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=149) ORDER BY catTreePosition 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/corporate/outdoor/wet-and-wild-gorge-walking/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/wet-and-wild-gorge-walking/'))
[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 ('2004') 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/corporate/outdoor/conquer-the-seas-in-your-own-rib/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/conquer-the-seas-in-your-own-rib/'))
[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 ('2014') 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/corporate/outdoor/team-caving-in-subterranean-world/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/team-caving-in-subterranean-world/'))
[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 ('2002') 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/corporate/outdoor/team-abseil-in-beautiful-natural-terrain/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/team-abseil-in-beautiful-natural-terrain/'))
[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 ('2006') 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/corporate/outdoor/bushcraft-survival-2-day-and-night-team-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/bushcraft-survival-2-day-and-night-team-challenge/'))
[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 ('2011') 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/corporate/outdoor/chase-across-the-sea-and-discover-treasure/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/chase-across-the-sea-and-discover-treasure/'))
[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 ('2013') 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/corporate/outdoor/climb-the-mighty-ben-nevis-as-a-team/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/climb-the-mighty-ben-nevis-as-a-team/'))
[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 ('2007') 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/corporate/outdoor/rock-climbing-to-the-top/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/rock-climbing-to-the-top/'))
[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 ('2003') 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/corporate/outdoor/take-on-the-three-peaks-challenge/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/take-on-the-three-peaks-challenge/'))
[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 ('2009') 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/corporate/outdoor/your-own-jousting-tournament/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/your-own-jousting-tournament/'))
[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 ('1786') 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/corporate/outdoor/excavate-a-medieval-city/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/excavate-a-medieval-city/'))
[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 ('1788') 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/corporate/outdoor/private-flight-in-your-own-hot-air-balloon/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/private-flight-in-your-own-hot-air-balloon/'))
[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 ('2015') 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/corporate/outdoor/relive-the-good-old-days-with-a-school-sports-day/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/relive-the-good-old-days-with-a-school-sports-day/'))
[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 ('2018') 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/corporate/outdoor/its-a-knockout/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/its-a-knockout/'))
[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 ('2020') 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
[14] Using template: /templates/categories/category_carousel_list.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/corporate/outdoor/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_list_title.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 '[[:<:]]corporate[[:>:]]') ORDER BY catID DESC LIMIT 0, 1
[32] 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: 3.5701
Process time: 3.5668
Memory: 3.2758