Search

Toggle Sphinx Query

SELECT * FROM london_stages WHERE eventid IN (34909, 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, 35008, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35055, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35085, 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, 35260, 35264, 35272, 35277, 35289, 35292, 35305, 35321, 35327, 35335, 35340, 35343, 35365, 35372, 35375, 35382, 35503, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35530, 35549, 35553, 35555, 35564, 35583, 35617, 35619, 35624, 35629, 35633, 35638, 35683, 35691, 35699, 35714, 35829, 35849, 35854, 35894, 35901, 35905, 35934, 35947, 35952, 35957, 35967, 35992, 35994, 35997, 36115, 36122, 36124, 36125, 36127, 36133, 36149, 36151, 36155, 36176, 36184, 36225, 36229, 36234, 36239, 36241, 36246, 36251, 36253, 36255, 36260, 36264, 36271, 36273, 36282, 36287, 36296, 36310, 36313, 36315, 36317, 36319, 36321, 36324, 36326, 36329, 36331, 36333, 36336, 36338, 36341, 36350, 36352, 36355, 36357, 36362, 36381, 36384, 36409, 36414, 36418, 36434, 36440, 36449, 36460, 36468, 36475, 36477, 36485, 36492, 36494, 36497, 36499, 36502, 36511, 36513, 36516, 36526, 36532, 36540, 36543, 36555, 36639, 36641, 36645, 36647, 36653, 36663, 36667, 36671, 36684, 36688, 36692, 36698, 36700, 36706, 36719, 36722, 36724, 36726, 36728, 36731, 36733, 36745, 36747, 36750, 36754, 36768, 36770, 36778, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36844, 36866, 36871, 36873, 36883, 36888, 36892, 36895, 36897, 36939, 36963, 36985, 36996, 37008, 37021, 37031, 37041, 37052, 37055, 37066, 37076, 37085, 37088, 37091, 37104, 37124, 37209, 37216, 37225, 37243, 37253, 37255, 37260, 37262, 37274, 37288, 37296, 37299, 37319, 37329, 37347, 37363, 37368, 37371, 37373, 37424, 37426, 37428, 37433, 37445, 37448, 37451, 37453, 37457, 37460, 37462, 37472, 37479, 37485, 37503, 37548, 37550, 37579, 37589, 37592, 37602, 37604, 37623, 37637, 37640, 37643, 37656, 37665, 37671, 37673, 37675, 37677, 37778, 37803, 37815, 37821, 37823, 37827, 37831, 37843, 37858, 37860, 37866, 37868, 37878, 37880, 37884, 37902, 37916, 37923, 37928, 37930, 37933, 37935, 37937, 37949, 37954, 37956, 37971, 37973, 37977, 37982, 37989, 38003, 38016, 38026, 38028, 38032, 38037, 38040, 38091, 38093, 38136, 38138, 38148, 38151, 38162, 38170, 38186, 38190, 38192, 38195, 38197, 38200, 38202, 38205, 38213, 38216, 38221, 38224, 38227, 38230, 38233, 38236, 38239, 38242, 38315, 38330, 38334, 38336, 38341, 38347, 38351, 38361, 38367, 38369, 38373, 38376, 38378, 38381, 38383, 38385, 38396, 38401, 38407, 38410, 38417, 38427, 38434, 38436, 38439, 38445, 38462, 38467, 38483, 38490, 38521, 38528, 38538, 38545, 38549, 38559, 38565, 38573, 38575, 38629, 38653, 38656, 38658, 38663, 38668, 38678, 38680, 38692, 38698, 38700, 38703, 38709, 38711, 38716, 38726, 38731, 38734, 38739, 38745, 38753, 38763, 38766, 38768, 38798, 38856, 38864, 38867, 38870, 38876, 38885, 38894, 38904, 38908, 38918, 38928, 38932, 38937, 38946, 38974, 38976, 38982, 38986, 38993, 38995, 39000, 39008, 39017, 39024, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39081, 39083, 39086, 39093, 39098, 39100, 39104, 39107, 39114, 39123, 39128, 39137, 39163, 39171, 39196, 39199, 39208, 39213, 39236, 39245, 39250, 39257, 39262, 39265, 39270, 39285, 39288, 39291, 39293, 39308, 39312, 39324, 39333, 39335, 39341, 39347, 39447, 39451, 39453, 39455, 39457, 39468, 39470, 39472, 39476, 39480, 39497, 39499, 39502, 39506, 39508, 39511, 39513, 39525, 39527, 39532, 39539, 39541, 39546, 39550, 39553, 39555, 39558, 39560, 39564, 39572, 39578, 39581, 39583, 39600, 39603, 39605, 39607, 39611, 39651, 39673, 39682, 39695, 39709, 39713, 39716, 39718, 39721, 39726, 39735, 39743, 39759, 39769, 39793, 39797, 39805, 39818, 39823, 39843, 39863, 39866, 39873, 39877, 39880, 39891, 39894, 39898, 39904, 40015, 40019, 40021, 40025, 40027, 40029, 40039, 40041, 40043, 40045, 40047, 40049, 40050, 40054, 40056, 40058, 40060, 40062, 40064, 40066, 40068, 40070, 40072, 40074, 40076, 40078, 40080, 40082, 40084, 40086, 40088, 40090, 40092, 40094, 40096, 40098, 40102, 40104, 40106, 40111, 40113, 40115, 40117, 40127, 40129, 40134, 40136, 40139, 40141, 40148, 40150, 40164, 40169, 40172, 40175, 40178, 40184, 40194, 40196, 40198, 40201, 40204, 40207, 40209, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40239, 40242, 40253, 40258, 40262, 40264, 40266, 40269, 40275, 40284, 40288, 40294, 40310, 40319, 40322, 40325, 40334, 40337, 40352, 40354, 40366, 40371, 40376, 40392, 40395, 40400, 40410, 40412, 40417, 40430, 40443, 40445, 40455, 40457, 40458, 40463, 40563, 40569, 40573, 40575, 40577, 40579, 40581, 40583, 40586, 40595, 40599, 40601, 40603, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40629, 40631, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40673, 40680, 40692, 40696, 40699, 40710, 40716, 40720, 40722, 40731, 40733, 40742, 40749, 40757, 40766, 40769, 40771, 40774, 40778, 40780, 40788, 40800, 40803, 40808, 40815, 40824, 40830, 40838, 40844, 40855, 40861, 40865, 40872, 40879, 40890, 40904, 40909, 40919, 40930, 40942, 40950, 40952, 40957, 40961, 40969, 40971, 40977, 40984, 40993, 40998, 41001, 41003, 41008, 41114, 41116, 41118, 41121, 41126, 41129, 41131, 41134, 41136, 41140, 41144, 41149, 41151, 41157, 41178, 41198, 41210, 41216, 41242, 41249, 41254, 41258, 41260, 41263, 41270, 41282, 41284, 41296, 41305, 41312, 41334, 41341, 41380, 41420, 41424, 41427, 41429, 41434, 41444, 41450, 41454, 41460, 41479, 41490, 41495, 41509, 41512, 41519, 41524, 41526, 41533, 41546, 41561, 41577, 41696, 41712, 41715, 41717, 41720, 41734, 41742, 41748, 41754, 41771, 41785, 41787, 41811, 41852, 41862, 41865, 41897, 41902, 41970, 42006, 42013, 42039, 42065, 42070, 42072, 42077, 42080, 42085, 42087, 42090, 42092, 42102, 42105, 42107, 42123, 42126, 42144, 42148, 42149, 42153, 42162, 42166, 42284, 42288, 42292, 42295, 42309, 42311, 42315, 42335, 42339, 42344, 42347, 42349, 42353, 42358, 42366, 42371, 42373, 42378, 42380, 42382, 42388, 42393, 42397, 42409, 42411, 42416, 42419, 42436, 42444, 42449, 42460, 42462, 42485, 42498, 42512, 42516, 42521, 42526, 42531, 42543, 42563, 42565, 42568, 42573, 42580, 42585, 42589, 42598, 42602, 42615, 42622, 42671, 42676, 42678, 42683, 42693, 42696, 42697, 42711, 42718, 42725, 42733, 42746, 42867, 42869, 42905, 42931, 42935, 42939, 42941, 42943, 42945, 42951, 42955, 42957, 42959, 42964, 42967, 42983, 42985, 43009, 43011, 43028, 43030, 43039, 43049, 43056, 43073, 43105, 43117, 43154, 43197, 43221, 43226, 43228, 43231, 43236, 43246, 43259, 43276, 43287, 43289, 43304, 43440, 43445, 43459, 43475, 43477, 43487, 43530, 43586, 43603, 43605, 43614, 43617, 43619, 43621, 43623, 43632, 43635, 43637, 43640, 43643, 43646, 43650, 43655, 43663, 43667, 43698, 43706, 43717, 43728, 43735, 43747, 43755, 43773, 43778, 43794, 43805, 43817, 43833, 43843, 43853, 43857, 43867, 43877, 43880, 43887, 43895, 43897, 43904, 43928, 43941, 43947, 43949, 43952, 43955, 43958, 43966, 43973, 43976, 43978, 43980, 44028, 44040, 44045, 44049, 44065, 44073, 44079, 44096, 44102, 44104, 44112, 44116, 44126, 44128, 44132, 44136, 44144, 44148, 44152, 44154, 44156, 44158, 44160, 44162, 44166, 44169, 44171, 44175, 44183, 44187, 44191, 44193, 44199, 44203, 44229, 44252, 44266, 44283, 44314, 44321, 44373, 44393, 44408, 44411, 44423, 44426, 44431, 44441, 44446, 44456, 44458, 44461, 44470, 44473, 44477, 44505, 44513, 44516, 44520, 44531, 44537, 44540, 44551, 44590, 44594, 44596, 44604, 44627, 44629, 44631, 44633, 44637, 44661, 44665, 44675, 44702, 44714, 44716, 44718, 44722, 44725, 44730, 44732, 44734, 44736, 44742, 44745, 44747, 44749, 44763, 44765, 44777, 44788, 44798, 44804, 44807, 44814, 44816, 44821, 44827, 44839, 44861, 44896, 44910, 44914, 44935, 44948, 44956, 44972, 44974, 44979, 44982, 44985, 44988, 44994, 45012, 45026, 45136, 45142, 45144, 45146, 45148, 45153, 45161, 45170, 45173, 45175, 45177, 45179, 45181, 45185, 45187, 45189, 45193, 45195, 45201, 45209, 45213, 45221, 45223, 45227, 45233, 45241, 45243, 45249, 45259, 45286, 45290, 45294, 45301, 45304, 45311, 45313, 45315, 45318, 45327, 45334, 45343, 45346, 45353, 45364, 45371, 45396, 45415, 45455, 45468, 45470, 45471, 45474, 45479, 45484, 45489, 45491, 45501, 45510, 45516, 45525, 45541, 45546, 45556, 45558, 45561, 45573, 45578, 45583, 45586, 45588, 45592, 45594, 45596, 45603, 45691, 45701, 45705, 45708, 45710, 45713, 45715, 45747, 45755, 45760, 45768, 45770, 45774, 45776, 45780, 45788, 45796, 45800, 45804, 45808, 45816, 45820, 45826, 45828, 45832, 45841, 45847, 45849, 45853, 45865, 45870, 45873, 45879, 45887, 45893, 45898, 45908, 45910, 45931, 45938, 45941, 45945, 45961, 45979, 46035, 46062, 46069, 46079, 46087, 46097, 46120, 46142, 46145, 46147, 46150, 46268, 46270, 46272, 46274, 46280, 46282, 46283, 46288, 46291, 46300, 46308, 46310, 46312, 46320, 46328, 46332, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46366, 46382, 46386, 46394, 46402, 46406, 46414, 46422, 46435, 46445, 46449, 46454, 46456, 46463, 46465, 46468, 46475, 46485, 46489, 46491, 46503, 46505, 46508, 46514, 46518, 46521, 46523, 46532, 46546, 46549, 46565, 46592, 46606, 46621, 46623, 46631, 46633, 46641, 46653, 46656, 46658, 46682, 46690, 46704, 46712, 46722, 46771, 46843, 46848, 46851, 46853, 46860, 46862, 46874, 46902, 46912, 46914, 46920, 46926, 46936, 46938, 46948, 46950, 46954, 46960, 46962, 46966, 47000, 47038, 47060, 47075, 47103, 47123, 47147, 47155, 47166, 47172, 47185, 47191, 47211, 47213, 47225, 47241, 47248, 47276, 47284, 47288, 47290, 47294, 47450, 47453, 47461, 47465, 47480, 47488, 47490, 47510, 47514, 47518, 47524, 47528, 47530, 47548, 47563, 47574, 47576, 47585, 47590, 47596, 47604, 47606, 47609, 47620, 47632, 47642, 47650, 47652, 47669, 47671, 47679, 47699, 47706, 47713, 47721, 47733, 47736, 47738, 47766, 47773, 47783, 47786, 47799, 47804, 47807, 47819, 47832, 47837, 47849, 47854, 47864, 47886, 47891, 47898, 47902, 47904, 47907, 47908, 47909, 47911, 47992, 48003, 48009, 48011, 48013, 48014, 48018, 48035, 48042, 48044, 48046, 48052, 48060, 48063, 48067, 48069, 48083, 48087, 48104, 48106, 48112, 48122, 48141, 48143, 48147, 48151, 48159, 48161, 48171, 48175, 48177, 48187, 48224, 48235, 48249, 48263, 48265, 48270, 48274, 48284, 48338, 48340, 48346, 48353, 48365, 48369, 48374, 48376, 48381, 48383, 48390, 48395, 48406, 48422, 48424, 48431, 48445, 48448, 48453, 48454, 48458, 48459, 48461, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48483, 48484, 48486, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48498, 48499, 48501, 48502, 48503, 48504, 48505, 48507, 48508, 48509, 48510, 48511, 48512, 48513, 48514, 48515, 48516, 48518, 48519, 48520, 48522, 48526, 48528, 48530, 48531, 48532, 48533, 48538, 48540, 48542, 48544, 48546, 48550, 48552, 48554, 48556, 48558, 48560, 48562, 48564, 48566, 48568, 48570, 48572, 48574, 48576, 48578, 48580, 48582, 48584, 48587, 48589, 48591, 48593, 48595, 48597, 48599, 48604, 48606, 48610, 48612, 48614, 48616, 48622, 48624, 48626, 48632, 48636, 48638, 48644, 48646, 48648, 48652, 48658, 48660, 48666, 48668, 48670, 48676, 48678, 48680, 48686, 48688, 48690, 48696, 48698, 48700, 48706, 48710, 48716, 48718, 48720, 48726, 48728, 48733, 48736, 48738, 48740, 48746, 48748, 48750, 48753, 48756, 48758, 48760, 48762, 48768, 48770, 48772, 48776, 48778, 48780, 48782, 48784, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48820, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48878, 48880, 48883, 48885, 48888, 48891, 48893, 48897, 48900, 48903, 48905, 48910, 48914, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48946, 48948, 48953, 48957, 48960, 48962, 48987, 48999, 49006, 49025, 49030, 49085, 49091, 49099, 49102, 49111, 49120, 49122, 49123, 49125, 49126, 49127, 49128, 49129, 49130, 49131, 49132, 49133, 49134, 49135, 49137, 49138, 49140, 49141, 49143, 49144, 49145, 49146, 49148, 49149, 49150, 49151, 49152, 49153, 49154, 49155, 49156, 49157, 49158, 49160, 49161, 49162, 49163, 49164, 49165, 49167, 49168, 49169, 49170, 49171, 49172, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49183, 49187, 49194, 49198, 49205, 49235, 49251, 49275, 49287, 49295, 49299, 49306, 49313, 49323, 49327, 49351, 49358, 49363, 49384, 49389, 49391, 49393, 49403, 49419, 49421, 49426, 49440, 49453, 49457, 49461, 49464, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49506, 49512, 49516, 49519, 49524, 49526, 49528, 49533, 49544, 49549, 49555, 49564, 49579, 49588, 49629, 49645, 49651, 49654, 49656, 49658, 49660, 49663, 49665, 49668, 49669, 49670, 49675, 49677, 49678, 49679, 49680, 49682, 49683, 49685, 49686, 49687, 49688, 49691, 49693, 49695, 49696, 49698, 49699, 49700, 49701, 49702, 49703, 49704, 49705, 49706, 49707, 49708, 49709, 49710, 49711, 49712, 49713, 49714, 49715, 49716, 49717, 49718, 49719, 49720, 49721, 49722, 49723, 49724, 49725, 49726, 49727, 49729, 49730, 49731, 49733, 49734, 49735, 49736, 49737, 49738, 49740, 49741, 49742, 49743, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49751, 49752, 49753, 49762, 49878, 49894, 49906, 49918, 49923, 49930, 49944, 49946, 50009, 50037, 50043, 50060, 50076, 50088, 50125, 50133, 50147, 50160, 50178, 50199, 50217, 50221, 50224, 50226, 50229, 50230, 50231, 50232, 50234, 50235, 50237, 50238, 50239, 50240, 50242, 50243, 50245, 50246, 50247, 50248, 50250, 50253, 50256, 50257, 50259, 50262, 50263, 50264, 50265, 50267, 50268, 50270, 50271, 50272, 50273, 50275, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50285, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50293, 50294, 50295, 50296, 50297, 50298, 50299, 50302, 50303, 50304, 50305, 50306, 50307, 50308, 50310, 50312, 50313, 50314, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50806, 50809, 50814, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50830, 50832, 50833, 50834, 50835, 50837, 50838, 50840, 50841, 50845, 50848, 50849, 50850, 50851, 50853, 50854, 50856, 50857, 50858, 50859, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50872, 50873, 50874, 50875, 50877, 50878, 50879, 50882, 50883, 50884, 50885, 50887, 50890, 50891, 50893, 50894, 50895, 50896, 50897, 50900, 50901, 50902, 50903, 50905, 50906, 50907, 50908, 50909, 50910, 50911, 51378, 51381, 51383, 51386, 51388, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51403, 51405, 51407, 51408, 51410, 51411, 51413, 51415, 51416, 51419, 51420, 51421, 51423, 51424, 51425, 51428, 51430, 51431, 51433, 51434, 51437, 51438, 51441, 51444, 51445, 51446, 51447, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51455, 51457, 51460, 51461, 51462, 51463, 51464, 51465, 51466, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51475, 51476, 51477, 51478, 51479, 51944, 51947, 51950, 51953, 51957, 51967, 51971, 51976, 51978, 51981, 51988, 51991, 52004, 52013, 52021, 52024, 52026, 52033, 52035, 52037, 52041, 52045, 52052, 52526, 52528, 52535, 52539, 52556, 52586, 52588) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Search Filters

Event

Performance

Cast

Keyword

Performances

Mainpiece Title: As You Like It

Cast

Afterpiece Title: High Life below Stairs

Dance: End I: Dance-[probably Jamie's Return, as17890107

Song: In V: song-Miss Romanzini

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: All the World's a Stage

Cast

Performances

Mainpiece Title: As You Like It

Cast

Afterpiece Title: The Waterman

Song: As17890220

Performances

Mainpiece Title: A Trip To Scarborough

Cast

Afterpiece Title: The Irish Widow

Cast

Dance: End I: The Irish Fair-Hamoir, Miss Stageldoir

Performances

Mainpiece Title: King Henry The Eighth

Cast

Afterpiece Title: The Pannel

Performances

Mainpiece Title: A Trip To Scarborough

Cast

Afterpiece Title: The Farm House

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: The Critic

Cast

Dance: End: The Drunken Swiss-West (1st appearance in London these 10 years), Miss Stageldoir

Performances

Mainpiece Title: Romeo And Juliet

Cast

Afterpiece Title: The Toy Shop

Song: As17881117, but Vocal Parts-Miss Hagley, Miss _Collett

Entertainment: Monologue. End afterpiece: An Ode on the Recovery of His Majesty-Mrs Siddons; in the Character of Britannia. Conclude with: God save the King!-

Performances

Mainpiece Title: The Heiress

Afterpiece Title: The Critic

Cast

Song: End: The Welsh Cantata, The Bells of Aberdovey, composed by Dibdin-Williames

Entertainment: Monologue. After the Singing: as17890430

Performances

Mainpiece Title: A Trip To Scarborough

Cast

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Recruiting Serjeant

Afterpiece Title: Love for Love

Cast

Afterpiece Title: The Honest Yorkshireman

Song: End II 2nd piece: Wake Sons of Odin (composed by Stevens)-Sedgwick

Performances

Mainpiece Title: The Runaway

Cast

Afterpiece Title: The Minor

Song: Between acts: Miss Barnes

Entertainment: Monologue. As17890527

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Cast

Afterpiece Title: The Gentle Shepherd

Dance: End I afterpiece: Highland Reel, as17890527

Song: End II: Poor Jack!, as17890528

Entertainment: Monologue. As17890527

Performances

Mainpiece Title: As You Like It

Cast

Afterpiece Title: The Padlock

Dance: End I: The Irish Bird@Catchers, as17890519