SELECT * FROM london_stages WHERE eventid IN (12174, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14373, 14384, 14392, 14395, 14407, 14432, 14443, 14452, 14544, 14550, 14935, 15254, 15259, 15280, 15284, 15288, 15291, 15300, 15303, 15325, 15505, 15517, 15566, 15570, 15584, 15604, 15729, 15730, 15815, 15821, 15824, 15827, 15849, 15860, 15915, 15919, 15923, 15927, 15931, 15938, 15956, 15970, 15974, 15981, 15997, 16025, 16037, 16058, 16088, 16091, 16107, 16125, 16251, 16286, 16307, 16316, 16333, 16337, 16351, 16403, 16406, 16421, 16428, 16468, 16632, 16635, 16636, 16642, 16644, 16661, 16665, 16668, 16673, 16678, 16697, 16725, 17284, 17533, 17547, 17589, 17596, 17599, 17615, 17618, 17639, 17642, 17673, 18173, 18174, 18175, 18176, 18178, 18187, 18207, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18975, 19236, 19238, 19240, 19242, 19270, 19272, 19276, 19277, 19350, 19352, 19354, 19362, 19451, 19453, 19491, 19572, 19666, 19671, 19673, 19675, 19679, 19697, 19757, 19800, 19818, 19820, 19827, 19834, 20805, 20814, 20817, 21099, 25603, 25613, 25617, 25624, 26507, 26516, 26946, 27451, 28430, 28440, 28443, 28453, 33880, 33883, 33885, 33888, 33890, 33892, 33894, 33897, 33899, 33911, 33916, 33918, 33925, 33965, 33973, 33977, 34023, 34037, 34070, 34083, 34116, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42040, 42058, 42066, 42081, 42134, 42142, 42157, 42293, 42294, 42302, 42306, 42312, 42318, 42324, 42330, 42338, 42354, 42357, 46000, 46026, 46526, 46531, 46540, 46558, 46569, 46573, 46588, 47137, 47189, 47190, 47717, 47747, 47757, 47777, 48269, 48273, 48282, 48283, 48301, 49486, 49488, 50021, 50033, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50215, 50374, 50380, 50385, 50387, 50642, 50669, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51140, 51239, 51247, 51249, 51254, 51256, 51258, 51285, 51298, 51304, 51338, 51356, 52348) 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: Every One Has His Fault

Afterpiece Title: Lock and Key

Dance: In 2nd piece: Highland Reel, as17980428

Song: End III 1st piece: Black Ey'd Susan-Incledon

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Reformed in Time

Performances

Mainpiece Title: Alexander's Feast 0; The Messiah; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End II: a concertante for violin oboe tenor and violoncello-G. Ashley, W. Parke, R. Ashley, C. Ashley