Concerts.

The concerts of our 67th season.
  1. Home
  2. Concerts
  3. Brahms, Dvořák & Déjardin
Brahms, Dvořák & Déjardin
Subscription Series Concert

Brahms, Dvořák & Déjardin Concert

Saturday, May 16, 2020, 7:30pm, Manchester Essex RHS

Sunday, May 17, 2020, 2:00pm, Manchester Essex RHS

Brahms returns to us with his powerful Symphony No. 1 which he struggled for 14 years to complete. And we close the season with Dvořák’s gorgeous Cello Concerto featuring Blaise Déjardin, Principal Cellist of the Boston Symphony Orchestra.

  • BRAHMS Symphony No. 1
  • DVORAK Cello Concerto, Blaise Déjardin, Cello

Strasbourg-born cellist Blaise Déjardin was appointed principal cello of the Boston Symphony Orchestra by BSO Music Director Andris Nelsons in spring 2018, having joined the BSO's cello section in 2008. Previously, Déjardin was a member of the European Union Youth Orchestra and the Gustav Mahler Jugendorchester. He was a founding member of the Boston-based string orchestra A Far Cry, and in 2010 he founded the acclaimed Boston Cello Quartet with three BSO colleagues. He has arranged numerous pieces for cello ensembles, earning four ASCAP Plus Awards and receiving commissions from Yo-Yo Ma, the Boston Symphony Orchestra, and A Far Cry. In 2013 he launched Opus Cello, his online sheet music publishing company. He has served as artistic director of the Boston Cello Society since its creation in 2015. Mr. Déjardin has performed as soloist with orchestra around the world. In 2008 he gave the U.S. premiere of French composer Edith Canat de Chizy's Formes du vent for solo cello. A dedicated chamber musician, he spent two summers at Ravinia's Steans Institute for Young Artists. He holds a first prize in Cello with highest honors from the Conservatoire National Supérieur de Musique of Paris, as well as a master of music diploma and a graduate diploma from the New England Conservatory in Boston. His main teachers were Philippe Muller, Laurence Lesser, and Bernard Greenhouse. Mr. Déjardin made his debut with orchestra at age fourteen performing Haydn's C major concerto at the Corum in Montpellier, France. Among his numerous awards and honors, he was awarded first prize at the Maurice Gendron International Cello Competition and was also the youngest prizewinner at the 6th Adam International Cello Competition in New Zealand. In 2007 he made his Paris recital debut at Le Petit Palais as a laureate of the program Declic supporting emerging young soloists in France. He has taught privately and at the New England Conservatory and Tanglewood Music Center.

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

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.04820 [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.05260.0044Matched route: concerts/[slug:concert]
0.05260.0001Using master page: /templates/pages/concerts.php
0.05260Page arguments: 
Array
(
    [0] => /concerts/brahms-dvorak-djardin-2020c4
    [concert] => brahms-dvorak-djardin-2020c4
    [1] => brahms-dvorak-djardin-2020c4
)
0.05880.0062 [1] SELECT * FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.06510.0063 [68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.06610.0009 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.06640.0003INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')
0.06750.0011 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020390
0.06780.0002 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020390
0.06820.0005 [nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:19:00' AND saleTo>'2026-01-12 17:19:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.07020.0019 [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='brahms-dvorak-djardin-2020c4')) 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.080.0098 [1] Using template: /templates/shop/products/concert.html
0.08020.0002 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.08130.0011 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.08260.0013 [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.0830.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='541' 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.08380.0008 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.08410.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='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.08860.0045 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.08940.0008 [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.09040.001 [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=22
0.09160.0012 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0920.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.11170.0197 [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.11440.0027 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.11640.002 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.11760.0012 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.11820.0007 [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.11880.0006 [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='541' 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.11980.0009 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.12010.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='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.12060.0005 [20] SELECT catID, catPath FROM perch2_categories
0.12160.001 [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.12260.001 [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:19:19') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:19:19')) 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.12850.0059Using template: /templates/shop/products/products_navigation.html
0.12860.0001 [15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.12920.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.12950.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.12990.0004Using template: /templates/navigation/navigation-main.html
0.130 [7] Using template: /templates/navigation/navigation-main-2.html
0.13180.0019------------------------------ Calculating cart ------------------------------
0.13180 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020390
0.13490.003 [1] SELECT * FROM perch2_shop_cart WHERE cartID=1020390
0.13540.0006 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.13570.0003 [1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.13610.0003 [1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.13660.0006 [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
0.13710.0005 [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020390
0.13760.0005Tax mode: exc
0.13770.0001 [nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020390 ORDER BY itemID ASC
0.13910.0015Using template: /templates/shop/cart/mini.html
0.13960.0005Using template: /templates/pages/attributes/description.html
0.13990.0003 [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='brahms-dvorak-djardin-2020c4')) 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.14410.0042 [1] Using template: /templates/shop/products/concert.html
0.14440.0003 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.14510.0006 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.14550.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.14590.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='541' 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.14660.0007 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.1470.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='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.14870.0018 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.1490.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.14960.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=22
0.15060.0011 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.1510.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.15320.0022 [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.15470.0015 [2] SELECT * FROM perch2_categories ORDER BY catTreePosition ASC
0.16070.006 [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='brahms-dvorak-djardin-2020c4')) 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.16720.0065 [1] Using template: /templates/shop/products/concert_microformat.html
0.16740.0002 [8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.16770.0003 [2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.1680.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.16820.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='541' 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.16860.0004 [2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.16890.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='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.16980.0009 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.17020.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.17070.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=22
0.17110.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.17190.0009 [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.17240.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=22
0.17280.0004 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.17320.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.17370.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=22
0.17430.0006 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.17460.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.17510.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=22
0.17570.0005 [1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.1760.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.17650.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.17730.0008 [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.17820.0009 [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.17950.0013Using template: /templates/shop/products/1-column-listing_special_bar_event.html
0.17980.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.18060.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.18530.0047 [3] Using template: /templates/shop/products/3-column-listing_special_bar.html
0.18570.0004 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=433 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18620.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.18660.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.18680.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.18780.0009 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=436 AND productDeleted IS NULL ORDER BY productOrder ASC
0.18840.0006 [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.18890.0006 [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.18940.0005 [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.19070.0013 [2] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=439 AND productDeleted IS NULL ORDER BY productOrder ASC
0.19120.0005 [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.19170.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.19210.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.19310.001 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/concerts' OR regionPage='*')
0.19340.0003 [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.19990.0065 [10] Using template: /templates/content/sponsors/_footer_logos.html
0.20210.0022Using template: /templates/mailchimp/subscribe_email_address.html
0.20290.0008 [7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.20350.0006 [1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/concerts' LIMIT 1
0.20380.0003 [1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003', '000') ORDER BY pageTreePosition DESC
0.20450.0007 [7] Using template: /templates/navigation/navigation-footer.html
0.2050.0005Using cart from cache.
0.2050.0001Using template: /templates/shop/cart/your_cart.html
0.20530.0003 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/concerts' OR regionPage='*')
0.20580.0005 [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.20920.0034 [1] Using template: /templates/content/globals/_phone_number.html
0.20950.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.21260.0031 [1] Using template: /templates/content/globals/_email_address_main.html
0.21290.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.21490.002 [1] Using template: /templates/content/globals/_social_footer.html
0.21550.0006 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/concerts' OR regionPage='*')
0.21580.0003 [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:19:19') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:19:19') 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.21660.0008Using template: /templates/content/messages/_modal.html
0.21680.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.21740.0006Using template: /templates/content/messages/_message_output.html
0.21750.0002Request time: 0.2175
0.21760Process time: 0.217
0.21760Memory: 2.0608
0.21760
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
)