David Benjamin

July 17

4Ever Fab

Antonio Gentile Bandstand
Antonio Gentile Bandstand
August 11

4Ever Fab

Antonio Gentile Bandstand
Antonio Gentile Bandstand
July 12

4Ever Fab

Antonio Gentile Bandstand
Antonio Gentile Bandstand
July 16

4Ever Fab

Antonio Gentile Bandstand
Antonio Gentile Bandstand

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/4ever-fab [s] => 4ever-fab [1] => 4ever-fab )
[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
[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=4) AND ((idx.indexKey='slug' AND idx.indexValue='4ever-fab')) 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/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=7
[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=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 ( 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 <= '2025-11-08 05:07:39') OR (idx.indexKey='show_until' AND idx.indexValue >= '2025-11-08 05:07:39')) 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 <= '2025-11-08 05:07:39') OR (idx.indexKey='show_until' AND idx.indexValue >= '2025-11-08 05:07:39') 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.861
Process time: 3.8608
Memory: 2.995
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