Steel Flood & Security Door

M3SFSD

Manufactured in the UK, the Steel Flood & Security Door is designed to offer secure protection against flood and unauthorised entry.

Steel Flood & Security Door

M3SFSD

Manufactured in the UK, the Steel Flood & Security Door is designed to offer secure protection against flood and unauthorised entry.

Steel Flood & Security Door

Highly versatile and cost effective, it is the ideal solution for unmanned or remote locations, such as utility sites, where high security levels are required.

Get a quotation

Provides 24/7 protection
Holds two Kitemark certifications to PAS 1188-1:2014
Can be designed and manufactured for use on both single and double doors (outward opening) to a variety of widths and heights
Acts as a standard steel door in all other aspects including security and escape
Can incorporate glazed or louvre panels as well as fixed or removable overhead steel panels or overhead transom doors
Manufactured from 1.5mm galvanised steel, zintec treated to prevent corrosion

Steel Flood & Security Door Key Points

Provides 24/7 protection
Holds two Kitemark certifications to PAS 1188-1:2014
Can be designed and manufactured for use on both single and double doors (outward opening) to a variety of widths and heights
Acts as a standard steel door in all other aspects including security and escape
Can incorporate glazed or louvre panels as well as fixed or removable overhead steel panels or overhead transom doors
Manufactured from 1.5mm galvanised steel, zintec treated to prevent corrosion

Certified

Kitemark certified to the maximum BSI Kitemark of 900mm. Designed to mitigate against rising flood water to the full height of the door

Security Level 2

Manufactured in line with Security Level (SR) 1 with option to upgrade to SR 2

Bespoke Sizes

Manufactured to bespoke widths and heights

Escape Hatch

Option for an integral escape hatch above flood level allowing access & egress without compromising flood proof integrity

Glazing & Finishes

Wide variety of glazing options & finishes available above flood level

Colours

Full range of RAL colours available

Non-Porous Finishes

Available in a variety of non-porous textured coastal grade finishes

Guaranteed

1 year manufacturer’s guarantee

Technical Information

Applications

The Nemef Z1749/09/42 multi point lock is a sash lock with two dead bolts, incorporating top and bottom inter locking rods which throw the top and bottom deadlocks simultaneously when the key is operated.

The Exidor 703B/30 is a CE marked locking system, three point panic bolt for outward opening single door only. The unit is operated by a forward thrust of the crossbar to give a speedy exit in panic situations. Surface mounted anti thrust latch bolt and bottom bolt to prevent physical attack.

The Exidor 710 is supplied either with or without cylinder, and has the advantage that a high security master keyed 45mm half Euro profile cylinder can be used. Suitable for use with the Exidor 700 series, this OAD is manufactured from stainless steel which helps prevent force and drill attack, and incorporates cylinder protection to prevent manipulation. Great for high security applications.

Handles

The handles are manufactured from stainless steel.

Seals

The door seals are co-extruded with EPDM onto steel, which provides a reinforced seal.

Threshold

The flood door has a small threshold which is required in order to create the seal.

With a standard un-sunken door, the threshold is 101mm (shown right).

To reduce the effect, the threshold can be reduced to 63mm on a door cast up to finished floor level, or if it is chased into the ground.

Maintenance

Tailored maintenance packages are available dependent on usage.

Steel Flood & Security Door Downloads

Download File...

Steel Flood & Security Door: Request a Quotation

If you would like to receive a free quotation, please start a new quotation by clicking the button below.

Start New Quotation... or Call us on: 01905 676467

Your Details

Your Name*

Your Email*

Telephone*

1st Line of Address

Town

Post Code

Your Enquiry

Provide us with brief details of your enquiry:

Submitting your details lets us know that you are happy to receive communication from us and that you have also read our privacy statement. You can opt out of these communications at any time.

Please tick the above box to enable the form.

Related Case Studies

View all Case Studies >

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/steel-flood-fire-security-door-m3sfsd
    [product] => steel-flood-fire-security-door-m3sfsd
    [1] => steel-flood-fire-security-door-m3sfsd
)

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

[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-16 15:53:00' AND saleTo>'2025-09-16 15:53: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='steel-flood-fire-security-door-m3sfsd')) 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] 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=1832480

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

Tax mode: exc

[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1832480 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='*')

[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='steel-flood-fire-security-door-m3sfsd' 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=12)) 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 ('12') 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

[1] 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 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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='*')

[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=463 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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=100 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='/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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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='*')

[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=219 AND idx.itemRev=13)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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=61 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/ross-on-wye' 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=243 AND idx.itemRev=11)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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=65 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/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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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=198 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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=57 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/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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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 ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('steel-flood-fire-security-door-m3sfsd'))) 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

[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

[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.1591

Process time: 0.1591

Memory: 2.3552

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
)

Steel Flood & Security Door

Manufactured in the UK, the Steel Flood & Security Door is designed to offer secure protection against flood and unauthorised entry.

Steel Flood & Security Door

Manufactured in the UK, the Steel Flood & Security Door is designed to offer secure protection against flood and unauthorised entry.

Steel Flood & Security Door

Steel Flood & Security Door Key Points

Certified

Security Level 2

Bespoke Sizes

Escape Hatch

Glazing & Finishes

Colours

Non-Porous Finishes

Guaranteed

Technical Information

Applications

Handles

Seals

Threshold

Maintenance

Steel Flood & Security Door Downloads

Steel Flood & Security Door: Request a Quotation

Your Details

Your Name*

Your Email*

Telephone*

1st Line of Address

Town

Post Code

Your Enquiry

Related Case Studies

Greet Primary School

Barnes Cafe, Sunderland

York Guildhall

Ross-On-Wye

London Imperial College