Flood Defender Wall

M3FDW

The Flood Defender Wall is a demountable flood barrier system suitable to span wide apertures and is quick and easy to install.

Flood Defender Wall

M3FDW

The Flood Defender Wall is a demountable flood barrier system suitable to span wide apertures and is quick and easy to install.

Flood Defender Wall

Specially designed extrusions provide optimal sealing for reliable flood mitigation. This system is easily deployed and is lightweight, but robust. It can span any width, using a series of demountable posts, and the side rails have the option of being powder coated to match the exterior.

Get a quotation

Suitable for coastal, freshwater and brackish water conditions.
Specialist fixtures to ensure parts have a long life span.
Suitable for disabled access.
Integrated ID tags on each barrier for easy identification during deployment.

Flood Defender Wall Key Points

Suitable for coastal, freshwater and brackish water conditions.
Specialist fixtures to ensure parts have a long life span.
Suitable for disabled access.
Integrated ID tags on each barrier for easy identification during deployment.

Quality tested & certified.

Our Flood Defender Wall 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

Efficient Operation

Integrated ID tags on each barrier for easy identification during deployment

Invisible

Virtually invisible fixings

Coastal & Inland

Suitable for coastal, estuarine & riverine environments

Guaranteed

2 year manufacturer’s guarantee

Long Life

Specialist fixtures to ensure parts have a long life span

Bespoke Sizes

Any width, choice of heights up to max 1200mm

Non-Obstructive

Suitable for disabled access and allows vehicles to pass over without causing damage

Easy Deployment

Can be deployed with speed in emergency flood situations by one person

Technical Information

Applications

Suitable for use in industrial, commercial and residential settings
Building entrances including shop frontages
Garages and loading bays
Car park entrances
Full ringed protection around high value assets
Both coastal frontages and river bank protection

Sizing

Can span any width, using a series of demountable posts
Can be manufactured up to a maximum protection height of 1.2m (subject to survey)

Threshold

The defender wall uses a reversed C channel into the ground. This provides optimal protection as the barrier is sealed against a level threshold
The dead level threshold makes it ideal for disabled access, prevents tripping and allows vehicles to drive over the threshold without causing damage

Maintenance

Tailored maintenance packages are available dependent on usage

Construction

Barrier (Flood Defender Barrier) - Lightweight engineered flood board. Each single board has a specialist aluminium channel extruded for strength and top handles for ease of use. The seals are extremely efficient semi-open EPDM rubber seals which form an effective barrier
Socket/base plate - Manufactured from galvanised mild steel. The sockets come with two options dependent on ground conditions, circular for sites with good ground conditions and rectangular for areas with poor ground conditions. The socket is cast into the floor below ground leaving only the flip lid visible. The socket acts as an anchor for the post to transfer any impact loadings into the ground
Demountable posts - Manufactured from aluminium, the posts sit in a socket that is cast in to floor level. The post is demountable so when the Flood Defender Wall is not in use it is stored in a nearby location. The post is designed to easily bolt to the sockets. It’s also specially design to allow the barriers to easy slot into position. The posts can be powder coated on client’s request
Connections - All fixings used on the barrier, posts and sockets are stainless steel, so they are long lasting and hardwearing
Tools - Tools required for deployment are supplied with the Defender Wall upon initial installation

Flood Defender Wall

Flood Defender Wall Downloads

Flood Defender Wall Technical Doc

Download File...

Related Items

Flood Defender Barrier

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

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

View details

Related Case Studies

View all Case Studies >

Hereford & Worcestershire Chamber of Commerce

Site by Kingsford

Flood Checker

Debug Message - Perch Runway 3.1.7

[99] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC

Matched route: shop/products/[slug:product]

Using master page: /templates/pages/shop/product/products.php

Page arguments:

Array
(
    [0] => /shop/products/flood-defender-wall-m3fdw
    [product] => flood-defender-wall-m3fdw
    [1] => flood-defender-wall-m3fdw
)

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

[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-15 04:36:00' AND saleTo>'2025-09-15 04:36: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='flood-defender-wall-m3fdw')) 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=1828299

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

Tax mode: exc

[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1828299 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='flood-defender-wall-m3fdw' 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=9)) 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 ('9') 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 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 ('flood-defender-barrier-m3fdb'))) 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

[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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

Using template: /templates/content//_case_studies/case_study_cameos.html

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/tadcaster-medical-centre' OR regionPage='*')

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=503 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

[1] SELECT * FROM perch3_pages WHERE pageID=108 LIMIT 1

[1] Using template: /templates/content//_case_studies/case_study_cameos.html

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/legal-general-modular-homes' OR regionPage='*')

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

[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=35 AND idx.itemRev=20)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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=30 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/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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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 ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-wall-m3fdw')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-wall-m3fdw'))) 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.0689

Process time: 0.0685

Memory: 2.3654

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
)

Flood Defender Wall

The Flood Defender Wall is a demountable flood barrier system suitable to span wide apertures and is quick and easy to install.

Flood Defender Wall

The Flood Defender Wall is a demountable flood barrier system suitable to span wide apertures and is quick and easy to install.

Flood Defender Wall

Flood Defender Wall Key Points

Quality tested & certified.

Efficient Operation

Invisible

Coastal & Inland

Guaranteed

Long Life

Bespoke Sizes

Non-Obstructive

Easy Deployment

Technical Information

Applications

Sizing

Threshold

Maintenance

Construction

Flood Defender Wall

Flood Defender Wall Downloads

Flood Defender Wall: Request a Quotation

Your Details

Your Name*

Your Email*

Telephone*

1st Line of Address

Town

Post Code

Flood Wall Details

Upload Sketch Detail:

Protection

Additional Works

Type of Opening

Type of opening to be protected:

Wall Details

Post Socket Type:

Type of Dig:

Left Hand Rail Fix:

Right Hand Rail Fix:

Do Rails Require Stand Off Packers:

Type of Aluminium Required:

CAT Scanned for Services:

Drainage Assessed:

Can equal panels be installed level:

Related Items

Flood Defender Barrier

Related Case Studies

Tadcaster Medical Centre

Lidl, Oban, Scotland