David Benjamin

Debug Message - Perch Runway 3.1.5
[7] 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: calendar/[slug:s]
Using master page: /templates/pages/calendar.php
Page arguments: Array ( [0] => /calendar/north-shore-concert-band-trails-and-sails-show [s] => north-shore-concert-band-trails-and-sails-show [1] => north-shore-concert-band-trails-and-sails-show )
[3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/calendar' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Globals' AND (regionPage='/calendar' 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=5 AND idx.itemRev=9)) 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/_globals.html
Using sub-template: /templates/content/global/_site.html
Using sub-template: /templates/content/global/_social.html
Using sub-template: /templates/content/global/_contact.html
Using sub-template: /templates/content/global/_copyright.html
Using sub-template: /templates/content/global/_google_analytics.html
Using sub-template: /templates/content/global/_gosquared_analytics.html
[1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Concert Series'
[4] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=2) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
[4] Using template: /templates/content/_bands_css.html
[1] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Events'
[137] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=4) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
[137] Using template: /templates/content/events.html
[1] SELECT * FROM perch3_collections WHERE collectionKey='Concert Series' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collections WHERE collectionKey='Venues' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=242
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=146
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=3
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[2] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID IN (4, 3) ORDER BY r.itemOrder ASC
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[2] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID IN (3, 4) ORDER BY r.itemOrder ASC
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=6
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=7
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[137] Using template: /templates/content/_fullcalendar_output.html
[1] SELECT * FROM perch3_collections WHERE collectionKey='Concert Series' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=3
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[2] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID IN (4, 3) ORDER BY r.itemOrder ASC
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[2] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID IN (3, 4) ORDER BY r.itemOrder ASC
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=5
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=4
[4] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=2) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
[4] Using template: /templates/content/concert_series/_concert_series_menu.html
[6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/calendar' LIMIT 1
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-004', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/menu_level_one.html
[1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE (idx.collectionID=4) AND ((idx.indexKey='slug' AND idx.indexValue='north-shore-concert-band-trails-and-sails-show')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC
[1] Using template: /templates/content/events/_event_listing.html
[1] SELECT * FROM perch3_collections WHERE collectionKey='Venues' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=242
[1] SELECT * FROM perch3_collections WHERE collectionKey='Concert Series' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=2 AND ci.itemRev=r.itemRev AND ci.itemID=2
[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=5 AND idx.itemRev=9)) 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/global/_social.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Messages' AND (regionPage='/calendar' 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=27 AND idx.itemRev=68)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-02-17 02:23:27') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-02-17 02:23:27')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID HAVING count(*)=2 ORDER BY sortval ASC
Using template: /templates/content/messages/_message_output.html
[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=27 AND idx.itemRev=68)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-02-17 02:23:27') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-02-17 02:23:27') OR (idx.indexKey='showModal' AND idx.indexValue='true')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID HAVING count(*)=3 ORDER BY sortval ASC
Using template: /templates/content/messages/_modal.html
Request time: 3.0325
Process time: 3.0324
Memory: 2.9958
Array ( [type] => 8192 [message] => implode(): Passing glue string after array is deprecated. Swap the parameters [file] => /home/dh_egfc4p/dabe.lewisarts.com/perch/core/apps/content/PerchContent.class.php [line] => 352 )

Upcoming Concerts