SELECT * FROM london_stages WHERE eventid IN (2578, 6885, 6892, 6900, 6901, 6906, 6909, 7026, 7669, 7690, 7693, 7696, 7699, 7971, 7975, 9049, 9055, 9832, 9967, 9972, 10110, 10112, 10115, 10135, 10298, 30187, 30738, 30759, 30853, 30894, 31256, 40710, 42015, 42053, 44829, 44838, 44842, 44851, 44855, 44865, 44869, 44878, 44882, 44894, 44900, 45367, 45376, 45379, 45388, 45392, 45401, 45405, 45414, 45418, 45427, 45431, 45530, 45548, 45588, 45601, 45691, 45774, 45776, 45919, 45959, 45966, 45969, 45972, 45982, 45985, 46012, 46025, 46087, 46114, 46168, 46229, 46274, 46276, 46304, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46366, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46451, 46461, 46463, 46468, 46473, 46477, 46482, 46487, 46489, 46494, 46516, 46521, 46526, 46530, 46535, 46540, 46544, 46554, 46558, 46568, 46572, 46582, 46592, 46601, 46616, 46633, 46653, 46687, 46699, 46736, 46765, 46773, 46813, 46818, 46822, 46824, 46826, 46851, 46866, 46876, 46886, 46898, 46904, 46910, 46916, 46928, 46934, 46940, 47111, 47121, 47125, 47136, 47141, 47153, 47158, 47170, 47176, 47189, 47195, 47447, 47448, 47450, 47452, 47453, 47468, 47471, 47476, 47477, 47481, 47486, 47494, 47510, 47514, 47516, 47528, 47534, 47538, 47542, 47546, 47550, 47552, 47554, 47556, 47562, 47563, 47569, 47571, 47574, 47579, 47583, 47585, 47592, 47594, 47646, 47667, 47682, 47701, 47703, 47711, 47716, 47726, 47728, 47731, 47741, 47743, 47746, 47751, 47756, 47758, 47761, 47763, 47766, 47771, 47773, 47776, 47778, 47781, 47786, 47791, 47804, 47817, 47829, 47849, 47859, 47871, 47876, 47889, 47893, 47899, 47901, 47902, 47905, 47907, 48007, 48011, 48013, 48018, 48021, 48025, 48027, 48030, 48031, 48033, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48054, 48058, 48060, 48065, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48120, 48122, 48128, 48130, 48132, 48138, 48141, 48165, 48175, 48177, 48179, 48210, 48215, 48219, 48224, 48230, 48235, 48237, 48240, 48244, 48256, 48263, 48270, 48274, 48277, 48279, 48284, 48291, 48310, 48319, 48340, 48346, 48353, 48383, 48390, 48393, 48397, 48401, 48403, 48410, 48412, 48415, 48426, 48429, 48434, 48509, 48510, 48514, 48907, 48911, 48921, 48925, 48936, 48940, 48950, 48954, 48964, 48966, 48968, 48970) 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: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: The Messiah

Music: End of Part I concerto on the flute by Ashe; End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection

Afterpiece Title: ACIS AND GALATEA

Music: End of Part I of oratorio concerto on violin by Giornovichi

Performances

Mainpiece Title: The Messiah

Music: End of Part I concerto on the oboe by W. Parke; End of Part II concerto on the violin by Giornovichi, in which the favourite air of Lullaby

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: Redemption A Sacred Oratorio Selected From The Great And Favourite Works Of Handel

Music: As17940409

Performances

Mainpiece Title: A Grand Selection Of Music Chiefly From The Works Of Handel

Music: In Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: The Messiah

Music: As17940328but omitted: Lullaby