SELECT * FROM london_stages WHERE eventid IN (4015, 4020, 4021, 4023, 4024, 4025, 4029, 4030, 4032, 4035, 4041, 4042, 4047, 4048, 4059, 4095, 4115, 4135, 4190, 4203, 4228, 13825, 14828, 14864, 15607, 15798, 15840, 15915, 15919, 15923, 15927, 15931, 15938, 15990, 16012, 16025, 16101, 16129, 16147, 16151, 16156, 16160, 16164, 16168, 16172, 16176, 16186, 16190, 16194, 16200, 16204, 16210, 16214, 16218, 16222, 16228, 16232, 16238, 16244, 16448, 16491, 16783, 17111, 17143, 17208, 17237, 17538, 17541, 17546, 17549, 17552, 17555, 18220, 18224, 18377, 18380, 18383, 18559, 18659, 18665, 18675, 18684, 18774, 18781, 18805, 24455, 24458, 24461, 24467, 24469, 24654, 24691, 24774, 24778, 24894, 24896, 24905, 24909, 24953, 24998, 25001, 25003, 25006, 25008, 25010, 25012, 25015, 25017, 25020, 25022, 25024, 25026, 25029, 25031, 25035, 25040, 25047, 25053, 25055, 25059, 25061, 25072, 25086, 25088, 25094, 25096, 25106, 25123, 25128, 25131, 25134, 25138, 25140, 25143, 25148, 25159, 25192, 25197, 25206, 25213, 25227, 25232, 25237, 25275, 25331, 25332, 25337, 25342, 25344, 25346, 25348, 25350, 25352, 25354, 25356, 25358, 25360, 25362, 25364, 25375, 25387, 25393, 25395, 25407, 25411, 25413, 25418, 25425, 25433, 25441, 25471, 25473, 25475, 25479, 25487, 25548, 25550, 25552, 25576, 25582, 25592, 25595, 25597, 25601, 25604, 25607, 25609, 25618, 25620, 25622, 25631, 25633, 25655, 25660, 25680, 25686, 25688, 25702, 25721, 25749, 25752, 25761, 25766, 25774, 25824, 25829, 25831, 25833, 25836, 25838, 25840, 25842, 25850, 25852, 25854, 25857, 25863, 25867, 25873, 25884, 25886, 25889, 25939, 25954, 25959, 25969, 26032, 26075, 26080, 26091, 26094, 26125, 26135, 26158, 26180, 26182, 26184, 26194, 26196, 26198, 26203, 26205, 26207, 26211, 26217, 26219, 26294, 26434, 26487, 26592, 38606, 38622, 38632, 38637, 38647, 38651, 38661, 38666, 39116, 39126, 39738, 39748, 39752, 39762, 39767, 39779, 39784, 39795, 39800, 39810, 39816, 40277, 40287, 40290, 40299, 40303, 40313, 40318, 40328, 40332, 40342, 40347, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40776, 40780, 40783, 40786, 40794, 40796, 40802, 40806, 40811, 40812, 40814, 40818, 40820, 40823, 40826, 40836, 40840, 40841, 40847, 40850, 40851, 40854, 40861, 40864, 40867, 40869, 40875, 40879, 40881, 40883, 40901, 40952, 40969, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Afterpiece Title: The Music from Bonduca; Dryden's Ode for St

Music: As17810307

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Afterpiece Title: The Music from Bonduca; Dryden's Ode for St

Music: As17810302

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Music: As17810307

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Music: As17810302

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Monody to the Memory of Mr Garrick; Dryden's Ode for St

Music: As17810307

Song: In Oratorio: Verdi Prati-a Young Gentleman (1st appearance in public [unidentified])

Performances

Mainpiece Title: Acis And Galatea; Alexander's Feast

Music: As17810302

Song: End Oratorio: My Heart is inditing [from Coronation Anthems]-; with several capital songs [selected from Handel's Works-; [to conclude with the Grand Coronation Anthem God save the King-Norris, Reinhold, Miss Linley, Miss Draper, Miss Prudom

Performances

Mainpiece Title: The Messiah

Music: End Part I: concerto on the organ, as17810302

Performances

Mainpiece Title: The Messiah

Music: End Part I: concerto on the hautboy, as17810307End Part II: concerto on the violin, as17810302

Song: As17810328