Anti Flood Airbrick Covers

M3ABC

The Airbrick Cover is compact to store and takes only minutes to install.

Anti Flood Airbrick Covers

M3ABC

The Airbrick Cover is compact to store and takes only minutes to install.

The new M3Floodtec Airbrick cover has been designed to cover single or double airbricks and can provide protection from flooding having been tested to BS 851188-2019.

Size:

325mm x 180mm overall

Stock: In Stock

The airbrick cover is suitable to provide flood protection to any type of airbrick that is either flush fitting or recessed into the face of the building wall and is suitable for vents up to 280mm x 140mm in size.

Cost effective solution to stop ingress of water
Takes minutes to install after first application
Available in standard terracotta

Anti Flood Airbrick Covers Key Points

Cost effective solution to stop ingress of water
Takes minutes to install after first application
Available in standard terracotta

The M3 Floodtec Airbrick cover is a purpose manufactured enclosure with water seal that is designed for temporary surface mounting to an existing Airbrick fixed to an external wall. The Airbrick cover should be bolted into place in accordance with the fixing instructions prior to the onset of a flood event such that the existing airbrick is sealed prior to any flood water reaching the level of the existing airbrick.

The cover is not a permanent fixture. Once the flood condition has passed and the waters have drained away the airbrick cover should be removed so as to let air flow into the building through the existing airbrick. Failure to remove the cover may result in potential damp issues inside the building.

Quality tested & certified.

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

Tested by BSI to the new British Standard BS 851188

Technical Information

BSI Standards

The Airbrick cover has a certificated BSI Kitemark number KM713574 and meets the requirements of BS 851188:2019. M3 Floodtec Airbrick Covers are tested in accordance with the requirements of BS 851188:2019 to a flood depth of 600mm.

Leakage Rates

The amount of water passing the cover when installed correctly should be no greater than 10ml per air brick per hour in accordance with BS 851188:2019 500ml/h/m.

Dimensions

Length: 325mm x Height: 180mm

Construction

Produced from aluminium sheet and closed cell EPDM foam.
Closed cell structure makes it impermeable to air and water.

Cleaning, drying and storage

Following use in a flood event the airbrick cover should be removed, cleaned by washing in clean water, left to dry then stored in a suitable safe place ready for future deployment.

Safety Precautions

The Airbrick cover will work as designed so long as both of the fixings are installed and the securing handwheel nuts are tightened as far as possible- these will be sufficient tightened by hand- Spanners are not required. Always make sure that the washers are installed correctly.

Check and inspect the inner foam seal before installing the cover plate, if damaged contact M3Floodtec for advice before deployment.

Make sure the existing Airbrick is clean and free from obstructions and protrusions before fixing.

Once installed and in the event of a flood condition do not attempt to remove the airbrick cover or access the flood water, this is dangerous and could place you in a position of drowning.

Risk Assessment

The use and deployment of any flood defence product should be considered in the context of the building relative to the risk of possible flooding. Single products alone may not give adequate protection to the whole building. It is therefore recommended that a full flood risk survey is undertaken to assess where flooding may ingress into the building and as such what measures should be deployed.

Flood risk surveys should be undertaken by properly trained and accredited surveyors, for details of approved Companies contact the Environment Agency web site www.gov.uk/government/organisations/environment-agency

The M3 Floodtec Airbrick cover is designed as a temporary cover to fix over existing airbricks that are part of a general building’s fabric. They can be installed into existing masonry airbricks but must not be used on Steel air vents or existing plastic airbricks.

The product is designed to be installed before a flood event happens and then removed after the flood has passed. The product is not designed as a permanent flood prevention fixture and attempting to fix the air brick cover during a flood event is not recommended.

If deployed correctly the product will protect against a prolonged flood however permanent deployment in a submerged condition is not recommended. If this condition is a potential expert advice should be sought to consider taking the airbrick out of potential risk.

Maintenance Procedures

General Maintenance is not required on this product apart from a general wash in clean water after using in flood conditions.

Durability

The M3 Floodtec Airbrick cover is designed for multiple deployments and should last for 25 years plus if looked after. The product only requires a general clean after use and can be stored in a garage or store room under normal conditions indefinitely.

Other Information

The Airbrick cover is a manually installed product and once in position will remain static. There is no automatic function with the product. The Anchor sleeves are installed into the existing airbrick and once installed remain in position permanently for future use.

The products designation as a Manual, reusable product there is no automation associated with this product.

There is no requirement for periodic testing for this product.

The Airbrick cover can be used on any existing masonry airbrick regardless of what type of building the airbrick is installed in.

The Airbrick cover is manufactured from aluminium and polyurethane. Disposal of the product at end of life is non hazardous and recommendation is for recycling at a scrap metal or local Council disposal site.

