Anti Flood Airbrick

M3AFA

The Anti-flood Airbrick is the world’s first BSI Kitemark certified airbrick to protect against flooding.

Anti Flood Airbrick

M3AFA

The Anti-flood Airbrick is the world’s first BSI Kitemark certified airbrick to protect against flooding.

It is the most efficient and effective airbrick replacement on the market. Its superior design is passive and it is self-activated by only one moving part. Designed to replace a standard airbrick it allows air to freely pass through, but under flood conditions its self-activating gate will automatically shut off.

Available Options

  • Suitable for use in listed buildings
  • Can be retro fitted or used in new build construction
  • Made from recycled polypropylene
  • Allows air to freely pass through complying with BS493:1995
  • Easy to install
  • Integrated mesh unit stops insects and debris entering

WARNING! NOT SUITABLE FOR GAS APPLIANCE VENTS!

If your property has a vent from a boiler or gas fire please consult a registered gas safe engineer.
M3 FLOODTEC AIR BRICKS ARE NOT SUITABLE UNLESS CONFIRMED BY A GAS SAFE ENGINEER.

Anti Flood Airbrick Key Points
  • Suitable for use in listed buildings
  • Can be retro fitted or used in new build construction
  • Made from recycled polypropylene
  • Allows air to freely pass through complying with BS493:1995
  • Easy to install
  • Integrated mesh unit stops insects and debris entering

WARNING! NOT SUITABLE FOR GAS APPLIANCE VENTS!

If your property has a vent from a boiler or gas fire please consult a registered gas safe engineer.
M3 FLOODTEC AIR BRICKS ARE NOT SUITABLE UNLESS CONFIRMED BY A GAS SAFE ENGINEER.

Available Options
Antiflood Airbrick Terracotta

Anti Flood Airbrick: Terracotta

£35.89

Antiflood Airbrick Buff

Anti Flood Airbrick: Buff

£35.89

Antiflood Airbrick Engineers Blue

Anti Flood Airbrick: Engineers Blue

£35.89

Antiflood Airbrick Black

Anti Flood Airbrick: Black

£35.89

Antiflood Airbrick White

Anti Flood Airbrick: White

£35.89

Quality tested & certified.

Our Anti Flood Airbrick have been thoroughly tested and checked, time and again, and proven to meet a recognized industry standard.

Tested & Certified to KM713574

Kitemark Certified to BS 851188

Technical Information

Applications
  • Can be fitted to single, double and triple airbrick apertures.
  • Can be installed in brick, concrete, stone, steel, render finished or hardwood structures across both domestic and commercial properties.
Certification
  • BSI Kitemark licensed product (KM713574). Passed the rigorous testing criteria of PAS 1188-1:2014.
  • Complies with British Standard BS493:1995 to provide ventilation under floor voids and in wall cavities: provides 2400mm² of free airflow.
Technical Information
  • Length: 210mm
  • Height: 62mm
  • Depth: 73.5mm

Excellent resistance to ozone, oxidation, ultraviolet light, corona discharge, cosmic radiation, ionising temperature of -20° to 120°.

Minimum geometric open area of 2400mm² which meets the ventilation opening requirements of 1500mm² run of opposing walls/ 500mm per m of floor area for suspended ground floors/ 500mm per m for wall cavities.

Colours

Available in the following colours:

  • Standard terracotta
  • Engineering blue
  • Buff
  • White
  • Black
Construction

Main body, insect mesh and float constructed from recycled polypropylene co-polymer with UV stabilisers.

Silicone sponge approved by the WRAS (Water Regulations Advisory Service).

Installation Instructions

Note: When installing as a retro fit product the installation time should be complete within 30 minutes per unit.

/assets/img/crunched/airbrick-installation-01-1.svg
/assets/img/crunched/airbrick-installation-02.svg
/assets/img/crunched/airbrick-installation-03.svg
/assets/img/crunched/airbrick-installation-04.svg
/assets/img/crunched/airbrick-installation-05.svg
/assets/img/crunched/airbrick-installation-06.svg
Anti Flood Airbrick -
Anti Flood Airbrick -
Anti Flood Airbrick -
Anti Flood Airbrick -
Anti Flood Airbrick -
Anti Flood Airbrick -
  1. Locate airbrick to be replaced.
  2. Starting at a corner, drill through the mortar with the power drill, drill the holes along the mortar surrounding the airbrick.
  3. Grind out the mortar around the airbrick or break out with hammer and chisel.
  4. Once the airbrick is loose, remove from the wall and ensure that there is no mortar obstructing the corners. Clean aperture with brush.
  5. As certain the front of the brick (marked Front) and ensure it’s the correct way up (marked with an arrow up). This should be facing to the front, the spacers are situated on the bottom. Mix a mortar of sand, cement and PVA, wet the aperture with water, insert the Anti-Flood Airbrick and point around ensuring that the full bed of mortar is achieved across the depth of the brick (use the lip on the rear edge of the brick to ensure mortar is installed to the correct depth) paying attention to the type of mortar and the style of pointing. The face of the brick should sit flush with the wall.

    NOTE: It is absolutely imperative that the airbrick is installed with the utmost care, ensuring that all pointing is faultless. Remember, if water can get in, it will.
  6. Remove film sticker to complete the installation.

    NOTE: Ensure that the mortar is completely dry before the screw front face of the airbrick is removed for maintenance inspection, allow minimum seven days to fully cure.

    NOTE: Double (or triple) airbricks can be replaced with two (or three) airbrick replacements placed one on top of the other and aligned with the mortar joints of the two (or three) courses of bricks.
  7. The 8mm lip on the bottom rear edge of the brick can be removed using a hack saw to ensure the top brick sits comfortably above the lower brick.
