Viewing All Experiences

Your Interest

Up to Price (£0 to £500+)

£

Animals & Plants

More in Animals & Plants →

Culture & Crafts

More in Culture & Crafts →
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] => /all
    [category] => all
    [1] => all
)
[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=141570
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141570
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-10-18 04:53:00' AND saleTo>'2019-10-18 04:53: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/all/') 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/all/') 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=141570
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141570
[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=141570
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=141570 ORDER BY itemID ASC
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141570
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141570
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141570
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141570
[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/all/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_background.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[10] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=0) AND setID=2 ORDER BY catTreePosition ASC
[10] Using template: /templates/categories/category_icons.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[10] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=0 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=0) 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
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=147) ORDER BY catTreePosition ASC
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/all/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[9] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=75) ORDER BY catTreePosition 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/food-drink/just-love-british-beer/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/just-love-british-beer/'))
[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 ('216', '215') 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
[6] 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/food-drink/work-with-artisan-food-producers/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/work-with-artisan-food-producers/'))
[6] 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 ('128', '1211', '1074', '1077', '1076', '1075') 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/food-drink/tasting-the-good-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/tasting-the-good-life/'))
[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 ('1025', '215', '1011') 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/food-drink/a-chefs-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/a-chefs-life/'))
[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 ('660') 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 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/food-drink/dining-with-a-difference/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/dining-with-a-difference/'))
[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 ('221', '737') 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/food-drink/world-of-food/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/world-of-food/'))
[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 ('128', '1074', '1077') 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
[5] 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/food-drink/a-day-in-the-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/a-day-in-the-life/'))
[5] 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 ('660', '133', '132', '1045', '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
[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/food-drink/so-much-chocolate-so-little-time/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/so-much-chocolate-so-little-time/'))
[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 ('1075') 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/food-drink/live-off-the-land/%' OR idx.indexKey='_category' AND idx.indexValue='products/food-drink/live-off-the-land/'))
[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 ('750', '748', '747') 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] 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/food-drink/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 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_carousel_list.html
Rescoping to perch:category
[1] 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_carousel_all_list_title.html
[5] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=12) ORDER BY catTreePosition 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/driving/lap-of-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/driving/lap-of-life/'))
[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 ('1047', '1051') 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] 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/driving/iconic-car-road-trips/%' OR idx.indexKey='_category' AND idx.indexValue='products/driving/iconic-car-road-trips/'))
[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 ('1686', '1036', '761', '1035') 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 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/driving/tank-power/%' OR idx.indexKey='_category' AND idx.indexValue='products/driving/tank-power/'))
[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 ('1066', '1054') 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 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/driving/calling-all-campers/%' OR idx.indexKey='_category' AND idx.indexValue='products/driving/calling-all-campers/'))
[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 ('257', '747') 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/driving/day-at-the-wheel/%' OR idx.indexKey='_category' AND idx.indexValue='products/driving/day-at-the-wheel/'))
[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 ('1067') 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
[5] 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/driving/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[9] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=1) ORDER BY catTreePosition 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/animals-and-plants/working-with-animals/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/working-with-animals/'))
[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 ('141', '1026', '132', '80') 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=80 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=80 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='80' 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/animals-and-plants/gardening-at-famous-houses/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/gardening-at-famous-houses/'))
[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 ('133') 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=133 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=133 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='133' 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/animals-and-plants/ancient-crafts/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/ancient-crafts/'))
[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 ('758', '427', '420') 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=420 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=420 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='420' 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/animals-and-plants/farm-life/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/farm-life/'))
[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 ('132') 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] 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/animals-and-plants/touch-wood/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/touch-wood/'))
[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 ('758', '826', '427', '759') 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/animals-and-plants/learn-survival-skills/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/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
[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/animals-and-plants/apex-predators/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/apex-predators/'))
[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 ('1026', '80') 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=80 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=80 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='80' 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/animals-and-plants/the-coast-is-clear/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/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
[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/animals-and-plants/live-off-the-land/%' OR idx.indexKey='_category' AND idx.indexValue='products/animals-and-plants/live-off-the-land/'))
[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 ('750', '748', '747') 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] 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/animals-and-plants/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=30) 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/culture-crafts/for-your-home/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/for-your-home/'))
[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 ('435', '826', '420') 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=420 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=420 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='420' 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/culture-crafts/dig-up-history/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/dig-up-history/'))
[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 ('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
[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/culture-crafts/iconic-vintage-trains/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/iconic-vintage-trains/'))
[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 ('653', '737', '740', '712') 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/culture-crafts/unforgettable-shows-and-theatre/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/unforgettable-shows-and-theatre/'))
[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 ('221', '737', '1048') 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/culture-crafts/britains-historic-places/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/britains-historic-places/'))
[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 ('758', '427', '420') 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=420 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=420 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='420' 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/culture-crafts/your-music/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/your-music/'))
[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 ('746') 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/culture-crafts/wonders-of-space/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/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
[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/culture-crafts/britains-military-history/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/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
[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/culture-crafts/a-chance-to-dance/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/a-chance-to-dance/'))
[nil] 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 ('1037') 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
[6] 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/culture-crafts/unique-sightseeing/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/unique-sightseeing/'))
[6] 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 ('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/culture-crafts/live-off-the-land/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/live-off-the-land/'))
[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 ('750', '748', '747') 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] 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/culture-crafts/code-of-chivalry/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/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
[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/culture-crafts/pedaling-to-freedom/%' OR idx.indexKey='_category' AND idx.indexValue='products/culture-crafts/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
[13] 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/culture-crafts/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[6] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=8) ORDER BY catTreePosition 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/flying/to-the-skies/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/to-the-skies/'))
[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 ('224', '223', '225', '226') 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] 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/flying/soar-like-a-bird/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/soar-like-a-bird/'))
[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 ('407', '225', '1078', '226') 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/flying/evolution-of-flight/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/evolution-of-flight/'))
[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 ('223', '1023', '213') 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/flying/extreme-flight/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/extreme-flight/'))
[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 ('716', '407', '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
[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/flying/glide-the-skies/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/glide-the-skies/'))
[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 ('532', '225') 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 productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=532 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=532 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='532' 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
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=18 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] 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='532' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='18' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[6] 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/flying/unique-sightseeing/%' OR idx.indexKey='_category' AND idx.indexValue='products/flying/unique-sightseeing/'))
[6] 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 ('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
[6] 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/flying/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=115) 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/pamper/a-thermal-spa-beckons/%' OR idx.indexKey='_category' AND idx.indexValue='products/pamper/a-thermal-spa-beckons/'))
[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 ('982', '741', '974') 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/pamper/look-and-feel-good/%' OR idx.indexKey='_category' AND idx.indexValue='products/pamper/look-and-feel-good/'))
[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 ('982', '741', '773') 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 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/pamper/how-i-come-across/%' OR idx.indexKey='_category' AND idx.indexValue='products/pamper/how-i-come-across/'))
[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 ('778', '1045') 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] 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/pamper/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[4] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=10) 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/water/power-the-waves/%' OR idx.indexKey='_category' AND idx.indexValue='products/water/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
[6] 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/water/unique-sightseeing/%' OR idx.indexKey='_category' AND idx.indexValue='products/water/unique-sightseeing/'))
[6] 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 ('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/water/get-set-to-get-wet/%' OR idx.indexKey='_category' AND idx.indexValue='products/water/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
[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/water/the-coast-is-clear/%' OR idx.indexKey='_category' AND idx.indexValue='products/water/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
[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/water/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_list_title.html
[3] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=177) ORDER BY catTreePosition 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/corporate/unique-team-building/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/unique-team-building/'))
[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 ('1786', '1788', '1789', '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
[11] 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/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/indoor/'))
[11] 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', '2019', '2021', '1787', '2024', '2017', '2023', '2001', '2022', '2025', '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
[14] 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/%' OR idx.indexKey='_category' AND idx.indexValue='products/corporate/outdoor/'))
[14] 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', '2013', '2007', '2014', '2020', '2015', '2018', '2003', '2009', '2006', '2002', '2004', '1788', '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
[3] 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/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_carousel_all_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) ORDER BY catID DESC LIMIT 0, 1
[94] 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: 1.4422
Process time: 1.4402
Memory: 4.1328