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: The Messiah

Music: Between parts Oratorio: a Concerto on German Flute, as17760223; Violin Concerto, as17760223

Performances

Mainpiece Title: The Ascension; Judas Maccabaeus

Music: Between the parts of the Oratorio: A Concerto on the Pedal Harp-Jones; concerto on the Violin-Lamotte[, as17760315

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Polly Honeycombe

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: Caractacus

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Polly Honeycombe

Dance: As17761123

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Catherine and Petruchio

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Country Wife

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Dance: End: The Merry Sailors, as17761106; In afterpiece: Rural Dance, as17761226

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Dance: As17761226

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Dance: As17770121

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Golden Pippin

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Golden Pippin

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Coronation Anthems

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Linley Jun

Performances

Mainpiece Title: Judas Maccabaeus

Music: End of Part I: concerto on the violoncello-Cervetto; End of Part II: concerto on the violin-Lamotte

Performances

Mainpiece Title: The Messiah; Alexander's Feast

Music: As17770214

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Music: End Part I: a duetto on the tenor and violin-Stamitz, Lamotte; End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: Judas Maccabaeus; Alexander's Feast

Music: As17770214

Performances

Mainpiece Title: Samson; Judas Maccabaeus

Performances

Mainpiece Title: Israel In Egypt; Judas Maccabaeus

Music: As17770214

Performances

Mainpiece Title: Omnipotence; Judas Maccabaeus

Music: End Part I: solo on the pedal harp-Renaudin (1st public performance); End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: Acis And Galatea; Judas Maccabaeus

Afterpiece Title: Dryden's Ode; Judas Maccabaeus

Music: As17770214

Performances

Mainpiece Title: The Prodigal Son; Judas Maccabaeus

Song: With additional airs-

Music: End Part I: solo on the German flute-DeCamp; End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: Samson; Judas Maccabaeus

Music: As17770214

Performances

Mainpiece Title: The Prodigal Son