Anti Flood Airbrick

Related Items

Anti Flood Airbrick
Available in 5 standard colours

Anti Flood Airbrick

The Anti-flood Airbrick is the world’s first BSI Kitemark certified airbrick to protect against flooding.

Anti Flood Airbrick
Available in 5 standard colours
  • Suitable for use in listed buildings
  • Can be retro fitted or used in new build construction
  • Made from recycled polypropylene
  • Allows air to freely pass through complying with BS493:1995
  • Easy to install
  • Integrated mesh unit stops insects and debris entering

WARNING! NOT SUITABLE FOR GAS APPLIANCE VENTS!

If your property has a vent from a boiler or gas fire please consult a registered gas safe engineer.
M3 FLOODTEC AIR BRICKS ARE NOT SUITABLE UNLESS CONFIRMED BY A GAS SAFE ENGINEER.

Buy Online

Anti Flood Airbrick
Available in 5 standard colours

Buy Online

Flood Defender Barrier
Virtually Invisible Fixings

Flood Defender Barrier

The system is easily deployed and lightweight, but robust. Specially designed extrusions provide optimal sealing for reliable flood resilience.

Flood Defender Barrier
Virtually Invisible Fixings
  • A range of different fixings are available making for easy deployment
  • Lightweight yet strong
  • Easy to install
  • Bespoke to suit each situation
  • Virtually invisible fixings
  • Choice of heights, up to maximum 1000mm

View details

Flood Defender Barrier
Virtually Invisible Fixings

View details

Flood Defender UPVC Doors

Flood Defender UPVC Doors

The Flood Defender Door is a highly engineered flood defence product.

Flood Defender UPVC Doors

The Flood Defender Door can be manufactured as a bespoke item to a variety of widths and heights, and can incorporate both fully glazed panels as well as full or part PVC panels. Widths beyond a double patio door size can be incorporated by the inclusion of PVC or glazed side panels. 

  • NOW AVAILABLE WITH A LOW THRESHOLD

View details

Flood Defender UPVC Doors

View details

BSI Flood Protection Kitemark KM713574
ISO 9001 Quality Management
SSIP
Constructionline
Fensa
Chas Elite
Hereford & Worcestershire Chamber of Commerce
Leaders Council
CPA
Parlimentary Review
Chas
Accoya
Bimstore
Site by Kingsford

Flood Checker

