SELECT * FROM london_stages WHERE eventid IN (22745, 29426, 36617, 36912, 36918, 36924, 36926, 36928, 36931, 36934, 36937, 36940, 36942, 36945, 36948, 36950, 36953, 36961, 36983, 36994, 37000, 38592, 38602, 38607, 38623, 38633, 38648, 38989, 38994, 38996, 38999, 39001, 39007, 39050, 39061, 39075, 39087, 39103, 39116, 39117, 39126, 39127, 39130, 39131, 39140, 39141, 39144, 39145, 39154, 39155, 39158, 39159, 39169, 39170, 39175, 39176, 39187, 39188, 39193, 39194, 39214, 39258, 39299, 39559, 39628, 39738, 39739, 39748, 39749, 39752, 39753, 39762, 39763, 39767, 39768, 39779, 39780, 39784, 39785, 39795, 39796, 39800, 39801, 39810, 39811, 39816, 39817, 40053, 40097, 40277, 40287, 40290, 40299, 40300, 40303, 40313, 40314, 40315, 40318, 40319, 40328, 40330, 40332, 40333, 40334, 40342, 40343, 40344, 40347, 40348, 40363, 40378, 40383, 40386, 40390, 40395, 40397, 40417, 40424, 40432, 40435, 40447, 40453, 40458, 40460, 40466, 40687, 40802, 40811, 40814, 40823, 40826, 40836, 40840, 40850, 40854, 40862, 40864, 40867, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 43750, 44829, 44838, 44842, 44851, 44855, 44865, 44869, 44878, 44882, 44894, 44900, 44906, 44943, 44997, 45019, 45034, 45367, 45376, 45379, 45388, 45392, 45401, 45405, 45414, 45418, 45427, 45431, 45959, 45969, 45972, 45982, 45985, 46012, 46025, 46516, 46526, 46530, 46540, 46544, 46554, 46558, 46568, 46572, 46582, 47111, 47121, 47125, 47136, 47141, 47153, 47158, 47170, 47176, 47189, 47195, 47214, 47701, 47702, 47711, 47716, 47717, 47726, 47727, 47731, 47732, 47741, 47742, 47746, 47747, 47756, 47757, 47761, 47762, 47771, 47772, 47776, 47777, 48230, 48231, 48240, 48241, 48244, 48245, 48254, 48255, 48258, 48259, 48268, 48269, 48272, 48273, 48282, 48283, 48286, 48287, 48296, 48297, 48300, 48301, 49447, 49488, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50602, 50609, 50620, 50626, 50635, 50688, 50690, 50695, 50702, 50707, 50736, 50742, 50744, 50772, 50790, 50802, 50805, 50812, 50940, 50959, 50965, 50971, 51787) 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: Joseph

Performances

Mainpiece Title: L'allegro, Il Penseroso Ed Il Moderato

Music: A Concerto on the Organ-Stanley

Performances

Mainpiece Title: Il Dilettante

Music: Between the Acts: Concerto on Piano Forte-Hook (by Particular Desire); The Ode-Hook for the opening of the New Exhibition Room of the Royal Incorporated Artists of Great Britain. Chorusses will be supported by a number of Capital singers and young gentlemen of St Paul's Choir; The principal vocal parts-Reinhold, Bannister, Mrs Cartwright, Mrs Thompson

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Commissary

Performances

Music: I: Solo on Violin-Barthelemon; II: Concerto on French Horn-Sg Spandau

Performances

Mainpiece Title: Alzuma

Afterpiece Title: Man and Wife

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Messiah; Judith

Music: I: Concerto on French Horn-Spandau; II: Concerto on Organ-Arne

Performances

Mainpiece Title: Alzuma

Afterpiece Title: Comus

Performances

Mainpiece Title: The Messiah; Judith

Music: I: Concerto on French Horn-Spandau; II: Violin solo-Barthelemon

Performances

Mainpiece Title: Alzuma

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Golden Pippin

Performances

Mainpiece Title: Samson; Judith

Music: As17730303

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Golden Pippin

Performances

Mainpiece Title: Judas Maccabaeus; Judith

Music: As17730305

Performances

Mainpiece Title: Alzuma

Afterpiece Title: The Upholsterer

Performances

Music: As17730303

Performances

Mainpiece Title: The Death Of Abel; Judith

Music: I: Concerto on French Horn-Spandau; II: Violin Concerto-Barthelemon

Performances

Mainpiece Title: The Messiah

Music: As17730303

Performances

Mainpiece Title: The Messiah

Music: As17730305

Performances

Mainpiece Title: Judas Maccabaeus

Music: First Violin-Lamotte; after I: Concerto on German Flute-Florio; Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Omnipotence; Judas Maccabaeus

Music: End Part First: A New Concerto on 3 Chromatic French Horns-(being their first performance); After Part Second: a Concerto on the Violin-Lamotte

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Music: First Violin, as17760223; End Part I: Concerto on 3 Chromatic French Horns, as17760223; End Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Samson; Judas Maccabaeus

Music: End I: Concerto on 3 Chromatic French Horns, as17760228; End II: Concerto on Violin-Lamotte