BACK TO ALL EXPERIENCES

A LEGEND IN THE MAKING

CULTURE & CRAFTS EXPERIENCE DAYS
Explore the rich history of Britain, follow in the footsteps of Men and Women who carved our traditions and way of life and gain skills in an artisan craft or the Performing Arts.

For Your Home

We’d all love to make beautiful objects for our home and know they were unique and personal to us, To feel proud that we’d gained a new skill and an insight into professional crafts, practiced for thousands of years. We may even choose to take it further as a new career. Choose from blacksmithing and woodworking to creative glass.
Browse the Bundle

Dig Up History

Britain is rich with archeological sites and Wales alone has over 600 castles. That’s more castles per square mile than any other country in the world. If you want to learn and practice archaeology and touch and see history first hand, discovering objects last seen and touched 100’s of years ago, then this is the bundle for you.
Browse the Bundle

Iconic Vintage Trains

The first trains were pulled by ropes, horses or gravity with trains now reaching 260mph. Celebrate our rail heritage and enjoy stunning views and fine dining on some of Britains most famous trains, from steam hauled engines to a Murder Mystery on the Belmond British Pullman, Sister Train to the Venice Simplon-Orient-Express.
Browse the Bundle

Unforgettable Shows and Theatre

For thousands of years we’ve loved live theatre, it’s transported us to another world, amazed us, inspired us and made us laugh or cry. We’ve handpicked for this bundle, performances that are uniquely special – whether it’s the world famous Minack Theatre, perched high on the cliffs overlooking the sea or an exciting and innovative new show where you can dine and meet the cast.
Browse the Bundle

Ancient Crafts

The word ‘Craft’ comes from the Middle English word for ‘strength’ or ‘skill’. Learn your very own strength, making your own designs by heating metal and hammering your will upon it with Blacksmithing and carving your own reality with Woodworking.
Browse the Bundle

Your Music

The joy and influence of music has been with us for as long as we can remember, with musical instruments found dating back thousands of years. If you love singing, performing or have always wanted to record your own music in a professional studio, then this bundle is for you.
Browse the Bundle

Wonders of Space

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

Britains Military History

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

A Chance To Dance

In all cultures and throughout the centuries people have loved to dance. We now learn that it’s one of the most important things we can do to keep mentally and physically fit and stay young. It’s also great fun and gives a tremendous sense of achievement!
Browse the Bundle

Unique Sightseeing

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

Live Off The Land

Experience the joys of living outdoors, learning to live like our ancestors and work with nature. Nature has sustained us for thousands of years. Find out about the wild plants around you and prepare delicious dishes or your own herbal remedies to take home.
Browse the Bundle

Code of Chivalry

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

Pedaling to Freedom

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

Live Off The Land

Experience the joys of living outdoors, learning to live like our ancestors and work with nature. Nature has sustained us for thousands of years. Find out about the wild plants around you and prepare delicious dishes or your own herbal remedies to take home.
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] => /culture-crafts
    [category] => culture-crafts
    [1] => culture-crafts
)
[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=141545
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141545
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2019-10-18 03:39:00' AND saleTo>'2019-10-18 03:39: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/culture-crafts/') 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/culture-crafts/') 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=141545
[1] SELECT * FROM perch3_shop_cart WHERE cartID=141545
[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=141545
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=141545 ORDER BY itemID ASC
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141545
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141545
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141545
[1] SELECT * FROM perch3_humdinger_vouchers WHERE voucherKey=NULL
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=141545
[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/culture-crafts/') ORDER BY catTreePosition ASC
[1] Using template: /templates/categories/category_background.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=30) AND setID=2 ORDER BY catTreePosition ASC
[13] Using template: /templates/categories/category_icons.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=30 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID=30) AND setID=2 ORDER BY catTreePosition ASC
Using template: /templates/categories/category.html
Rescoping to perch:category
Using sub-template: /templates/shop/products/product_tags.html
[13] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catParentID=30 AND catPath NOT REGEXP '[[:<:]]extra[[:>:]]' 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_list.html
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT main.* FROM perch3_categories main WHERE 1=1 AND (catPath NOT REGEXP '[[:<:]]extra[[:>:]]' AND catParentID!=0 AND catPath REGEXP '[[:<:]]culture-crafts[[:>:]]') ORDER BY catID DESC LIMIT 0, 1
[13] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/categories/recent_category.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-info' LIMIT 1
[5] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=3 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=3 AND p.pagePath='/category' LIMIT 1
[5] Using template: /templates/navigation/list_item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-account' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/category' LIMIT 1
[4] Using template: /templates/navigation/list_item.html
Request time: 0.6769
Process time: 0.6744
Memory: 3.5028