Debug Message - Perch Runway 3.1.7
[99] 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: shop/products/[slug:product]
Using master page: /templates/pages/shop/product/products.php
Page arguments:
Array
(
    [0] => /shop/products/anti-flood-airbrick-m3afa
    [product] => anti-flood-airbrick-m3afa
    [1] => anti-flood-airbrick-m3afa
)
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[55] 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=1804107
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1804107
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-03 03:20:00' AND saleTo>'2025-09-03 03:20:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/product_name.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/product_brand.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/product_sku.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='brandID' AND idx2.indexKey='title' AND idx.itemID IN ('1') WHERE 1=1 AND ((idx.indexKey='brandID' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, brandID ) as tbl WHERE (brandDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/brands/brand_image.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/views/accent_colour.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_description.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only.html
Using template: /templates/pages/attributes/default.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/og_image.html
Using template: /templates/pages/attributes/og_image.html
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1804107
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1804107
[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=1804107
Tax mode: exc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1804107 ORDER BY itemID ASC
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/contact_address_schema.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/shop/products' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only.html
[1] SELECT * FROM perch3_shop_products WHERE productSlug='anti-flood-airbrick-m3afa' AND productDeleted IS NULL LIMIT 1
[54] 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='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[33] 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='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[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='title' AND idx.itemID IN ('1', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '3', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '4', '40', '41', '42', '44', '45', '46', '47', '48', '49', '5', '50', '51', '54', '56', '57', '59', '6', '60', '7', '9') AND idx.itemID NOT IN ('1', '10', '11', '12', '13', '14', '15', '16', '19', '20', '21', '22', '23', '24', '25', '26', '27', '30', '31', '49', '50', '51', '52', '53', '54', '55', '56', '59', '60', '61', '7', '8', '9') WHERE 1=1 AND ((idx.indexKey='parentID' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[5] Using template: /templates/shop/products/variant_list_thumbs.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/price_block.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/price_block.html
[1] SELECT * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[5] SELECT * FROM perch3_shop_products WHERE parentID IN ('1') AND productDeleted IS NULL
[1] Using template: /templates/shop/products/views/product_view.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/product_banner.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/standard_pricing_inline.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/dropdown_pricing.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/product_image.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/product_options_dynamic.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/price_block_inline.html
Rescoping to perch:shop
Using sub-template: /templates/content/_blocks/shop_blocks.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/standard.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/ici.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/composite_door_quote.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/upvc_door_quote.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/flood_barrier_quote.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/flood_wall_quote.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/quotes/wooden_gate_quote.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/price_block_inline.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/price_block_inline.html
Rescoping to perch:shop
Using sub-template: /templates/content/_blocks/benefits.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/how_it_works_list.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/how_it_works_grid.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/fixing_types_table.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/fixing_types_illustrations.html
Rescoping to perch:shop
Using sub-template: /templates/content/_blocks/image_for_text_image.html
Rescoping to perch:shop
[5] Using sub-template: /templates/content/_blocks/image_for_text_image.html
[1] SELECT * FROM perch3_kingsford_shop_options WHERE `optionID`='1' AND `valueID`='1'
[1] SELECT * FROM perch3_kingsford_shop_options WHERE `optionID`='1' AND `valueID`='2'
[1] SELECT * FROM perch3_kingsford_shop_options WHERE `optionID`='1' AND `valueID`='3'
[1] SELECT * FROM perch3_kingsford_shop_options WHERE `optionID`='1' AND `valueID`='4'
[2] SELECT * FROM perch3_kingsford_shop_options WHERE `optionID`='1' AND `valueID`='5'
------------------------------ Related Products ------------------------------
[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='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='anti-flood-airbrick-m3afa')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/product.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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
Rescoping to perch:shop
Using sub-template: /templates/content/_blocks/shop_blocks.html
Rescoping to perch:shop
Using sub-template: /templates/content/_blocks/shop_blocks.html
[7] SELECT catID, catPath FROM perch3_categories
[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='title' WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue IN ('anti-flood-airbrick-m3afa', 'anti-flood-airbrick-covers-m3abcs', 'flood-defender-barrier-m3fdb', 'flood-defender-upvc-doors-fdupvc'))) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[3] Using template: /templates/shop/products/views/related_items.html
Rescoping to perch:shop
Using sub-template: /templates/shop/products/views/product_block.html
[5] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=1 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=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[5] 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
[5] 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='1' 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 pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/case-studies' OR pageSortPath='/case-studies' LIMIT 1
[37] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-014%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/the-hurt-arms' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=553 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/low-threshold-commercial-properties' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=547 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/jm-construction-riverside-leeds' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=571 AND idx.itemRev=1)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/bayer-environmental-science' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=517 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/heritage-timber-doors' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=523 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/ashbys-of-kingsbridge' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=565 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/morpeth-mansion' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=541 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=116 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/double-timber-doors' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=529 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/greet-primary-school-birmingham' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=511 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=110 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/upvc-bespoke-door-london' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=559 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/timber-door-bewdley' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=477 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/merrythought-village-ironbridge' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=471 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/corinthia-hotel-london' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=407 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/longden-coleman-shrewsbury' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=493 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/tadcaster-medical-centre' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=503 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=108 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/legal-general-modular-homes' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=487 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=105 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/barnes-cafe-sunderland' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=463 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/chestnut-homes-boston' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=248 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/elland-wharf-yorkshire' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=209 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/grace-college-gateshead' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=413 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/the-boat-house-eaton-hall' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=179 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/worcester-west-midlands' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=214 AND idx.itemRev=9)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/york-guildhall' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=219 AND idx.itemRev=13)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/ross-on-wye' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=243 AND idx.itemRev=11)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/lidl-oban-scotland' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=35 AND idx.itemRev=20)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/lamberhurst-kent' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=40 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=31 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/two-castles-housing' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=124 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=45 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/halesowen-west-midlands' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=128 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/london-imperial-college' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=198 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/mr-bailey-east-riding' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=238 AND idx.itemRev=9)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/aberdeen-city-council-aberdeen' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=253 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/french-door-devon' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=401 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/great-wyrley-staffordshire' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=425 AND idx.itemRev=1)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/st-ledger-doncaster' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=437 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] SELECT * FROM perch3_pages WHERE pageID=95 LIMIT 1
[1] Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/flood-retaining-walls' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=443 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/nrv-install' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=449 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-m3afa')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-m3afa'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only_formatted.html
Using template: /templates/pages/attributes/hide_enquiry.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[13] Using template: /templates/content//_contact_details/accreditations.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/tel_email.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/address_only.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/address_only_repeater_limited.html
[10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
[10] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1
[4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/socials.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
Request time: 0.0879
Process time: 0.0875
Memory: 2.5733
Array
(
    [type] => 8192
    [message] => implode(): Passing glue string after array is deprecated. Swap the parameters
    [file] => /home/m3floodtec/webapps/m3floodtec-com/kpanel/core/apps/content/PerchContent.class.php
    [line] => 352
)