Toggle Sphinx Query
SELECT * FROM london_stages WHERE eventid IN (1315, 1443, 1501, 1545, 1945, 2005, 2022, 2046, 2096, 2116, 2117, 2119, 2191, 2217, 2255, 2453, 2476, 2495, 2508, 2576, 2590, 2591, 2606, 2607, 2617, 2690, 2892, 3147, 3302, 3718, 3876, 3878, 3880, 3884, 3886, 3890, 3896, 3922, 3960, 3968, 4567, 4590, 4610, 5147, 5631, 5652, 5873, 6014, 6030, 6250, 6358, 6359, 6457, 6557, 6592, 6831, 6857, 6864, 6869, 6925, 7014, 7308, 7400, 7410, 7515, 7575, 7626, 7671, 7719, 7985, 9192, 9306, 9648, 10032, 10035, 10067, 10070, 10073, 10075, 10077, 10080, 10083, 10086, 10088, 10091, 10093, 10096, 10099, 10102, 10104, 10106, 10108, 10111, 10113, 10116, 10119, 10122, 10126, 10128, 10131, 10134, 10136, 10138, 10141, 10143, 10146, 10148, 10151, 10156, 10158, 10161, 10166, 10185, 10191, 10206, 10212, 10222, 10228, 10251, 10268, 10296, 10297, 10336, 10347, 10353, 10424, 10435, 10445, 10458, 10488, 10570, 10584, 10590, 10731, 10738, 10760, 10798, 10863, 11150, 11365, 11390, 11400, 11425, 11478, 11480, 11524, 11526, 11529, 11531, 11533, 11536, 11538, 11542, 11544, 11547, 11548, 11549, 11552, 11554, 11557, 11560, 11562, 11568, 11634, 11636, 11639, 11642, 11645, 11647, 11654, 11657, 11659, 11665, 11667, 11672, 11679, 11683, 11685, 11688, 11700, 11705, 11743, 11774, 11784, 11813, 11827, 11828, 11833, 11837, 11842, 11846, 11855, 11856, 11858, 11859, 11880, 11887, 11889, 11891, 11894, 11896, 11899, 11905, 11908, 11918, 11920, 11923, 11948, 11966, 11981, 11983, 11985, 11996, 11997, 12003, 12005, 12009, 12014, 12024, 12031, 12174, 12233, 12238, 12252, 12255, 12304, 12360, 12364, 12365, 12373, 12479, 12566, 12572, 12678, 12724, 12754, 12764, 12861, 12884, 12894, 12897, 12906, 12939, 12950, 12966, 12975, 13017, 13028, 13034, 13038, 13042, 13121, 13125, 13143, 13294, 13400, 13408, 13601, 13602, 13634, 13646, 13650, 13653, 13656, 13659, 13662, 13666, 13667, 13669, 13673, 13674, 13676, 13679, 13682, 13683, 13686, 13687, 13690, 13694, 13701, 13705, 13706, 13710, 13714, 13718, 13722, 13729, 13744, 13747, 13751, 13755, 13759, 13763, 13769, 13773, 13777, 13781, 13782, 13785, 13789, 13790, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13831, 13833, 13834, 13837, 13838, 13841, 13845, 13849, 13851, 13852, 13855, 13859, 13863, 13869, 13870, 13873, 13877, 13880, 13884, 13886, 13888, 13893, 13897, 13901, 13905, 13910, 13927, 13934, 13938, 13941, 13942, 13944, 13945, 13948, 13952, 13957, 13960, 13972, 13986, 13989, 13997, 14001, 14004, 14035, 14043, 14051, 14052, 14057, 14063, 14064, 14080, 14108, 14123, 14135, 14161, 14164, 14181, 14187, 14229, 14231, 14262, 14356, 14362, 14365, 14371, 14373, 14374, 14382, 14384, 14392, 14393, 14395, 14396, 14407, 14408, 14411, 14417, 14430, 14432, 14443, 14452, 14472, 14479, 14490, 14497, 14523, 14526, 14529, 14542, 14544, 14545, 14550, 14551, 14590, 14596, 14600, 14604, 14607, 14611, 14643, 14663, 14690, 14694, 14697, 14698, 14700, 14708, 14711, 14734, 14737, 14757, 14761, 14766, 14785, 14796, 14826, 14843, 14860, 14961, 14967, 14969, 14971, 15025, 15029, 15031, 15033, 15065, 15080, 15082, 15093, 15096, 15119, 15122, 15125, 15128, 15132, 15208, 15210, 15213, 15216, 15230, 15233, 15236, 15240, 15245, 15249, 15259, 15280, 15283, 15284, 15288, 15291, 15300, 15303, 15325, 15429, 15517, 15551, 15611, 15615, 15620, 15710, 15726, 15783, 15788, 15793, 15798, 15804, 15810, 15833, 15854, 15860, 15918, 15922, 15930, 15934, 15945, 15949, 15952, 15959, 15963, 15970, 15979, 15984, 15987, 16011, 16019, 16024, 16033, 16036, 16040, 16043, 16057, 16100, 16174, 16461, 16514, 16594, 16600, 16613, 16624, 16631, 16633, 16643, 16651, 16669, 16674, 16679, 16706, 16782, 16823, 16837, 16841, 16850, 16854, 16858, 16862, 16866, 16870, 16874, 16878, 16884, 16886, 16890, 16910, 16922, 16926, 16933, 16937, 16941, 16945, 16949, 16956, 16960, 16985, 16989, 16993, 17060, 17134, 17201, 17311, 17323, 17328, 17333, 17342, 17347, 17352, 17430, 17440, 17448, 17452, 17455, 17464, 17467, 17469, 17473, 17478, 17491, 17496, 17499, 17502, 17505, 17509, 17512, 17515, 17518, 17526, 17533, 17537, 17538, 17540, 17541, 17546, 17547, 17549, 17552, 17555, 17589, 17596, 17599, 17604, 17615, 17618, 17634, 17639, 17642, 17647, 17651, 17655, 17663, 17667, 17670, 17673, 17679, 17682, 17709, 17712, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17748, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17940, 18123, 18173, 18174, 18175, 18176, 18178, 18184, 18186, 18187, 18188, 18194, 18203, 18206, 18210, 18214, 18224, 18226, 18228, 18229, 18231, 18233, 18237, 18239, 18241, 18242, 18244, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18277, 18278, 18280, 18281, 18283, 18286, 18287, 18288, 18289, 18292, 18294, 18295, 18298, 18300, 18303, 18307, 18310, 18314, 18318, 18323, 18326, 18355, 18361, 18365, 18368, 18376, 18379, 18412, 18416, 18424, 18427, 18432, 18437, 18440, 18444, 18446, 18447, 18450, 18460, 18463, 18468, 18662, 18755, 18764, 18886, 18892, 18897, 18904, 18950, 18954, 18956, 18959, 18961, 18963, 18965, 18968, 18970, 18973, 18998, 19001, 19007, 19010, 19013, 19015, 19017, 19019, 19024, 19027, 19031, 19033, 19035, 19037, 19045, 19101, 19189, 19228, 19231, 19233, 19235, 19241, 19245, 19248, 19251, 19255, 19259, 19261, 19263, 19269, 19271, 19288, 19300, 19304, 19312, 19316, 19319, 19321, 19323, 19325, 19327, 19329, 19331, 19333, 19335, 19337, 19339, 19341, 19342, 19343, 19344, 19345, 19351, 19378, 19380, 19387, 19391, 19421, 19460, 19474, 19483, 19485, 19487, 19537, 19551, 19560, 19561, 19591, 19596, 19606, 19608, 19612, 19628, 19636, 19640, 19662, 19665, 19668, 19672, 19763, 19766, 19768, 19770, 19772, 19787, 19789, 19790, 19794, 19805, 19807, 19815, 19821, 19822, 19832, 19839, 19842, 19844, 19851, 19854, 19855, 19856, 19864, 19866, 19869, 19872, 19874, 19875, 19879, 19882, 19889, 19900, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19959, 19961, 19964, 19966, 19969, 19976, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20233, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20317, 20320, 20323, 20329, 20343, 20378, 20392, 20432, 20444, 20448, 20458, 20462, 20464, 20466, 20496, 20501, 20513, 20518, 20530, 20534, 20535, 20543, 20544, 20545, 20551, 20553, 20559, 20560, 20562, 20566, 20568, 20569, 20572, 20581, 20592, 20599, 20601, 20608, 20611, 20651, 20682, 21065, 21068, 21071, 21074, 21078, 21081, 21085, 21091, 21094, 21098, 21105, 21114, 21121, 21256, 21280, 21447, 21475, 21510, 21518, 21522, 21525, 21532, 21538, 21545, 21588, 21599, 21615, 21642, 21674, 21683, 21793, 21847, 22020, 22025, 22028, 22033, 22035, 22039, 22057, 22076, 22193, 22215, 22216, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22754, 22759, 22966, 22969, 23406, 23550, 23717, 23864, 24005, 24008, 24010, 24173, 24174, 24177, 24223, 24453, 24725, 24742, 25205, 25245, 25758, 25771, 25785, 25803, 25819, 25890, 25898, 25904, 25906, 25911, 25920, 25934, 25936, 25947, 25951, 25964, 25966, 25973, 25983, 25985, 25992, 26031, 26036, 26063, 26107, 26148, 26152, 26156, 26157, 26539, 26553, 26557, 26566, 26588, 26649, 26651, 26654, 26656, 26678, 26680, 26682, 26684, 26686, 26692, 26699, 26700, 26704, 26720, 26758, 26759, 26772, 26775, 26776, 26777, 26780, 26782, 26784, 26786, 26787, 26789, 26794, 26796, 26806, 26839, 26841, 26843, 26846, 26848, 26850, 26852, 26855, 26866, 26871, 26876, 26891, 26896, 26903, 26923, 26928, 26931, 26933, 26962, 26974, 26983, 26988, 26990, 27007, 27022, 27026, 27027, 27030, 27034, 27056, 27106, 27110, 27111, 27154, 27260, 27268, 27341, 27343, 27426, 27475, 27530, 27547, 27600, 27618, 27644, 27780, 27839, 27841, 27843, 27845, 27847, 27852, 27855, 27875, 27914, 27925, 27961, 27970, 27974, 27991, 28039, 28075, 28086, 28104, 28107, 28112, 28119, 28145, 28163, 28167, 28250, 28281, 28296, 28300, 28316, 28332, 28382, 28432, 28519, 28527, 28542, 28560, 28576, 28578, 28579, 28580, 28581, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28597, 28598, 28601, 28606, 28608, 28612, 28614, 28615, 28627, 28632, 28637, 28640, 28650, 28652, 28662, 28664, 28669, 28675, 28683, 28685, 28688, 28690, 28692, 28693, 28696, 28698, 28702, 28704, 28707, 28712, 28717, 28726, 28731, 28746, 28754, 28782, 28794, 28795, 28841, 28848, 28885, 28956, 29014, 29042, 29097, 29462, 29499, 29500, 29562, 29587, 29733, 29762, 29842, 29843, 29856, 29886, 29918, 29922, 29925, 29928, 29930, 29933, 29939, 29944, 29950, 29955, 29966, 29974, 29977, 30049, 30056, 30057, 30058, 30064, 30069, 30073, 30076, 30079, 30084, 30085, 30106, 30121, 30131, 30146, 30150, 30151, 30154, 30275, 30277, 30278, 30279, 30280, 30281, 30284, 30285, 30297, 30307, 30309, 30311, 30315, 30321, 30322, 30323, 30326, 30328, 30329, 30330, 30337, 30369, 30375, 30382, 30383, 30384, 30386, 30394, 30408, 30409, 30410, 30411, 30414, 30416, 30420, 30421, 30428, 30433, 30437, 30442, 30449, 30450, 30456, 30461, 30464, 30466, 30471, 30503, 30508, 30521, 30531, 30536, 30543, 30545, 30547, 30554, 30559, 30565, 30566, 30575, 30576, 30588, 30592, 30593, 30604, 30606, 30609, 30622, 30633, 30636, 30645, 30646, 30649, 30653, 30657, 30658, 30659, 30666, 30681, 30683, 30684, 30685, 30686, 30689, 30690, 30695, 30699, 30711, 30712, 30749, 30750, 30751, 30753, 30754, 30756, 30758, 30760, 30762, 30763, 30764, 30765, 30766, 30767, 30768, 30773, 30774, 30776, 30778, 30781, 30784, 30800, 30803, 30805, 30883, 30901, 30903, 30906, 30908, 30911, 30913, 30915, 30917, 30920, 30923, 30925, 30927, 30929, 30931, 30934, 30936, 30938, 30941, 30943, 30945, 30948, 30951, 30953, 30957, 30959, 30962, 30965, 30968, 30970, 30972, 30974, 30977, 30982, 30984, 30986, 30988, 30990, 30992, 30994, 30996, 30999, 31002, 31004, 31008, 31010, 31013, 31020, 31024, 31027, 31029, 31032, 31034, 31038, 31044, 31046, 31067, 31073, 31080, 31095, 31107, 31109, 31111, 31121, 31122, 31125, 31132, 31135, 31140, 31145, 31147, 31155, 31166, 31179, 31180, 31199, 31230, 31246, 31262, 31278, 31295, 31321, 31329, 31347, 31359, 31371, 31383, 31392, 31398, 31400, 31402, 31404, 31406, 31408, 31410, 31412, 31413, 31416, 31420, 31425, 31429, 31436, 31438, 31444, 31452, 31456, 31460, 31463, 31501, 31503, 31509, 31516, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31571, 31647, 31685, 31700, 31712, 31908, 31928, 31936, 31942, 32004, 32039, 32041, 32045, 32047, 32049, 32051, 32054, 32057, 32059, 32061, 32063, 32064, 32066, 32068, 32078, 32083, 32090, 32095, 32097, 32102, 32106, 32114, 32131, 32139, 32156, 32163, 32180, 32209, 32224, 32256, 32258, 32261, 32297, 32328, 32345, 32417, 32448, 32451, 32453, 32455, 32458, 32460, 32474, 32694, 32824, 32843, 32857, 32899, 33035, 33041, 33053, 33063, 33087, 33101, 33164, 33173, 33387, 33391, 33410, 33415, 33417, 33424, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33456, 33457, 33460, 33462, 33465, 33466, 33467, 33470, 33471, 33474, 33476, 33479, 33489, 33491, 33494, 33496, 33501, 33510, 33517, 33524, 33527, 33529, 33555, 33572, 33575, 33603, 33608, 33616, 33626, 33633, 33670, 33679, 33699, 33700, 34125, 34211, 34251, 34374, 34375, 34377, 34380, 34384, 34390, 34394, 34397, 34400, 34406, 34410, 34415, 34418, 34453, 34485, 34521, 34576, 34578, 34584, 34586, 34588, 34590, 34598, 34599, 34629, 34643, 34668, 34694, 34713, 34722, 34723, 34725, 34739, 34754, 34759, 34782, 34785, 34794, 34805, 34885, 34910, 34956, 34962, 34964, 34967, 34969, 34971, 34973, 34976, 34978, 34981, 34983, 34985, 34987, 34990, 34995, 34997, 34999, 35001, 35004, 35006, 35009, 35011, 35013, 35020, 35046, 35056, 35061, 35063, 35065, 35067, 35069, 35071, 35073, 35077, 35095, 35098, 35100, 35114, 35203, 35221, 35229, 35273, 35282, 35300, 35317, 35337, 35349, 35358, 35379, 35397, 35462, 35477, 35486, 35555, 35562, 35564, 35821, 35832, 35940, 35962, 35983, 36005, 36060, 36141, 36143, 36145, 36412, 36447, 36464, 36523, 36529, 36693, 36807, 36967, 36978, 37036, 37037, 37052, 37058, 37068, 37071, 37073, 37086, 37096, 37186, 37246, 37250, 37252, 37263, 37279, 37291, 37302, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37439, 37460, 37467, 37479, 37517, 37526, 37593, 37646, 37649, 37698, 37726, 37737, 37739, 37787, 37790, 37799, 37815, 37835, 37845, 37847, 37849, 37852, 37854, 37858, 37860, 37862, 37866, 37868, 37871, 37873, 37875, 37876, 37878, 37879, 37883, 37884, 37888, 37891, 37892, 37900, 37901, 37903, 37908, 37911, 37912, 37915, 37916, 37917, 37919, 37926, 37929, 37942, 37943, 37944, 37945, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37960, 37961, 37975, 37987, 38018, 38042, 38067, 38096, 38097, 38115, 38118, 38133, 38141, 38151, 38153, 38172, 38224, 38225, 38233, 38248, 38252, 38314, 38315, 38322, 38328, 38334, 38341, 38342, 38367, 38379, 38384, 38418, 38480, 38506, 38586, 38591, 38630, 38651, 38661, 38666, 38682, 38703, 38719, 38743, 38863, 38887, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38953, 38960, 38970, 38982, 38989, 38994, 38996, 38999, 39001, 39007, 39022, 39024, 39050, 39061, 39075, 39078, 39083, 39087, 39095, 39103, 39104, 39142, 39149, 39181, 39202, 39214, 39225, 39258, 39268, 39299, 39780, 39801, 39850, 39867, 39876, 39878, 39887, 40278, 40896, 40905, 40930, 40951, 40956, 40960, 41102, 41103, 41104, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41167, 41172, 41177, 41182, 41185, 41188, 41476, 41485, 41487, 41491, 41494, 41496, 41500, 41503, 41505, 41507, 41508, 41509, 41510, 41513, 41514, 41518, 41522, 41527, 41529, 41531, 41532, 41533, 41534, 41538, 41542, 41544, 41547, 41548, 41559, 41562, 41564, 41568, 41569, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 41661, 41724, 41728, 41731, 41732, 41736, 41758, 41762, 41773, 41822, 41862, 41922, 42091, 42147, 42152, 42187, 42194, 42198, 42222, 42226, 42227, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42292, 42296, 42359, 42393, 42519, 42589, 42648, 42721, 42726, 42728, 42735, 42764, 42766, 42767, 42770, 42772, 42780, 42784, 42788, 42793, 42796, 42813, 42820, 42831, 42833, 42834, 42835, 42837, 42847, 42849, 43087, 43096, 43102, 43111, 43116, 43125, 43131, 43135, 43139, 43144, 43153, 43159, 43164, 43168, 43174, 43186, 43189, 43201, 43206, 43208, 43225, 43230, 43245, 43250, 43262, 43265, 43266, 43271, 43275, 43276, 43281, 43286, 43287, 43296, 43301, 43306, 43320, 43324, 43328, 43331, 43336, 43338, 43341, 43345, 43348, 43351, 43354, 43359, 43362, 43367, 43380, 43388, 43390, 43398, 43399, 43402, 43407, 43415, 43420, 43423, 43562, 43729, 43747, 43781, 43806, 43807, 43813, 43824, 43842, 43853, 43958, 43980, 44001, 44025, 44031, 44078, 44104, 44112, 44116, 44128, 44132, 44136, 44148, 44152, 44156, 44158, 44160, 44162, 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, 44309, 44329, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44469, 44529, 44538, 44544, 44546, 44566, 44570, 44580, 44895, 44906, 44909, 44922, 44943, 44995, 44997, 45019, 45034, 45350, 45362, 45370, 45375, 45382, 45387, 45391, 45404, 45421, 45426, 45447, 45452, 45507, 45519, 45525, 45527, 45530, 45545, 45548, 45601, 45620, 45633, 45635, 45637, 45639, 45641, 45643, 45647, 45653, 45655, 45656, 45657, 45658, 45660, 45670, 45674, 45677, 45678, 45682, 45687, 45689, 45973, 45995, 45999, 46000, 46009, 46013, 46025, 46026, 46047, 46048, 46065, 46075, 46095, 46133, 46267, 46334, 46339, 46517, 46526, 46527, 46530, 46531, 46540, 46541, 46545, 46554, 46555, 46558, 46559, 46568, 46569, 46573, 46582, 46583, 46587, 46588, 46598, 46617, 46687, 46695, 46701, 46722, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46947, 46953, 46955, 46963, 47001, 47005, 47013, 47025, 47037, 47049, 47061, 47066, 47071, 47076, 47083, 47088, 47091, 47104, 47111, 47112, 47121, 47125, 47126, 47135, 47136, 47137, 47140, 47141, 47142, 47145, 47151, 47153, 47154, 47157, 47158, 47159, 47162, 47163, 47167, 47168, 47169, 47170, 47171, 47174, 47176, 47180, 47184, 47187, 47189, 47190, 47193, 47195, 47196, 47199, 47205, 47207, 47215, 47218, 47221, 47227, 47232, 47239, 47245, 47250, 47253, 47256, 47258, 47259, 47262, 47267, 47273, 47274, 47277, 47279, 47280, 47286, 47292, 47296, 47298, 47304, 47308, 47310, 47312, 47317, 47320, 47326, 47332, 47336, 47343, 47354, 47358, 47364, 47365, 47440, 47446, 47521, 47537, 47541, 47543, 47549, 47555, 47557, 47561, 47568, 47575, 47701, 47702, 47709, 47712, 47717, 47722, 47724, 47726, 47727, 47732, 47741, 47742, 47746, 47747, 47756, 47757, 47761, 47762, 47771, 47776, 47777, 47783, 47800, 47805, 47820, 47835, 47869, 47885, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48230, 48231, 48240, 48244, 48245, 48255, 48268, 48269, 48272, 48273, 48282, 48283, 48286, 48296, 48297, 48301, 48309, 48311, 48320, 48322, 48358, 48366, 48368, 48384, 48404, 48409, 48411, 48430, 48674, 48921, 48940, 48954, 48964, 48966, 48968, 48970, 49067, 49134, 49135, 49137, 49165, 49167, 49170, 49175, 49178, 49182, 49207, 49236, 49239, 49255, 49257, 49268, 49270, 49272, 49274, 49276, 49278, 49279, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49301, 49304, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49328, 49330, 49333, 49335, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49364, 49366, 49368, 49370, 49371, 49373, 49376, 49378, 49380, 49382, 49385, 49387, 49390, 49392, 49394, 49396, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49446, 49452, 49459, 49460, 49465, 49467, 49469, 49470, 49473, 49475, 49480, 49483, 49487, 49488, 49498, 49502, 49511, 49515, 49520, 49521, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49559, 49560, 49565, 49570, 49575, 49578, 49580, 49585, 49589, 49592, 49602, 49604, 49607, 49612, 49616, 49622, 49627, 49634, 49635, 49640, 49644, 49648, 49650, 49655, 49657, 49662, 49667, 49714, 49727, 49769, 49777, 49783, 49794, 49805, 49815, 49817, 49819, 49824, 49837, 49849, 49886, 49891, 49897, 49900, 49902, 49904, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49937, 49938, 49940, 49943, 49945, 49947, 49949, 49951, 49952, 49953, 49954, 49956, 49957, 49958, 49959, 49960, 49961, 49962, 49965, 49966, 49967, 49968, 49970, 49971, 49972, 49974, 49977, 49978, 49979, 49980, 49982, 49983, 49984, 49985, 49986, 49987, 49988, 49989, 49991, 49992, 49993, 49994, 49997, 49998, 50000, 50001, 50003, 50004, 50005, 50006, 50009, 50010, 50012, 50013, 50015, 50016, 50018, 50019, 50021, 50022, 50023, 50024, 50025, 50026, 50028, 50029, 50030, 50031, 50033, 50035, 50036, 50038, 50041, 50044, 50048, 50052, 50057, 50059, 50060, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50081, 50082, 50087, 50089, 50092, 50096, 50097, 50099, 50101, 50104, 50105, 50107, 50108, 50111, 50113, 50115, 50116, 50117, 50118, 50120, 50122, 50128, 50130, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50177, 50184, 50186, 50189, 50193, 50195, 50200, 50203, 50207, 50215, 50330, 50353, 50356, 50358, 50360, 50361, 50368, 50374, 50378, 50380, 50385, 50387, 50389, 50399, 50403, 50409, 50417, 50438, 50454, 50458, 50488, 50497, 50502, 50511, 50558, 50562, 50623, 50625, 50627, 50633, 50644, 50647, 50650, 50652, 50654, 50656, 50659, 50662, 50664, 50668, 50669, 50671, 50674, 50676, 50680, 50682, 50697, 50699, 50709, 50712, 50717, 50722, 50726, 50728, 50747, 50749, 50754, 50757, 50759, 50761, 50766, 50784, 50790, 50795, 50800, 50802, 50837, 50843, 50849, 50853, 50858, 50859, 50867, 50870, 50877, 50880, 50919, 50925, 50937, 50939, 50941, 50943, 50945, 50947, 50949, 50954, 50957, 50972, 50977, 51035, 51050, 51055, 51062, 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, 51140, 51159, 51161, 51164, 51166, 51168, 51170, 51179, 51185, 51187, 51191, 51194, 51197, 51198, 51199, 51204, 51206, 51209, 51211, 51213, 51215, 51218, 51229, 51237, 51241, 51242, 51247, 51249, 51254, 51256, 51258, 51263, 51266, 51268, 51273, 51285, 51290, 51298, 51304, 51306, 51312, 51317, 51319, 51322, 51327, 51329, 51336, 51338, 51340, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51362, 51363, 51365, 51368, 51371, 51405, 51415, 51420, 51428, 51430, 51434, 51435, 51438, 51440, 51442, 51445, 51453, 51459, 51463, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51625, 51627, 51631, 51636, 51637, 51639, 51641, 51651, 51662, 51665, 51676, 51711, 51719, 51731, 51732, 51757, 51769, 51772, 51794, 51797, 51803, 51817, 51820, 51822, 51825, 51828, 51831, 51833, 51836, 51841, 51843, 51859, 51861, 51869, 51871, 51877, 51879, 51885, 51907, 51909, 51927, 51929, 51989, 51999, 52004, 52008, 52044, 52049, 52050, 52051, 52053, 52099, 52108, 52128, 52176, 52274, 52277, 52289, 52294, 52296, 52300, 52303, 52317, 52324, 52329, 52332, 52341, 52344, 52347, 52348, 52351, 52353, 52356, 52357, 52359, 52360, 52365, 52391, 52396, 52400, 52408, 52415, 52417, 52418, 52425, 52427, 52429, 52432, 52434, 52439, 52442, 52444, 52447, 52449, 52452, 52456, 52458, 52461, 52466, 52473, 52476, 52485, 52490, 52504, 52505, 52511, 52562, 52601) 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

