Concerts.

The concerts of our 67th season.
  1. Home
  2. Concerts
  3. Classics and the Movies
Classics and the Movies
Subscription Series Concert

Classics and the Movies Concert

Saturday, September 28, 2019, 7:30pm, Manchester Essex RHS

Sunday, September 29, 2019, 2:00pm, Ipswich High School

It’s a myth declared by some that Hollywood music can’t be classical. We present true classics used in movies as well as true contemporary classics created for Hollywood.

  • Wagner The Ride of the Valkyries
  • Prokofiev Lieutenant Kije
  • Rózsa Ben Hur Suite
  • Korngold Robin Hood Suite
  • Williams Close Encounters of the 3rd Kind
  • Williams Star Wars

Venue Information

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

Ipswich High School

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

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

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.00120 [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.00430.0031Matched route: concerts/[slug:concert]
0.00440Using master page: /templates/pages/concerts.php
0.00440Page arguments: 
Array
(
    [0] => /concerts/classics-and-the-movies-2020c1
    [concert] => classics-and-the-movies-2020c1
    [1] => classics-and-the-movies-2020c1
)
0.00460.0002 [1] SELECT * FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.00560.001 [68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.00620.0006 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.00640.0003INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')
0.00760.0011 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020392
0.00790.0003 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020392
0.00820.0003 [nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:20:00' AND saleTo>'2026-01-12 17:20:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.00880.0007 [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='classics-and-the-movies-2020c1')) 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.0170.0082 [1] Using template: /templates/shop/products/concert.html
0.01740.0004 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.01850.0011 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0190.0005 [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.01970.0007 [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='563' 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.02060.0009 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0210.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='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.02310.0021 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.02360.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.02450.0008 [2] 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.02610.0016 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.02640.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=22
0.02840.002 [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.02970.0013 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.03130.0016 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.03180.0005 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.03220.0004 [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.03250.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='563' 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.03310.0006 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.03350.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='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.03410.0007 [20] SELECT catID, catPath FROM perch2_categories
0.03460.0005 [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.03580.0011 [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:20:39') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:20:39')) 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.0390.0032Using template: /templates/shop/products/products_navigation.html
0.03910.0001 [15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.03950.0004 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.03970.0002 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.040.0003Using template: /templates/navigation/navigation-main.html
0.04010 [7] Using template: /templates/navigation/navigation-main-2.html
0.0410.0009------------------------------ Calculating cart ------------------------------
0.0410 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020392
0.04140.0004 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020392
0.04160.0002 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.04180.0002 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.0420.0002 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.04230.0002 [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
0.04270.0005 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020392
0.04310.0003Tax mode: exc
0.04310 [nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020392 ORDER BY itemID ASC
0.04340.0003Using template: /templates/shop/cart/mini.html
0.04360.0002Using template: /templates/pages/attributes/description.html
0.04380.0002 [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='classics-and-the-movies-2020c1')) 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.04840.0046 [1] Using template: /templates/shop/products/concert.html
0.04850.0002 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.04880.0003 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.04910.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.04930.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='563' 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.04970.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.04990.0002 [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='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.05080.0009 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0510.0002 [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.05140.0003 [2] 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.05230.001 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.05260.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=22
0.05410.0015 [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.05620.0022 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.05820.002 [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='classics-and-the-movies-2020c1')) 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.06420.006 [1] Using template: /templates/shop/products/concert_microformat.html
0.06450.0003 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0650.0005 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.06530.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.06560.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='563' 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.0660.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.06630.0002 [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='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.06730.001 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.06770.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.06830.0006 [2] 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.06880.0005 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.06910.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=22
0.06970.0006 [2] 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.07030.0006 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.07060.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=22
0.07110.0005 [2] 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.07170.0005 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0720.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=22
0.07250.0005 [2] 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.0730.0005 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.07330.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=22
0.07370.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.07440.0007 [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.07520.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 ('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.07630.0011Using template: /templates/shop/products/1-column-listing_special_bar_event.html
0.07660.0003 [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.07730.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.08150.0042 [3] Using template: /templates/shop/products/3-column-listing_special_bar.html
0.08180.0002 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=433 AND productDeleted IS NULL ORDER BY productOrder ASC
0.08220.0004 [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.08260.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.08280.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.08360.0008 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=436 AND productDeleted IS NULL ORDER BY productOrder ASC
0.08390.0004 [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.08430.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.08460.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='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.08530.0007 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=439 AND productDeleted IS NULL ORDER BY productOrder ASC
0.08580.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.08620.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.08660.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='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.08760.001 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/concerts' OR regionPage='*')
0.0880.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.09420.0062 [10] Using template: /templates/content/sponsors/_footer_logos.html
0.09590.0016Using template: /templates/mailchimp/subscribe_email_address.html
0.09670.0008 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.09740.0007 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.09780.0004 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.09840.0006 [7] Using template: /templates/navigation/navigation-footer.html
0.0990.0007Using cart from cache.
0.09910.0001Using template: /templates/shop/cart/your_cart.html
0.09950.0004 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/concerts' OR regionPage='*')
0.09990.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.10210.0022 [1] Using template: /templates/content/globals/_phone_number.html
0.10250.0003 [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.10420.0017 [1] Using template: /templates/content/globals/_email_address_main.html
0.10450.0003 [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.10610.0016 [1] Using template: /templates/content/globals/_social_footer.html
0.10650.0004 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/concerts' OR regionPage='*')
0.1070.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:20:39') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:20: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
0.10810.0011Using template: /templates/content/messages/_modal.html
0.10830.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.10910.0008Using template: /templates/content/messages/_message_output.html
0.10920.0002Request time: 0.1092
0.10920Process time: 0.1091
0.10930Memory: 1.4417
0.10930
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
)