Welcome to the CMJ blog. This is the place to come if you’re looking for news, information about what we’re up to, as well as Alex Jacob’s latest Thinking Aloud.

Debug Message - Perch 3.1.2
[50] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[1] SELECT * FROM perch2_pages WHERE pagePath='/blog/index.php' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
Using sub-template: /templates/pages/attributes/facebook.html
[12] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/blog/index.php' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-006', '000') ORDER BY pageTreePosition DESC
[12] Using template: /templates/navigation/item.html
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/blog/index.php' OR pageSortPath='/blog/index.php' LIMIT 1
[1] SELECT * FROM perch2_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-006', '000') ORDER BY pageTreePosition
[1] Using template: /templates/navigation/breadcrumbs.html
[7] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/blog/index.php' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT * FROM perch2_blog_sections WHERE sectionSlug='blog' LIMIT 1
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE ( sectionID='6' AND postStatus='Published' AND postDateTime<='2019-03-26 09:12:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10
[1] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/blog/post_in_list.html
[3] SELECT * FROM perch2_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
Using template: /templates/search/search-blog-form.html
Fetching from cache: perch_blog_categoriesef5028a584cfd31fe2ba03fbc397e1a0
[1] SELECT setID FROM perch2_category_sets WHERE setSlug='blog' LIMIT 1
[4] SELECT SQL_CALC_FOUND_ROWS DISTINCT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch2_categories main LEFT OUTER JOIN perch2_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND setID=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC LIMIT 0, 4
[7] SELECT FOUND_ROWS() AS `count`
[4] Using template: /templates/blog/category.html
Caching: perch_blog_categoriesef5028a584cfd31fe2ba03fbc397e1a0