The Airbrick cover is designed for deployment in flood conditions, this by definition will have a degree of polluted water and this will not affect the performance of the product under normal conditions. The product is designed for general flood and sea water flooding conditions.

If the product is being proposed for installation in locations where high levels of aggressive chemicals are present expert advice from your Flood risk surveyor should be sought prior to deployment.

Troubleshooting

The following checks are recommended

Check sleeve anchors are in place
Check for obstructions & remove
Check inside seal for rips
Check washers are in place

If the cover is not sealing, remove clean surfaces and replace.

Installation Preparation

The Airbrick can be installed against any existing masonry, brick, plastic, or metal air grillage providing that the opening is no greater than 280mm x 140mm. The existing air brick must be clean and free from loose material and obstructions as should the surrounding wall face.

The pointing to the brick or masonry around the airbrick must be in good condition and not cracked or broken, if this is evident, please contact M3Floodtec at sales@m3floodtec.com.

A minimum 20mm is required around the airbrick on all 4 sides as this provides the area around which the cover will seal.

Pre-Flood Deployment installation

The equipment pack contains the following:

1 x Airbrick cover plate
2 x Plastic handle thumb screws
2 x Rubber Washers
2 x Nutcert wall anchors
1 x 10mm Masonry drill
1 x Drill hole Template
Fitting Instructions
Maintenance Instructions

1. Position the drill template to the wall so that it is roughly central to the airbrick and such that the 2 holes are equidistant from the centre of the airbrick on the horizontal axis making sure that the alignment of the holes are level across the airbrick.

2. Fix the template to the wall with tape.

3. Mark the position of the 2 holes with a pencil or chalk onto the wall face.

4. Remove the template.

5. Using the drill bit provided drill 2 holes into the wall to a depth of 45mm

6. Insert the nutsert into the hole and using a light hammer drive the nutsert into the hole until flush with the face of the wall

7. Fit the cover inserting the thumb screws through the rubber washer then the holes in the cover and screw into Nutcerts on both sides. (DO Not Over Tighten as this may move the nutcert)

Post Flood Removal

1. Unscrew the thumb screws and remove complete with rubber washer to both sides of the cover plate.

2. Clean with water using a mild detergent.

3. Leave to dry then place cover plate thumb screws and rubber washers in storage

IMPORTANT! This product must be removed once the threat of flood has subsided to allow normal, free airflow. Failure to remove may result in potential damp issues.

Related Items

Anti Flood Airbrick

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

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

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-covers-m3abc
    [product] => anti-flood-airbrick-covers-m3abc
    [1] => anti-flood-airbrick-covers-m3abc
)

[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=1821995

[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-12 18:57:00' AND saleTo>'2025-09-12 18:57: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-covers-m3abc')) 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

[1] Using template: /templates/shop/products/product_brand.html

[1] Using template: /templates/shop/products/product_sku.html

[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] Using template: /templates/shop/products/views/accent_colour.html

[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] Using template: /templates/content/_contact_details/site_description.html

[1] Using template: /templates/content/_contact_details/tel_only.html

Using template: /templates/pages/attributes/default.html

[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=1821995

[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=1821995

Tax mode: exc

[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1821995 ORDER BY itemID 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] Using template: /templates/content/_contact_details/tel_only.html

[1] SELECT * FROM perch3_shop_products WHERE productSlug='anti-flood-airbrick-covers-m3abc' 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

[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='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=54)) 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

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

[nil] SELECT * FROM perch3_shop_products WHERE parentID IN ('54') 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

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

[4] Using sub-template: /templates/content/_blocks/image_for_text_image.html

------------------------------ Related Products ------------------------------

Using template: /templates/shop/products/product.html

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

[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='title' WHERE 1=1 AND ((idx.indexKey='productSlug' AND idx.indexValue IN ('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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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='*')

[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=541 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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='*')

[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=511 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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='*')

[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=503 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/legal-general-modular-homes' 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=487 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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='*')

[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=40 AND idx.itemRev=6)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/two-castles-housing' 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=124 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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

[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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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

[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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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='*')

[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=437 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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/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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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-covers-m3abc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('anti-flood-airbrick-covers-m3abc'))) 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] Using template: /templates/content/_contact_details/site_name.html

[1] Using template: /templates/content/_contact_details/tel_only_formatted.html

Using template: /templates/pages/attributes/hide_enquiry.html

[13] Using template: /templates/content//_contact_details/accreditations.html

[1] Using template: /templates/content//_contact_details/tel_email.html

[1] Using template: /templates/content//_contact_details/address_only.html

[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] 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.0767

Process time: 0.0762

Memory: 2.3224

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
)