SELECT * FROM london_stages WHERE eventid IN (38080, 38095, 38104, 38125, 38130, 38140, 38155, 38169, 38185, 38199, 38238, 38252, 38264, 38504, 38518, 38532, 38631, 38641, 38646, 38660, 38665, 38708, 38797, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39332, 39344, 39352, 39356, 39358, 39367, 39373, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40404, 40414, 40429, 40434, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42054, 42180, 42188, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42506, 42510, 42530, 42541, 42549, 42551, 42554, 42561, 42607, 42620, 42668, 42689, 42712, 42801, 42804, 42807, 42813, 42838, 42840, 42842, 42844, 42846, 42847, 42848, 42850, 42852, 42853, 42870, 42880, 42889, 42898, 42906, 42920, 42928, 42942, 42952, 42968, 43003, 43069, 43095, 43124, 43167, 43277, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43405, 43929, 43938, 43942, 43944, 43948, 43951, 43967, 43970, 43975, 43977, 43979, 43981, 43985, 43986, 43988, 43991, 43992, 44007, 44009, 44013, 44015, 44021, 44219, 44228, 44231, 44240, 44245, 44254, 44307, 44312, 44316, 44320, 44329, 44333, 44338, 44351, 44375, 44385, 44390, 44400, 44415, 44430, 44440, 44455, 44460, 44472, 44476, 44478, 44480, 44481, 44482, 44483, 44491, 44500, 44503, 44504, 44508, 44511, 44517, 44521, 44526, 44527, 44532, 44533, 44535, 44539, 44547, 44556, 44557, 44558, 44559, 44560, 44561, 44563, 44564, 44565, 44567, 44573, 44576, 44579, 44580, 44581, 44582, 44585, 44586, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44820, 44825, 44837, 44858, 44864, 44937, 44942, 44947, 44953, 44962, 44967, 44976, 44981, 44987, 44993, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 45075, 45079, 45080, 45081, 45082, 45092, 45094, 45095, 45097, 45099, 45102, 45116, 45125, 45126, 45132, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45362, 45366, 45370, 45382, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 46008, 46021, 46071, 46076, 46086, 46091, 46096, 46101, 46119, 46131, 46434, 46439, 46444, 46453, 46458, 46467, 46472, 46479, 46484, 46493, 46498, 46507, 46512, 46520, 46525, 46567, 46689, 46703, 47205, 47215, 47221, 47245, 47262, 47271, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364) 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 Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Retaliation

Dance: As17821009

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Author

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Choice of Harlequin

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Choice of Harlequin

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Minor

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: St

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Deuce is in Him

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Mad-Cap

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Wife

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andulusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Barnaby Brittle

Dance: As17821009

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Author

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Positive Man

Dance: End of mainpiece Diversion a-la-Mode (performers not listed, but see17821206, in which The Minuet de la Cour by Harris and Miss Besford

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Retaliation

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Devil upon Two Sticks

Dance: As17821231

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Positive Man

Dance: As17821231

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Artaxerxes

Cast
Role: Arbaces Actor: Sga Sestini

Afterpiece Title: Lord Mayor's Day