Interested in finding a new position but not quite ready to register with us?
Let us know you're interested and our consultants will be in touch to discuss your needs.
| Debug Message - Perch 3.1.1 |
|---|
| [1] SELECT * FROM perch3_pages WHERE pagePath='/tell-us-youre-looking.php' LIMIT 1 |
| Using template: /templates/pages/attributes/default.html |
| Using sub-template: /templates/pages/attributes/seo.html |
| [3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/tell-us-youre-looking.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='Interested Form' AND (regionPage='/tell-us-youre-looking.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=32 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/_register_interest.html |
| Using sub-template: /templates/forms/telluslooking.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 |
