SELECT * FROM london_stages WHERE eventid IN (31114, 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, 49999, 50008, 50011, 50021, 50024, 50033, 50036, 50050, 50059, 50062, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 51105, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51711, 51720, 51723, 51732, 51735, 51748, 51757, 51760, 51769, 51772, 52324, 52333, 52336, 52348, 52357, 52360, 52369, 52372, 52381, 52384) 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

Afterpiece Title: ACIS AND GALATEA

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

Performances

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

Music: End of Part II concerto on the organ by J. Ashley

Performances

Mainpiece Title: The Messiah

Music: End of Part II Eighth concerto of Corelli

Performances

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

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: End of Part II 1st concerto, Op. 3, composed by Geminiani, by G. Ashley

Performances

Mainpiece Title: The Fall Of Martinico; Or, Britannia Triumphant

Afterpiece Title: THE BELLE'S STRATAGEM

Afterpiece Title: THE HIGHLAND REEL

Dance: In Act IV of 2nd piece a Masquerade, in which a Minuet by Mrs Pope and Byrn

Song: In Masquerade Old Towler by Incledon; End of 2nd piece A Catalogue of Plays and Farces; or, a Love Letter from Dick Ranter to Kitty Sprightly, to an old Tune, by Bernard; After which Sally in our Alley by Incledon

Performances

Mainpiece Title: A Grand Selection 0 Main 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: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: End Part II: 3rd concerto of Giardini on the violin-G. Ashley

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

Music: In Part II: 1st concerto [of Geminiani]-G. Ashley

Performances

Mainpiece Title: The Messiah

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: 6th concerto of Giordani on the violin-C. Ashley

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: A Grand Miscellaneous Act

Performances

Mainpiece Title: The Messiah

Music: End Part II: 8th concerto of Corelli-

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast Or, the Power Of Music; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End Part I: concerto on the harp-Mme Delaval; Beginning Part II: concerto for two violins and violoncello obligato-, as originally composed for this Ode, by Handel and performed in the year 1736; End Part II: concerto on the Grand Piano Forte-Dussek

Performances

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

Cast
Role: Principal Vocal Performers Actor:

Afterpiece Title: L'Allegro ed Il Pensieroso 3; Alexander's Feast 3

Music: End Part II: concerto on the harp-Mme Delaval

Performances

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

Music: End Part I: 3rd concerto of Giardini on the violin-G. Ashley; End Part II: concerto on the Piano Forte-Dussek

Performances

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

Cast
Role: Principal Vocal Performers Actor:

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: concerto on the violincello-C. Ashley; End Part II: concerto on the harp-Mme Delaval