Would you like to be a part of one of Leicester’s leading and award winning businesses? An opportunity has arisen to work within Central Finance, heading up the Finance Operations team. Required is an experienced Finance Manager to lead, coach and develop a team of 6.
The Benefits
Consultant: Adam Flowers
Debug Message - Perch 3.1.1 |
---|
[1] SELECT * FROM perch3_pages WHERE pagePath='/jobs/af1763-finance-manager.php' LIMIT 1 |
Using template: /templates/pages/attributes/default.html |
Using sub-template: /templates/pages/attributes/seo.html |
[1] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/jobs/af1763-finance-manager.php' OR regionPage='*' ORDER BY regionPage DESC |
Using template: /templates/search/main-job-search.html |
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Job Listing' AND (regionPage='/jobs/af1763-finance-manager.php' 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=257 AND idx.itemRev=2)) 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/job-main.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=257 AND idx.itemRev=2)) 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/job-sidebar.html |
Using sub-template: /templates/content/map.html |
[1] SELECT * FROM perch3_categories ORDER BY catTreePosition 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=257 AND idx.itemRev=2)) 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/job-appform.html |
Using sub-template: /templates/forms/job_application.html |
[27] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Job Listing' AND (regionPage LIKE '/jobs/%' OR regionPage='*') |
[6] 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='j_ref' WHERE ((idx.regionID=286 AND idx.itemRev=1) OR (idx.regionID=283 AND idx.itemRev=0) OR (idx.regionID=288 AND idx.itemRev=1) OR (idx.regionID=289 AND idx.itemRev=1) OR (idx.regionID=290 AND idx.itemRev=1) OR (idx.regionID=292 AND idx.itemRev=1) OR (idx.regionID=280 AND idx.itemRev=1) OR (idx.regionID=264 AND idx.itemRev=1) OR (idx.regionID=277 AND idx.itemRev=3) OR (idx.regionID=276 AND idx.itemRev=1) OR (idx.regionID=255 AND idx.itemRev=2) OR (idx.regionID=278 AND idx.itemRev=1) OR (idx.regionID=262 AND idx.itemRev=2) OR (idx.regionID=261 AND idx.itemRev=1) OR (idx.regionID=275 AND idx.itemRev=2) OR (idx.regionID=253 AND idx.itemRev=5) OR (idx.regionID=273 AND idx.itemRev=1) OR (idx.regionID=203 AND idx.itemRev=2) OR (idx.regionID=291 AND idx.itemRev=1) OR (idx.regionID=285 AND idx.itemRev=2) OR (idx.regionID=274 AND idx.itemRev=3) OR (idx.regionID=279 AND idx.itemRev=2) OR (idx.regionID=267 AND idx.itemRev=1) OR (idx.regionID=257 AND idx.itemRev=2) OR (idx.regionID=204 AND idx.itemRev=2) OR (idx.regionID=281 AND idx.itemRev=1) OR (idx.regionID=287 AND idx.itemRev=1)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval DESC LIMIT 0, 6 |
[6] Using template: /templates/content/job-slide.html |
[2] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC |