The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (26972, 27014, 31114, 31292, 45960, 46000, 46013, 46026, 47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 48898, 48907, 48908, 48911, 48912, 48921, 48922, 48925, 48926, 48936, 48937, 48940, 48941, 48950, 48951, 48954, 48964, 48966, 48968, 48970, 49048, 49446, 49459, 49469, 49473, 49482, 49486, 49497, 49501, 49515, 49995, 49999, 50008, 50011, 50021, 50024, 50033, 50036, 50039, 50050, 50059, 50062, 50255, 50261, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 51105, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51684, 51711, 51720, 51723, 51732, 51735, 51748, 51757, 51760, 51769, 51772, 52324, 52333, 52336, 52348, 52357, 52360, 52369, 52372, 52381, 52384, 52519) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: Old Woman's Oratory

Afterpiece Title: The Adventures of Fribble

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Beauty and Virtue

Music: As17620226

Performances

Mainpiece Title: The Coronation Anthem, God Save The King

Afterpiece Title: The Messiah

Music: End Part I Oratorio: concerto on the violin [by Viotti (World, 28 Feb.)]-Mme Gautherot (from Paris; 2nd public performance in this Kingdom)

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grandselection 0

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

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

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

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

Performances

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

Performances

Mainpiece Title: Alexander's Feast

Music: End of Part I Giardini's Sixth Concerto on the Violin by G. Ashley