?
New Search
3126 results for: Roles - and the Re

2851
15 May 1797 @ Covent Garden

Performances

Mainpiece Title: Abroad And At Home

Afterpiece Title: Raymond and Agnes

Cast
Role: Theodore Actor: Simmons
Role: Spectre of the Bleeding Nun Actor: Mlle St.Amand
Role: The Bed Actor: room prepared for Raymondv. Maugerette wishing to preserve the life of Raymond from the assassins, conveys a Pillow stained with blood upon his bed, thereby to inform him of his danger. She conceals herself. Raymond retires to rest, but is prevented by finding the bloody Pillow, and struck with horror, falls into a swoon. Robert enters, attempts to murder him, is prevented by Maugerette
Role: When the castle Actor: bell tolls One. Expect me like this bleeding Nun." X. The Outside of the Castle, as beforev. Raymond descends the Wall
Role: and the Piece concludes with aFinale and Spanish F Actor: .

2852
16 May 1797 @ Covent Garden

Performances

Mainpiece Title: The Man Of The World

Cast
Role: Serjeant Eitherside Actor: Macready

Afterpiece Title: An Entremets

Cast
Role: The Story of Lord Hoppergollop's Cook and Garde Actor: Munden

Afterpiece Title: Peeping Tom

2853
18 May 1797 @ Covent Garden

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Afterpiece Title: The Village Fete

