We’ve a lot going on here at CMJ here’s some of our featured events.

More Events CMJ UK
Events All Events Passover

Featured Events

The Bible Comes to Life

Debug Message - Perch 3.1.4
[55] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[13] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/events/index.php' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT * FROM perch2_pages WHERE pagePath='/events/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
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/events' OR pageSortPath='/events' LIMIT 1
[3] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-007%' ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/events/index.php' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-007', '000') ORDER BY pageTreePosition DESC
[1] Using template: /templates/navigation/new-sub.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Events' AND (regionPage='/events/index.php' OR regionPage='*')
[37] SELECT idx.itemID FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID WHERE ((idx.regionID=134 AND idx.itemRev=514)) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'featured/event%')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[10] SELECT idx.itemID FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID WHERE ((idx.regionID=134 AND idx.itemRev=514)) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'events/bible-come-to-life%')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='eventStart' WHERE ((idx.regionID=134 AND idx.itemRev=514)) AND idx.itemID IN ('137', '138', '150', '166', '181', '182', '212', '213', '214', '234', '235', '246', '257', '265', '300', '311', '313', '314', '320', '321', '322', '323', '325', '357', '358', '365', '392', '401', '402', '403', '407', '416', '417', '418', '419', '450', '452') AND idx.itemID NOT IN ('167', '168', '276', '277', '309', '311', '365', '401', '402', '403') AND ((idx.indexKey='eventFinish' AND idx.indexValue >= '2019-10-20 05:24:12')) 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/event_listing.html
[10] SELECT idx.itemID FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID WHERE ((idx.regionID=134 AND idx.itemRev=514)) AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'events/bible-come-to-life%')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='eventStart' WHERE ((idx.regionID=134 AND idx.itemRev=514)) AND idx.itemID IN ('167', '168', '276', '277', '309', '311', '365', '401', '402', '403') AND ((idx.indexKey='eventFinish' AND idx.indexValue >= '2019-10-20 05:24:12')) 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/event_listing.html
[1] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC