Flood Defender UPVC Doors

FDUPVC

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

Flood Defender UPVC Doors

FDUPVC

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

Visually and functionally, in non flood conditions, the door performs as a ‘standard’ PVC door.

The door features a number of sophisticated internal components enabling the door to perform as a flood proof door to mitigate against rising flood waters up to a height of 600mm.

Get a quotation

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

NOW AVAILABLE WITH A LOW THRESHOLD

Flood Defender UPVC Doors Key Points

NOW AVAILABLE WITH A LOW THRESHOLD

Quality tested & certified.

Our Flood Defender UPVC Doors 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

The Door Range

We have a contemporary range of UPVC Defender Door styles to suit your individual requirements.

Legacy

Optional Glass
Min Width: 826mm
Min Height: 1910mm
Max Width: 1050mm
Max Height: 2100mm

Sandman

Optional Glass
Min Width: 826mm
Min Height: 1865mm
Max Width: 1050mm
Max Height: 2100mm

Weatherly

Optional Glass
Min Width: 802mm
Min Height: 2015mm
Max Width: 1050mm
Max Height: 2100mm

Nikita

Optional Glass
Min Width: 826mm
Min Height: 1865mm
Max Width: 1050mm
Max Height: 2100mm

Woodstock

Optional Glass
Min Width: 670mm
Min Height: 1750mm
Max Width: 1050mm
Max Height: 2100mm

Sappho

Optional Glass
Min Width: 826mm
Min Height: 1750mm
Max Width: 1050mm
Max Height: 2100mm

Highlander

Optional Glass
Min Width: 826mm
Min Height: 1870mm
Max Width: 1050mm
Max Height: 2100mm

Nirvana

Optional Glass
Min Width: 790mm
Min Height: 1750mm
Max Width: 1050mm
Max Height: 2100mm

French Door

Optional Glass
Min Width: 1200mm
Min Height: 1750mm
Max Width: 1800mm
Max Height: 2100mm

Glass Options

Choose from clear glass or our four backing glass options*

*Side Panels are available in Stippolyte / Minster / Cotswold / Autumn or Clear glass only.

Stippolyte

Available for all door designs

Cotswold

Available for all door designs

Autumn

Available for all door designs

Minster

Available for all door designs

Door Colours

Choose from 9 woodgrain colour finishes*.

Door frames are available in white finish as standard.

*Metallic Colours are not available.

White

Smooth

Cream

RAL 9001

Red

RAL 3011

Blue

RAL 5011

Black

RAL 8022

Oak

Green

RAL 6009

Chartwell

Anthracite

RAL 7016

Rosewood

Door Furniture

Choose from black, chrome, gold or white finishes.

Lever

Letterplates

Knocker A

Flood Defender UPVC Doors

Flood Defender UPVC Doors Downloads

UPVC Door Brochure 2022/23

Download File...

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-upvc-doors-fdupvc
    [product] => flood-defender-upvc-doors-fdupvc
    [1] => flood-defender-upvc-doors-fdupvc
)

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

[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-14 02:10:00' AND saleTo>'2025-09-14 02:10: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-upvc-doors-fdupvc')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC

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

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

Tax mode: exc

[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1825304 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-upvc-doors-fdupvc' 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=27)) 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 ('27') 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 ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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='*')

[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=547 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=117 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/jm-construction-riverside-leeds' 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=571 AND idx.itemRev=1)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=121 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/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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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='*')

[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=559 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=119 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/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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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 ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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 ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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='*')

[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=248 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=66 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/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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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='*')

[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=214 AND idx.itemRev=9)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=60 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/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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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='*')

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

[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=128 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=46 LIMIT 1

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

[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=401 AND idx.itemRev=4)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=87 LIMIT 1

[1] 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=425 AND idx.itemRev=1)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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=91 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/st-ledger-doncaster' OR regionPage='*')

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

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

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

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

[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=443 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-upvc-doors-fdupvc'))) 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.0964

Process time: 0.0959

Memory: 2.5766

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 UPVC Doors

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

Flood Defender UPVC Doors

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

Flood Defender UPVC Doors Key Points

Quality tested & certified.

The Door Range

Glass Options

Door Colours

Door Furniture

Flood Defender UPVC Doors

Flood Defender UPVC Doors Downloads

Flood Defender UPVC Doors: Request a Quotation

Your Details

Your Name*

Your Email*

Telephone*

1st Line of Address

Town

Post Code

UPVC Door Details

Open In / Out:

Hinged Left / Right (If double door master will be as marked):

Sill: (please note that a sill will remove 30mm (35mm for 180mm sill) from door height)

Frame Packers (please note that adding packers will decrease the door size):

Top:

Left:

Right:

Handle Colour:

Georgian Bar:

Lead (please provide design):

Letterplate:

Knocker:

Numbers:

Door Alarm:

Door Bell:

Related Case Studies

Low Threshold, Commercial

JM Construction, Riverside, Leeds

UPVC Bespoke Door, London

Chestnut Homes Ltd, Boston

Worcester, West Midlands

Ross-On-Wye

Halesowen, West Midlands

French Door, Devon

Great Wyrley, Staffordshire

St Ledger, Doncaster