SELECT * FROM london_stages WHERE eventid IN (34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35289, 35305, 35365, 35372, 35382, 35528, 35530, 35533, 35537, 35539, 35545, 35547, 35560, 35562, 35568, 35570, 35575, 35579, 35585, 35592, 35619, 35621, 35693, 35749, 35763, 35810, 35870, 35910, 35929, 35945, 36141, 36143, 36145, 36493, 36523, 36529, 36722, 36731, 36736, 36742, 36780, 37036, 37058, 37068, 37096, 37212, 37214, 37218, 37229, 37241, 37251, 37268, 37303, 37566, 37623, 37787, 37793, 37797, 37803, 37825, 37827, 37829, 37833, 37835, 37852, 37870, 37874, 37887, 37893, 37902, 37905, 37941, 37943, 37949, 37962, 38050, 38123, 38153, 38158, 38167, 38172, 38183, 38339, 38343, 38361, 38369, 38371, 38706, 38873, 38883, 38891, 38951, 38956, 38974, 39511, 39513, 39518, 39603, 40427, 40565, 40571, 40588, 40639, 41165, 41237, 41280, 41308, 41322, 43271, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49467, 49475, 49480, 49543, 49657, 49817, 49919, 50092, 50200, 51050, 52128, 52274) 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: The Mysteries Of The Castle

Afterpiece Title: The School for Arrogance

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Hartford Bridge

Dance: As17941001

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Midas

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The School For Arrogance

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: Harlequin and Faustus

Song: End I: The Mid Watch-Incledon; End II: Sally in our Alley-Incledon

Performances

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Merry Sherwood

Performances

Afterpiece Title: A Divertisement

Entertainment: MonologueAfter dancing: Belles! Have at ye All-Mrs Mattocks

Ballet: End: Dermot and Kathlane; or, The Irish Wedding (composed by Byrn). Dermot-Byrn; Darby-Jackson; Patrick-Holland; Father Luke-Platt; Norah-Mlle St.Amand; Old Kathlane-Miss Smyth; Kathlane (only time [i.e. appearance] this season)-Mme Rossi. [And see17931018.

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Farmer

Performances

Afterpiece Title: A Divertisement

Dance: As17971013

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Cross Purposes

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Guardian