Flood Defender Composite Doors

FDCD

The advantage of the Composite Door range is its flexibility.

A Rated Energy Efficient

Flood Defender Composite Doors

FDCD

The advantage of the Composite Door range is its flexibility.

Flood Defender Composite Doors

The advantage of the Composite Door range is its strength, flexibility and thermal efficiency. Whilst every door has been designed to provide superior flood protection, customers can personalise their finished look by combining door style,glass choice, side panels, door furniture and colour to suit their individual property.

All of our glass panels are triple glazed. External facing glass is clear. Internal facing glass is available in a clear, sanitised, Minster or Stippolyte finish. Sanitised glass designs are only available with a clear internal facing glass finish.

  • Kitemark certified to BS 851188-1:2019
  • Double rebate, high strength structure
  • Superior quality seals
  • A energy efficiency rating
  • Triple glazing in a range of glass options
  • A choice of 11 attractive woodgrain colour finishes
  • NOW AVAILABLE WITH A LOW THRESHOLD
Flood Defender Composite Doors Key Points
  • Kitemark certified to BS 851188-1:2019
  • Double rebate, high strength structure
  • Superior quality seals
  • A energy efficiency rating
  • Triple glazing in a range of glass options
  • A choice of 11 attractive woodgrain colour finishes
  • NOW AVAILABLE WITH A LOW THRESHOLD

Quality tested & certified.

Our Flood Defender Composite Doors have been thoroughly tested and checked, time and again, and proven to meet a recognized industry standard.

Tested & Certified to KM713574

Tested by BSI to the new British Standard BS 851188

Door Designs

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

Please note: Maximum door only size - 997mm x 2181mm. Minimum door only size - 869mm x 1941m

Darrington Solid

Shown in Agate Grey with frosted side panels*.

*Surcharges apply for patterned glazing in side panels.

Darrington One

Shown in Green with TG10 Glass option & side panels*.

*Surcharges apply for patterned glazing in side panels.

Darrington Two

Shown in Anthracite with TG8 Glass option & side panels*.

*Surcharges apply for patterned glazing in side panels.

Teeside Solid

Shown in Anthracite with TG98 glass option* side panels.

*Surcharges apply for patterned glazing in side panels.

Teeside One

Shown in Red with TG100 glass option* side panels.

*Surcharges apply for patterned glazing in side panels.

Ganton One

Shown in Black with TG41 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Ganton Two

Shown in Blue with TG91 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Wheatley Solid

Shown in Green with TG23 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Wheatley One

Shown in Blue with TG8 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Lindrick

Shown in Blue with Minster glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Northcliffe

Shown in Black with TG65 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Northcliffe

Shown in Rosewood with TG53 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Fulford

Shown in Blue with TG8 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Strensall

Shown in Chartwell with TG99 glass option* & side panels.

*Surcharges apply for patterned glazing in side panels.

Door Colours

We have a premium range of colours available.

Metallic Colours are not available. RAL colours are not available.

White

Woodgrain Texture

Cream

Woodgrain Texture

Red

Woodgrain Texture

Blue

Woodgrain Texture

Black

Woodgrain Texture

Light Oak

Woodgrain Texture

Rosewood

Woodgrain Texture

Green

Woodgrain Texture

Chartwell

Woodgrain Texture

Anthracite

Woodgrain Texture

Glass Designs

Each door design has a unique range of glass to chose from, but if you are looking for something to fit with existing glazing or obscured glass you can chose from our range of backing glass designs. Side Panels are available in Stippolyte / Minster / Cotswold / Autumn or Clear glass as standard, patterned glazing is available at additional cost. Contact our sales team for more information.

Minster

Stippolyte

Cotswold

Autumn

Door Furniture

Choose from black, chrome, gold or white finishes.

Lever

Letterplates

Knocker A

Flood Defender Doors

Flood Defender Composite Doors: Request a Quotation

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

Your Details

Composite Door Details

Door cannot be less than 882mm wide without add-ons.
Door cannot be less than 1959mm high without add-ons.
Open In / Out:
Hinged Left / Right:
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:
Hinge Colour:
Door Colour Exterior:
Door Colour Interior:
Internal Pattern:
Letterplate:
Knocker:
Numbers:
Door Alarm:
Door Bell:
(JPG or PDF Only)

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

Please tick the above box to enable the form.

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

Flood Checker

Debug Message - Perch Runway 3.1.7
[99] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: shop/products/[slug:product]
Using master page: /templates/pages/shop/product/products.php
Page arguments:
Array
(
    [0] => /shop/products/flood-defender-composite-doors-fdcd
    [product] => flood-defender-composite-doors-fdcd
    [1] => flood-defender-composite-doors-fdcd
)
[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=1810729
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1810729
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2025-09-08 00:52:00' AND saleTo>'2025-09-08 00:52: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-composite-doors-fdcd')) 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] 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-composite-doors-fdcd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/product_brand.html
[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-composite-doors-fdcd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/product_sku.html
[1] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='brandID' AND idx2.indexKey='title' AND idx.itemID IN ('1') WHERE 1=1 AND ((idx.indexKey='brandID' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, brandID ) as tbl WHERE (brandDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/brands/brand_image.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='products' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=1 ORDER BY catTreePosition ASC
Using template: /templates/categories/category_title.html
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='flood-defender-composite-doors-fdcd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/products/views/accent_colour.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage LIKE '%' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_description.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only.html
Using template: /templates/pages/attributes/default.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/og_image.html
Using template: /templates/pages/attributes/og_image.html
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1810729
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1810729
[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=1810729
Tax mode: exc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1810729 ORDER BY itemID ASC
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/contact_address_schema.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='I am looking for menu' AND (regionPage='/shop/products' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only.html
[1] SELECT * FROM perch3_shop_products WHERE productSlug='flood-defender-composite-doors-fdcd' 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=26)) 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
[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-composite-doors-fdcd')) 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
[nil] SELECT * FROM perch3_shop_products WHERE parentID IN ('26') 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
[2] Using sub-template: /templates/content/_blocks/image_for_text_image.html
------------------------------ Related Products ------------------------------
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='flood-defender-composite-doors-fdcd')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/product.html
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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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='*')
[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=565 AND idx.itemRev=3)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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=120 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/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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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='*')
[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=209 AND idx.itemRev=10)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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=59 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/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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/lidl-oban-scotland' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=35 AND idx.itemRev=20)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/london-imperial-college' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=198 AND idx.itemRev=8)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/great-wyrley-staffordshire' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=425 AND idx.itemRev=1)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE (regionKey='Case Study Intro') AND (regionPage='/case-studies/st-ledger-doncaster' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=437 AND idx.itemRev=2)) AND ((idx.indexKey='accessories_0' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) 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-composite-doors-fdcd')) OR (idx.indexKey='accessories_1' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_2' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_3' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_4' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_5' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_6' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd')) OR (idx.indexKey='accessories_7' AND idx.indexValue IN ('flood-defender-composite-doors-fdcd'))) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content//_case_studies/case_study_cameos.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/tel_only_formatted.html
Using template: /templates/pages/attributes/hide_enquiry.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[13] Using template: /templates/content//_contact_details/accreditations.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/tel_email.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/address_only.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/address_only_repeater_limited.html
[10] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
[10] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1
[4] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-018%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=6 AND idx.itemRev=35)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/socials.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=288 AND idx.itemRev=41)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/_homepage/looking_for_menu.html
[51] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/products' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-012-003', '000-012', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/main_nav.html
[10] Using template: /templates/navigation/sub_nav.html
Request time: 0.104
Process time: 0.1035
Memory: 2.6643
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
)