Cast
Role: Peter the Preacher Actor: Townsend

Afterpiece Title: Peeping Tom

Cast
Role: The Story of Lord Hoppergollop's Cook and Garde Actor: Munden

Song: 2nd piece: Chorusses-Blurton, Abbot, Simmons, Hawtin, Curties, Lee, Little, Sawyer, Tett, J. Linton, Wilde, Thomas, Oddwell, Cranfield, Mrs Castelle, Mrs Masters, Mrs Watts, Miss Leserve, Mrs Norton, Mrs Lloyd, Mrs Follett, Miss Walcup, Mrs Henley, Miss Owen, Miss Gray

2854
19 May 1797 @ Covent Garden

Performances

Mainpiece Title: The Jew

Afterpiece Title: The Honest Thieves

Cast
Role: Commandant Actor: Claremont

Afterpiece Title: The Village Fete

Cast
Role: Peter the Preacher Actor: Townsend
Role: The Story of Lord Hoppergollop's Cook and Garde Actor: Munden

Song: End: Wigs-, including His own Wig, Doctor's Wig, Coachman's Wig; The Storm-Incledon; In 3rd piece: Chorusses, As17970518

2855
20 May 1797 @ Covent Garden

Performances

Mainpiece Title: The Woodman

Afterpiece Title: The Rendezvous

Cast
Role: Jack at the Windlass Actor: Fawcett
Role: Thursday in the morn Actor: Incledon
Role: Constitution and King Actor: Incledon, Bowden

Afterpiece Title: The Irishman in London

Song: End I: The Storm-Incledon; End II: Shakespeare's Loadsters (1st time in public; composed by Shield)-Incledon, Gray, Bowden; In 3rd piece: the Planxty, descriptive of Ireland, In my Father's Mud Cabin-Johnstone; End I 3rd piece: Old Towler-Incledon

2856
22 May 1797 @ Drury Lane Theatre

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Baron of Oakland Actor: Hollingsworth

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Sir Rowland Actor: Barrymore
Role: The Horde Actor: Wentworth, Maddocks, Welsh, Evans, Annereau.

Dance: End I: The Camp-[i.e. Les Delassements Militaires] (by permission of the Proprietor of the Opera House); End afterpiece: Cupid and Psyche-Mme Rose, Didelot, Mlle Parisot, Gentili, Fialon, Mme Hilligsberg, with Corps de Ballet from the Opera House [will appear, positively for that night only

Cast
Role: Cupid and Psyche Actor: Mme Rose, Didelot, Mlle Parisot, Gentili, Fialon, Mme Hilligsberg, with Corps de Ballet from the Opera House

2857
24 May 1797 @ Drury Lane Theatre

Performances

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

Afterpiece Title: Linco's Travels

Afterpiece Title: The Smugglers

Entertainment: Monologue. End I: Kitty Conolly and Jack the Painter (Very lately Versified, and never before presented to the Public)-King

Cast
Role: Kitty Conolly and Jack the Painter Actor: King.

2858
01 June 1797 @ Covent Garden

Performances

Mainpiece Title: The Mask'd Friend

Cast
Role: Sir Harry Portland Actor: Macready

Afterpiece Title: Lock and Key

Cast
Role: Servants and Sailors Actor: Gray, Lee, Street

Afterpiece Title: Raymond and Agnes

Cast
Role: Theodore Actor: Simmons
Role: Spectre of the Bleeding Nun Actor: Mlle St.Amand
Role: The Bed Actor: room prepared for Raymondv. Maugerette wishing to preserve the life of Raymond from the assassins, conveys a Pillow stained with blood upon his bed, thereby to inform him of his danger. She conceals herself. Raymond retires to rest, but is prevented by finding the bloody Pillow, and struck with horror, falls into a swoon. Robert enters, attempts to murder him, is prevented by Maugerette
Role: When the castle Actor: bell tolls One. Expect me like this bleeding Nun." X. The Outside of the Castle, as beforev. Raymond descends the Wall
Role: and the Piece concludes with aFinale and Spanish F Actor: .

Song: The Mid Watch, The Storm-Incledon

2859
05 June 1797 @ Covent Garden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Waterman

Afterpiece Title: Harlequin and Oberon

Cast
Role: Father Actor: Hawtin

Entertainment: Vaudeville. In 3rd piece: (for that Night only) a Leap through a Wheel of Fire@Works and a Hoop of Daggers-Simpson

Cast
Role: a Leap through a Wheel of Fire@Works and a Actor: Simpson.

2860
07 June 1797 @ Covent Garden

Performances

Mainpiece Title: A Cure For The Heart Ache

Cast
Role: Jessy Oatland Actor: Mrs Mountain of Miss Wallis.
Role: Frank Oatland Actor: Fawcett
Role: Farmer Oatland Actor: Waddy
Role: Landlord Actor: Thompson

Afterpiece Title: The Honest Thieves

Cast
Role: Commandant Actor: Claremont
Role: Peter the Preacher Actor: Townsend
Role: The Story of Lord Hoppergollop's Cook and Garde Actor: Munden

2861
09 June 1797 @ Covent Garden

Performances

Mainpiece Title: The Mask'd Friend

Cast
Role: Sir Harry Portland Actor: Macready

Afterpiece Title: The Folly of Age; or, The Accomplished Lady

Afterpiece Title: Barataria

Cast
Role: Mary the Buxom Actor: Mrs Delpini

Afterpiece Title: Harlequin's Medley

Cast
Role: Mother Actor: Mrs Lloyd

Dance: In 2nd piece: A la Parisot, Le Pas Russe-Delpini

Song: In 2nd piece: La Verginella, My dear Molly@oh! what Folly (composed by Carter)-Delpini

Entertainment: Vaudeville. In 4th piece: The Farm Yard- (from The Rape of Proserpine), with the Birth of Harlequin, and his Emancipation from the Egg Shell; The favorite Scene from Aladin of Pantaloon's Death-, and the Whimsical Lamentation of Pierrot; A Jump through a Hogshead of Fire-; and the celebrated Dying and Skeleton Scenes-

Cast
Role: The Farm Yard Actor:
Role: The favorite Scene from Aladin of Pantaloon Actor: , and the Whimsical Lamentation of Pierrot
Role: and the celebrated Dying and Skeleton Scenes Actor: .

2862
10 June 1797 @ Covent Garden

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Waterman

Cast
Role: Father Actor: Hawtin

Afterpiece Title: The Honest Thieves

Cast
Role: Commandant Actor: Claremont
Role: Peter the Preacher Actor: Townsend
Role: The Story of Lord Hoppergollop's Cook and Garde Actor: Munden

Song: In 2nd piece: The Heaving of the Lead, The Storm-Incledon

2863
03 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Lock and Key

Cast
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2864
08 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: Zorinski

Afterpiece Title: Lock and Key

Cast
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2865
13 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: Cross Purposes

Afterpiece Title: The London Hermit

Cast
Role: Sir Matthew Medley Actor: Davenport
Role: The Mogul Actor: C. Kemble

Afterpiece Title: Lock and Key

Cast
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2866
17 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: The Purse

Afterpiece Title: The Heir at Law

Cast
Role: Henry Morland Actor: C. Kemble

Afterpiece Title: Cross Purposes

Cast
Role: Sir Matthew Medley Actor: Davenport
Role: The Mogul Actor: C. Kemble
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2867
21 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Cast
Role: called The Tight Irish Boy Actor: Johnstone

Afterpiece Title: Cross Purposes

Cast
Role: Sir Matthew Medley Actor: Davenport
Role: The Mogul Actor: C. Kemble
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2868
22 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Lock and Key

Cast
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2869
29 July 1797 @ Haymarket Theatre

Performances

Mainpiece Title: The Purse

Cast
Role: Theodore Actor: Palmer Jun.

Afterpiece Title: The Heir at Law

Cast
Role: The Mogul Actor: C. Kemble

Afterpiece Title: Cross Purposes

Cast
Role: Sir Matthew Medley Actor: Davenport
Role: The Mogul Actor: C. Kemble
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2870
01 August 1797 @ Haymarket Theatre

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Cast
Role: Landlady Actor: Mrs Hale

Afterpiece Title: The Purse

Cast
Role: The Mogul Actor: C. Kemble
Role: Sir Matthew Medley Actor: Davenport
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

Song: As17970705

2871
09 August 1797 @ Haymarket Theatre

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Mountaineers

Cast
Role: Goatherds Actor: Davenport, Waldron Jun.
Role: Floranthe Actor: Miss DeCamp

Afterpiece Title: Cross Purposes

Cast
Role: called The Tight Irish Boy Actor: Johnstone
Role: Sir Matthew Medley Actor: Davenport
Role: The Mogul Actor: C. Kemble
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2872
12 August 1797 @ Haymarket Theatre

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Lock and Key

Cast
Role: Sailors and Servants Actor: Linton, Walker, Abbot, Lyons

2873
25 September 1797 @ Covent Garden

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Lock and Key

Cast
Role: Servants and Sailors Actor: Gray, Lee, Street

Song: In V: Dirge set to Music by Shield-; Vocal Parts-Mrs Martyr, Mrs Clendining, Mrs Henley, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Linton, Street, Gray

2874
02 October 1797 @ Covent Garden

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: A Divertisement

Cast
Role: I'm jolly Dick the Lamplighter Actor: Gray
Role: Of the Ancients its speaking Actor: Johnstone
Role: The Greenwich Pensioner 'Twas in the good ship Actor: Townsend
Role: Dear Yanco say and true he say Actor: Mrs Mountain
Role: Sure an't the world a Masquerade Actor: Johnstone, Chorus.

Dance: In afterpiece: a Ballet-Blurton, Mrs Watts, Mlle St.Amand

2875
13 October 1797 @ Covent Garden

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: A Divertisement

Cast
Role: I'm jolly Dick the Lamplighter Actor: Gray
Role: Of the Ancients its speaking Actor: Johnstone
Role: The Greenwich Pensioner 'Twas in the good ship Actor: Townsend
Role: Dear Yanco say and true he say Actor: Mrs Mountain
Role: Sure an't the world a Masquerade Actor: Johnstone, Chorus.

Dance: Ballet, as17971002, but Mrs _Watts