SELECT * FROM london_stages WHERE eventid IN (287, 1136, 3808, 3839, 10132, 14711, 14734, 15479, 15480, 15482, 15487, 15762, 17910, 17917, 18163, 22073, 22541, 22699, 23551, 23555, 23595, 23626, 23667, 23670, 24295, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24824, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 25142, 25153, 25185, 25310, 25313, 25316, 25322, 25326, 25724, 25735, 26475, 28788, 28790, 28810, 28813, 28820, 28822, 28839, 29061, 29327, 29419, 29449, 29551, 29564, 29580, 29604, 31822, 32269, 32273, 32274, 32275, 32276, 32277, 32278, 32279, 32281, 32282, 32283, 32285, 32287, 32290, 32292, 32294, 32295, 32297, 32298, 32299, 32303, 32304, 32309, 33684, 33745, 33748, 33752, 33757, 33759, 33765, 33770, 33789, 34251, 34297, 34304, 34308, 34309, 34322, 34333, 34338, 34688, 34696, 34719, 34866, 34870, 35212, 35245, 35347, 35364, 35380, 35384, 35387, 35443, 35454, 35484, 35501, 35515, 35557, 35591, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36283, 36285, 36288, 36290, 36292, 36299, 36306, 36311, 36316, 36325, 36327, 36363, 36553, 36687, 36707, 36729, 36732, 36734, 36737, 36739, 36741, 36743, 36746, 36748, 36751, 36757, 36760, 36765, 36767, 36771, 36779, 36783, 36826, 36831, 36835, 36842, 36856, 36859, 36869, 36874, 36884, 36898, 36912, 36915, 36924, 36926, 36931, 36937, 36940, 36942, 36948, 36953, 37003, 37017, 37022, 37040, 37050, 37056, 37081, 37192, 37194, 37198, 37228, 37230, 37236, 37252, 37254, 37258, 37269, 37300, 37308, 37320, 37332, 37334, 37336, 37341, 37346, 37353, 37360, 37362, 37367, 37372, 37383, 37385, 37387, 37389, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37440, 37442, 37444, 37458, 37461, 37463, 37466, 37468, 37471, 37473, 37476, 37480, 37486, 37491, 37496, 37504, 37511, 37515, 37518, 37520, 37529, 37541, 37567, 37573, 37607, 37609, 37617, 37647, 37649, 37660, 37668, 37674, 37676, 37678, 37782, 37784, 37788, 37792, 37794, 37798, 37800, 37804, 37806, 37808, 37812, 37814, 37816, 37818, 37820, 37822, 37824, 37826, 37830, 37834, 37836, 37838, 37840, 37842, 37844, 37846, 37850, 37857, 37859, 37865, 37867, 37871, 37873, 37876, 37879, 37881, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37922, 37926, 37929, 37931, 37934, 37938, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38004, 38027, 38029, 38046, 38048, 38063, 38071, 38079, 38094, 38108, 38113, 38119, 38124, 38129, 38139, 38144, 38173, 38184, 38189, 38191, 38193, 38198, 38201, 38211, 38222, 38234, 38237, 38240, 38251, 38310, 38312, 38314, 38316, 38319, 38322, 38324, 38331, 38333, 38335, 38338, 38340, 38344, 38346, 38348, 38350, 38352, 38354, 38360, 38362, 38365, 38368, 38370, 38372, 38377, 38379, 38382, 38384, 38388, 38408, 38411, 38413, 38416, 38418, 38421, 38423, 38426, 38428, 38430, 38432, 38435, 38437, 38440, 38442, 38444, 38446, 38449, 38451, 38454, 38456, 38769, 38859, 38865, 38871, 38874, 38882, 38886, 38909, 38922, 38931, 38935, 38940, 38943, 38945, 38947, 38949, 38952, 38954, 38957, 38959, 38963, 38966, 38968, 38971, 38980, 38983, 38985, 38987, 38991, 38995, 39000, 39004, 39009, 39012, 39017, 39018, 39024, 39025, 39027, 39029, 39031, 39032, 39034, 39036, 39037, 39038, 39039, 39041, 39042, 39043, 39044, 39046, 39047, 39048, 39049, 39051, 39052, 39054, 39055, 39056, 39057, 39058, 39060, 39063, 39065, 39066, 39067, 39068, 39070, 39072, 39073, 39074, 39076, 39077, 39082, 39084, 39086, 39087, 39089, 39094, 39096, 39098, 39101, 39103, 39108, 39114, 39115, 39124, 39129, 39136, 39137, 39138, 39147, 39152, 39157, 39161, 39163, 39166, 39178, 39182, 39185, 39191, 39199, 39200, 39206, 39211, 39220, 39223, 39226, 39229, 39231, 39237, 39242, 39246, 39251, 39262, 39270, 39271, 39277, 39281, 39286, 39313, 39316, 39321, 39323, 39325, 39330, 39446, 39450, 39452, 39456, 39464, 39469, 39473, 39475, 39479, 39483, 39485, 39490, 39492, 39494, 39496, 39498, 39503, 39507, 39509, 39512, 39514, 39517, 39523, 39528, 39531, 39533, 39535, 39537, 39540, 39545, 39549, 39551, 39556, 39561, 39565, 39568, 39573, 39575, 39577, 39579, 39582, 39584, 39587, 39589, 39598, 39604, 39610, 39622, 39633, 39635, 39638, 39642, 39647, 39652, 39656, 39658, 39664, 39667, 39669, 39674, 39679, 39681, 39685, 39688, 39691, 39694, 39696, 39698, 39700, 39703, 39705, 39708, 39710, 39712, 39714, 39717, 39724, 39727, 39732, 39736, 39744, 39755, 39760, 39765, 39770, 39773, 39782, 39792, 39798, 39806, 39808, 39813, 39819, 39824, 39829, 39833, 39838, 39855, 39858, 39862, 39867, 39869, 39874, 39878, 39884, 39887, 39889, 39895, 39899, 39916, 40017, 40018, 40020, 40022, 40024, 40026, 40027, 40028, 40030, 40032, 40034, 40036, 40038, 40046, 40051, 40055, 40057, 40061, 40063, 40065, 40067, 40069, 40071, 40077, 40079, 40081, 40087, 40089, 40091, 40093, 40095, 40099, 40107, 40112, 40114, 40116, 40118, 40121, 40123, 40126, 40128, 40130, 40132, 40135, 40140, 40144, 40146, 40151, 40154, 40156, 40158, 40160, 40163, 40165, 40167, 40176, 40179, 40181, 40183, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40231, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40263, 40270, 40276, 40279, 40282, 40285, 40289, 40292, 40295, 40297, 40302, 40305, 40308, 40311, 40316, 40323, 40324, 40326, 40331, 40335, 40338, 40340, 40345, 40350, 40353, 40355, 40358, 40360, 40362, 40364, 40367, 40369, 40372, 40374, 40377, 40379, 40382, 40384, 40387, 40389, 40391, 40396, 40401, 40403, 40408, 40413, 40416, 40418, 40420, 40422, 40425, 40428, 40433, 40436, 40438, 40441, 40444, 40446, 40448, 40450, 40454, 40566, 40568, 40572, 40574, 40576, 40578, 40580, 40582, 40584, 40587, 40589, 40590, 40593, 40594, 40596, 40598, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40622, 40624, 40628, 40632, 40634, 40636, 40638, 40640, 40649, 40651, 40653, 40655, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40697, 40700, 40706, 40708, 40711, 40712, 40714, 40717, 40719, 40721, 40723, 40726, 40727, 40729, 40732, 40734, 40736, 40748, 40750, 40752, 40765, 40767, 40772, 40775, 40777, 40784, 40787, 40789, 40792, 40795, 40797, 40801, 40804, 40809, 40813, 40816, 40819, 40842, 40848, 40852, 40856, 40866, 40870, 40873, 40880, 40884, 40886, 40889, 40891, 40898, 40900, 40902, 40905, 40907, 40910, 40912, 40917, 40922, 40925, 40928, 40933, 40951, 40956, 40960, 40962, 40965, 40970, 40980, 40983, 40989, 40999, 41010, 41123, 41197, 41459, 41487, 42992, 43099, 43156, 43830, 43833, 44031, 44078, 44227, 44230, 44233, 44237, 44242, 44244, 44247, 44249, 44253, 44256, 44261, 44263, 44286, 44293, 44311, 44315, 44319, 44328, 44337, 44374, 44377, 44414, 44427, 44432, 44437, 44459, 44589, 44591, 44593, 44595, 44597, 44599, 44601, 44605, 44616, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44643, 44645, 44647, 44648, 44650, 44652, 44654, 44656, 44658, 44660, 44662, 44666, 44668, 44670, 44672, 44674, 44678, 44680, 44682, 44684, 44686, 44688, 44690, 44692, 44694, 44696, 44698, 44705, 44710, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44778, 44780, 44783, 44785, 44787, 44789, 44791, 44794, 44796, 44799, 44805, 44808, 44815, 44817, 44818, 44819, 44822, 44828, 44834, 44836, 44840, 44847, 44853, 44857, 44860, 44863, 44867, 44874, 44876, 44880, 44884, 44887, 44897, 44907, 44909, 44911, 44915, 44920, 44922, 44925, 44927, 44929, 44931, 44934, 44936, 44941, 44944, 44946, 44952, 44957, 44964, 44969, 44971, 44975, 44980, 44983, 44986, 44989, 44990, 44992, 44995, 44996, 44998, 45001, 45004, 45007, 45008, 45013, 45016, 45020, 45022, 45025, 45027, 45030, 45032, 45035, 45037, 45040, 45041, 45043, 45044, 45047, 45051, 45053, 45055, 45056, 45057, 45059, 45063, 45065, 45068, 45073, 45074, 45075, 45076, 45077, 45078, 45081, 45083, 45084, 45086, 45087, 45088, 45089, 45091, 45092, 45096, 45101, 45107, 45108, 45110, 45113, 45114, 45115, 45116, 45117, 45118, 45121, 45122, 45123, 45124, 45127, 45129, 45130, 45131, 45137, 45141, 45143, 45147, 45159, 45164, 45166, 45169, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45196, 45204, 45208, 45214, 45216, 45222, 45224, 45228, 45232, 45236, 45238, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45274, 45278, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45302, 45305, 45307, 45310, 45314, 45316, 45319, 45321, 45324, 45326, 45328, 45330, 45333, 45335, 45344, 45347, 45352, 45354, 45356, 45378, 45384, 45394, 45397, 45399, 45407, 45410, 45420, 45425, 45433, 45436, 45438, 45442, 45444, 45449, 45451, 45459, 45461, 45464, 45466, 45469, 45475, 45477, 45480, 45482, 45485, 45492, 45495, 45500, 45509, 45511, 45517, 45519, 45521, 45524, 45526, 45529, 45531, 45534, 45539, 45542, 45544, 45547, 45554, 45557, 45559, 45562, 45567, 45569, 45574, 45577, 45582, 45587, 45589, 45591, 46148, 47102, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47468, 47476, 47876, 47907, 47919, 47946, 47947, 47957, 48018, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48110, 48112, 48116, 48120, 48122, 48130, 48132, 48138, 48177, 48235, 48263, 48270, 48274, 48277, 48279, 48284, 48291, 48310, 48319, 48340, 48401, 48415, 48429, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48566, 48568, 48570, 48574, 48939, 49030, 49045, 49060, 49133, 49135, 49137, 49167, 49172, 49231, 49239, 49255, 49279, 49304, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49370, 49375, 49379, 49424, 49444, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49808, 49828, 49932, 49937, 49958, 50137, 50306, 50308, 50310, 50974, 51004, 51051, 51106, 51109, 51111, 51113, 51115, 51120, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51294, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51372, 51377, 51380, 51405, 51415, 51420, 51428, 51430, 51453, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51570, 51572, 51582, 51595, 51602, 51623, 51626, 51633, 51638, 51640, 51642, 51647, 51649, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51807, 51819, 51821, 51824, 51830, 51832, 51837, 51844, 51848, 51850, 51855, 51863, 51872, 51876, 51878, 51888, 51913, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053) 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 Cherokee

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Cherokee

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The Deaf Lover

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: Hob in the Well

Performances

Mainpiece Title: Zorinski

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Mountaineers

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: The Mountaineers

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Prisoner at Large