SELECT * FROM london_stages WHERE eventid IN (10619, 10621, 10624, 10627, 10630, 10633, 10636, 10639, 10642, 10645, 10648, 10651, 10653, 10656, 10659, 10662, 10665, 10668, 10671, 10674, 10677, 10680, 10683, 10686, 10724, 10748, 10753, 10804, 10861, 10958, 10960, 10962, 10995, 11022, 11025, 11027, 11041, 11045, 11233, 11372, 11388, 11488, 11493, 11507, 11511, 11514, 11516, 11518, 11520, 11523, 12340, 12343, 12384, 12889, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 27677, 27732, 28016, 38858, 47126, 47142, 47154, 47171, 47190, 47196, 47702, 47712, 47727, 47732, 47742, 47757, 47762, 47777, 48230, 48240, 48244, 48254, 48268, 48272, 48282, 48286, 48296) 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: Lallegro Ed Il Pensieroso 0

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso 0 Grand Selection 0

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Lallegro Ed Il Pensieroso

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Cast
Role: Total Eclipse Actor: Harrison
Role: Pious orgies Actor: Mrs Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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

Performances

Mainpiece Title: Grand Selection 0

Afterpiece Title: Grand Selection 1

Cast
Role: Softly rise Actor: Harrison
Role: Tune your harps Actor: Mrs Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah Part I Grand Selection 0

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Song: End 2nd piece: Ye spotted Snakes-(Stevens)

Performances

Mainpiece Title: The Messiah

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection