SELECT * FROM london_stages WHERE eventid IN (1174, 4455, 4531, 4562, 4655, 4656, 4672, 4714, 4833, 4901, 5121, 5435, 5540, 5621, 5792, 5803, 5848, 6006, 7152, 7154, 7176, 7178, 7184, 7192, 7280, 7480, 8373, 11354, 11700, 11799, 12996, 13101, 13130, 13430, 13457, 13631, 13692, 14091, 14221, 14418, 14894, 15556, 16256, 17879, 17977, 18163, 18546, 18664, 18933, 18935, 18937, 18943, 18955, 19018, 19127, 19184, 19235, 19316, 19361, 19410, 19439, 19472, 19481, 19586, 19684, 19718, 20363, 20642, 20704, 21380, 21383, 21408, 21485, 21588, 21694, 21759, 21808, 21833, 21918, 22069, 22160, 22317, 23041, 23057, 23060, 23086, 23111, 23434, 23437, 23446, 23449, 23452, 23455, 23467, 23474, 23477, 23521, 23775, 23853, 23876, 24182, 24296, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24333, 24648, 26134, 26318, 26353, 26588, 27676, 27679, 27682, 27687, 27694, 27728, 27761, 27789, 27813, 27819, 27854, 27905, 27934, 28038, 28140, 28164, 28293, 28428, 28797, 28958, 29062, 29568, 30137, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 33137, 33696, 45999, 46554, 46627, 46695, 47142, 47190, 47702, 47712, 47727, 47742, 47757, 47762, 47777, 48268, 48272) 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: Alexanders Feast Grand Selection 0

Afterpiece Title: Alexanders Feast 1

Afterpiece Title: Alexanders Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: The First Act Of Alexanders Feast Grand Selection 0

Afterpiece Title: Alexanders Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso 0

Afterpiece Title: LAlegro ed il Pensieroso 1

Afterpiece Title: LAllegro ed il Pensieroso

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: The Coronation Anthem

Afterpiece Title: The Messiah LAllegro ed il Pensieroso 0

Performances

Mainpiece Title: Alexanders Feast 0 Redemption 0 Lallegro Ed Il Pensieroso 0

Afterpiece Title: Alexanders Feast 1

Afterpiece Title: Alexanders Feast 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso 0

Afterpiece Title: LAllegro ed il Pensieroso 1

Afterpiece Title: LAllegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso 0 Grand Selection 0

Afterpiece Title: LAllegro ed il Pensieroso 1

Afterpiece Title: LAllegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Alexanders Feast 0 Grand Selection 0

Afterpiece Title: Alexanders Feast 3 Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso

Afterpiece Title: LAllegro ed il Pensieroso 1

Afterpiece Title: LAllegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Penseroso Part I Only Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

Mainpiece Title: Lallegro Ed Il Penseroso Part I Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection