SELECT * FROM london_stages WHERE eventid IN (39366, 39378, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 40053, 40061, 40073, 40431, 40741, 40743, 40746, 40755, 40767, 40770, 40775, 40781, 40816, 40845, 40859, 40876, 40956, 40960, 40962, 40983, 40989, 41718, 41723, 41729, 41739, 41741, 42670, 42735, 43444, 44031, 44037, 44078, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44286, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44444, 44469, 44608, 44632, 44650, 44652, 44664, 44674, 44676, 45537, 45547, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46130, 46137, 46151, 46154, 46171, 46178, 46266, 46271, 46273, 46284, 46292, 46299, 46311, 46321, 46323, 46336, 46343, 46353, 46357, 46361, 46363, 46365, 46369, 46373, 46383, 46387, 46389, 46393, 46397, 46399, 46401, 46403, 46431, 46474, 46483, 46488, 46490, 46492, 46500, 46506, 46511, 46519, 46524, 46533, 46543, 46552, 46564, 46571, 46580, 46585, 46590, 46607, 46612, 46614, 46622, 46632, 46634, 46637, 46639, 46642, 46657, 46676, 46688, 46695, 46697, 46700, 46708, 46716, 46718, 46732, 46737, 46743, 46746, 46751, 46758, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46891, 46893, 46895, 46897, 46907, 46909, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47198, 47202, 47220, 47235, 47253, 47289, 47306, 47309, 47312, 47315, 47320, 47326, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47519, 47527, 47531, 47537, 47543, 47549, 47555, 47561, 47566, 47568, 47575, 47645, 47651, 47655, 47657, 47672, 47676, 47683, 47685, 47737, 47752, 47782, 47797, 47813, 47828, 47843, 47858, 47872, 47892, 48038, 48043, 48049, 48080, 48090, 48109, 48264, 48278, 48285, 48289, 48294, 48299, 48320, 48322, 48349, 48358, 48366, 48368, 48416, 48418, 48437, 48443, 48620, 48628, 48654, 48677, 48734, 48744, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48858, 48863, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49012, 49014, 49021, 49023, 49026, 49033, 49038, 49041, 49051, 49053, 49056, 49058, 49061, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49216, 49222, 49226, 49244, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49594, 49599, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 49783, 49794, 49797, 49801, 49805, 49811, 49815, 49819, 49825, 49827, 49831, 49837, 49849, 49886, 49891, 49897, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50099, 50104, 50108, 50111, 50113, 50116, 50118, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 50360, 50366, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50690, 50695, 50697, 50699, 50702, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50736, 50742, 50744, 50747, 50762, 50764, 50772, 50777, 50784, 50790, 50800, 50802, 50805, 50812, 50932, 50936, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51247, 51249, 51254, 51256, 51258, 51268, 51277, 51283, 51285, 51293, 51298, 51304, 51314, 51338, 51356, 51363, 51521, 51525, 51527, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 52200, 52202, 52331, 52335, 52338, 52343, 52350, 52413, 52497) 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: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911024

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911024

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: In 3rd piece: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The First Part of King Henry the Fourth

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Romeo and Juliet

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Song: As17910926

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911122

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911024

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Dance: As17911112

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Dramatist

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Cast
Role: Draco Actor: Cranfield

Afterpiece Title: The Jovial Crew

Dance: In II 3rd piece: the original Crutch Dance-

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Cast
Role: Draco Actor: Cranfield

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: In 3rd piece: The Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: In afterpiece: As17911219

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125