Concerts.

The concerts of our 67th season.
  1. Home
  2. Concerts
  3. Holiday Pops
Holiday Pops
Subscription Series Concert

Holiday Pops Concert

Saturday, November 30, 2019, 2:00pm, Ipswich High School

Saturday, November 30, 2019, 7:30pm, Manchester Essex RHS

Sunday, December 1, 2019, 2:00pm, Manchester Essex RHS

Expect lots of joy and fun as we celebrate the holidays with favorites by Anderson, Bach, Herbert, Tchaikovsky, Rutter, Handel and more. And with the Cape Ann Symphony Chorus directed by Wendy Betts. We will conclude with the ever popular audience sing-along.

Venue Information

Saturday’s 2:00 pm concert

Ipswich High School

Ipswich High School, 134 High Street, Ipswich, MA 01938

Ipswich High School, 134 High Street, Ipswich, MA 01938

Saturday’s 7:30 pm concert

Manchester Essex RHS

Manchester Essex RHS, 36 Lincoln Street, Manchester-by-the-Sea, MA 01944

Manchester Essex RHS, 36 Lincoln Street, Manchester-by-the-Sea, MA 01944

Sunday’s 2:00 pm concert

Manchester Essex RHS

Manchester Essex RHS, 36 Lincoln Street, Manchester-by-the-Sea, MA 01944

Manchester Essex RHS, 36 Lincoln Street, Manchester-by-the-Sea, MA 01944

Musicians Unleashed:

An intimate series of creative and informative listening experiences.

Dance Of The Instruments
Bach To The Future
Spring Into Strings
Time Δ Debug Message - Perch Runway 3.1.2
0.00230 [43] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_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 perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
0.07940.0771Matched route: concerts/[slug:concert]
0.07940.0001Using master page: /templates/pages/concerts.php
0.07940Page arguments: 
Array
(
    [0] => /concerts/holiday-pops-2020c2
    [concert] => holiday-pops-2020c2
    [1] => holiday-pops-2020c2
)
0.07970.0002 [1] SELECT * FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.08070.001 [68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.08130.0006 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.08150.0003INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')
0.08260.0011 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020388
0.08290.0003 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020388
0.08320.0003 [nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:17:00' AND saleTo>'2026-01-12 17:17:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.0840.0008 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='holiday-pops-2020c2')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.09960.0156 [1] Using template: /templates/shop/products/concert.html
0.10020.0006 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.10130.0011 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.10190.0006 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10230.0004 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1030.0007 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.10340.0004 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.10470.0013 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.10510.0005 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.10590.0007 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.10630.0005 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.10690.0006 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.10720.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.12230.0151 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.12370.0014 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.12630.0026 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.12940.0032 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.12990.0005 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.13020.0003 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13050.0002 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13080.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.13110.0002 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.13150.0004 [20] SELECT catID, catPath FROM perch2_categories
0.13180.0004 [15] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/') OR (idx.indexKey='_category' AND idx.indexValue LIKE 'products/2019-musicians-unleashed/%' OR idx.indexKey='_category' AND idx.indexValue='products/2019-musicians-unleashed/'))
0.13270.0008 [nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('433', '436', '439', '229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='sell_until' AND idx.indexValue >= '2026-01-12 12:17:02') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:17:02')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval HAVING count(*)=2 ORDER BY sortval ASC
0.13670.004Using template: /templates/shop/products/products_navigation.html
0.13670.0001 [15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.13720.0005 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.13750.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.13780.0003Using template: /templates/navigation/navigation-main.html
0.13780 [7] Using template: /templates/navigation/navigation-main-2.html
0.13880.001------------------------------ Calculating cart ------------------------------
0.13880 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020388
0.13920.0004 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020388
0.13950.0003 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.13980.0003 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.140.0002 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.14030.0003 [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
0.14060.0002 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020388
0.14110.0005Tax mode: exc
0.14110 [nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020388 ORDER BY itemID ASC
0.14380.0027Using template: /templates/shop/cart/mini.html
0.1440.0002Using template: /templates/pages/attributes/description.html
0.14410.0001 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='holiday-pops-2020c2')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.15190.0078 [1] Using template: /templates/shop/products/concert.html
0.15230.0003 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.15280.0006 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.15310.0003 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.15340.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.15380.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.15410.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.15550.0015 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.15590.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.15640.0005 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.15680.0005 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.15760.0008 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.1580.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.16050.0025 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.16280.0023 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.16410.0013 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.16670.0025 [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='holiday-pops-2020c2')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1740.0073 [1] Using template: /templates/shop/products/concert_microformat.html
0.17440.0004 [12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.1750.0006 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.17530.0003 [4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17560.0003 [4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.1760.0004 [3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.17630.0003 [3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.17720.0009 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.17750.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.1780.0005 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.17830.0003 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.17870.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.1790.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.17930.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.17970.0004 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18010.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.18040.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.18080.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18120.0004 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18160.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.18190.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.18230.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18270.0004 [3] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18310.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.18330.0003 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.18370.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18410.0004 [1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.18460.0006 [2] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/special-event/%' OR idx.indexKey='_category' AND idx.indexValue='products/special-event/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.18540.0007 [nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('449', '450') WHERE 1=1 AND ((idx.indexKey='sell_until' AND idx.indexValue >= '2026-01-12')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.18640.0011Using template: /templates/shop/products/1-column-listing_special_bar_event.html
0.18660.0001 [3] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/2019-musicians-unleashed/%' OR idx.indexKey='_category' AND idx.indexValue='products/2019-musicians-unleashed/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.18730.0008 [3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('433', '436', '439') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.19060.0033 [3] Using template: /templates/shop/products/3-column-listing_special_bar.html
0.19090.0003 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=433 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19140.0005 [1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=433 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.19170.0003 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=18 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1920.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='433' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='18' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19280.0008 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=436 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19330.0005 [1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=436 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.19370.0005 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=18 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19410.0004 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='436' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='18' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19490.0007 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=439 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19520.0004 [1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=439 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.19560.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=18 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.19590.0003 [2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='439' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='18' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.19660.0007 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/concerts' OR regionPage='*')
0.1970.0004 [10] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=18 AND idx.itemRev=24)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.20290.0059 [10] Using template: /templates/content/sponsors/_footer_logos.html
0.20480.0019Using template: /templates/mailchimp/subscribe_email_address.html
0.20570.0009 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.20640.0007 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.20680.0004 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.20740.0006 [7] Using template: /templates/navigation/navigation-footer.html
0.20780.0004Using cart from cache.
0.20790Using template: /templates/shop/cart/your_cart.html
0.20810.0002 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/concerts' OR regionPage='*')
0.20850.0004 [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.21090.0024 [1] Using template: /templates/content/globals/_phone_number.html
0.2110.0002 [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.21230.0013 [1] Using template: /templates/content/globals/_email_address_main.html
0.21250.0002 [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.21380.0013 [1] Using template: /templates/content/globals/_social_footer.html
0.21410.0004 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/concerts' OR regionPage='*')
0.21450.0004 [nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-01-12 12:17:02') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:17:02') 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
0.21520.0007Using template: /templates/content/messages/_modal.html
0.21540.0002 [nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.21590.0005Using template: /templates/content/messages/_message_output.html
0.2160.0002Request time: 0.216
0.21610Process time: 0.2158
0.21610Memory: 1.4404
0.21610
Array
(
    [type] => 8192
    [message] => implode(): Passing glue string after array is deprecated. Swap the parameters
    [file] => /home/capeannsymphony/dev.capeannsymphony.org/perch/core/apps/content/PerchContent.class.php
    [line] => 352
)