SELECT * FROM london_stages WHERE eventid IN (517, 1691, 1711, 1791, 2481, 2961, 3209, 3790, 3806, 3815, 3816, 3985, 3988, 3994, 4065, 4080, 4085, 4176, 4270, 4272, 4397, 4693, 4783, 4814, 4823, 4939, 5183, 5469, 5737, 5739, 5922, 6015, 6097, 6564, 6933, 7004, 7009, 7012, 7534, 7653, 7664, 7888, 7950, 8025, 8123, 8138, 8253, 8360, 8362, 8363, 8369, 8404, 8421, 8573, 8587, 8756, 8780, 8848, 8906, 8955, 9052, 9178, 9224, 9295, 9396, 9430, 9485, 9535, 9587, 9601, 9603, 9640, 9782, 9796, 9819, 9942, 9959, 10065, 10175, 10260, 10329, 10344, 10438, 10497, 10615, 10718, 10740, 10763, 10820, 10922, 10939, 10971, 10984, 11274, 11279, 11766, 11992, 12000, 12111, 12150, 12216, 12315, 12550, 12658, 12661, 12742, 12752, 12873, 12929, 13176, 13330, 13345, 13367, 13407, 13556, 13559, 13637, 13740, 13754, 13762, 13804, 13911, 13915, 14137, 14207, 14252, 14295, 14417, 14653, 14830, 15009, 15497, 15600, 15758, 15818, 16000, 16366, 16388, 16412, 16433, 16579, 17030, 17035, 17037, 17038, 17043, 17044, 17050, 17051, 17060, 17066, 17098, 17167, 17199, 17224, 17249, 17293, 17347, 17352, 17434, 17604, 17846, 17873, 17883, 17890, 17916, 17925, 18050, 18140, 18175, 18185, 18187, 18189, 18192, 18195, 18210, 18232, 18340, 18344, 18378, 18495, 18571, 18682, 18741, 18763, 18769, 18795, 18861, 18894, 18899, 18960, 19077, 19078, 19084, 19171, 19181, 19186, 19245, 19355, 19427, 19454, 19541, 19553, 19589, 19600, 19615, 19658, 19686, 19752, 19798, 19834, 19853, 19888, 19911, 20024, 20038, 20060, 20097, 20179, 20300, 20340, 20576, 20631, 20682, 20714, 21350, 21373, 21535, 21765, 21827, 22001, 22109, 22238, 22246, 22332, 22522, 22620, 22793, 22857, 22933, 22981, 23265, 23543, 23549, 23637, 23866, 24019, 24071, 24496, 24742, 25012, 25022, 25029, 25102, 25274, 25325, 25526, 25532, 25580, 25698, 25729, 25902, 26022, 26137, 26329, 26338, 26341, 26361, 26386, 26991, 27223, 28072, 28351, 28355, 28358, 28374, 28379, 28454, 28856, 29033, 29302, 29304, 29616, 29989, 30026, 30080, 30110, 30156, 30187, 30261, 30396, 30399, 30552, 30664, 30700, 30893, 30894, 30905, 30912, 30924, 30942, 30968, 30973, 30991, 31023, 31069, 31182, 31218, 31224, 31255, 31309, 31468, 31469, 31471, 31473, 31475, 31478, 31481, 31483, 31485, 31487, 31489, 31492, 31495, 31499, 31505, 31507, 31511, 31514, 31518, 31522, 31527, 31538, 31543, 31549, 31551, 31557, 31565, 31570, 31575, 31584, 31588, 31592, 31595, 31600, 31603, 31606, 31630, 31634, 31643, 31661, 31665, 31668, 31676, 31697, 31706, 31727, 31746, 31774, 31850, 31888, 31904, 31906, 31914, 31916, 31918, 31924, 31926, 31931, 31938, 31945, 31961, 31975, 32008, 32084, 32122, 32135, 32144, 32147, 32186, 32199, 32246, 32259, 32263, 32314, 32338, 32449, 32487, 32496, 32528, 32530, 32533, 32536, 32539, 32542, 32736, 32826, 32853, 32875, 32885, 32904, 32909, 32916, 32936, 33018, 33040, 33055, 33071, 33089, 33113, 33142, 33150, 33159, 33203, 33214, 33215, 33217, 33218, 33227, 33228, 33229, 33234, 33240, 33246, 33286, 33294, 33303, 33316, 33323, 33345, 33349, 33361, 33379, 33405, 33407, 33452, 33480, 33521, 33577, 33584, 33627, 33672, 33705, 33718, 33723, 33726, 33727, 33730, 33732, 33733, 33736, 33738, 33739, 33741, 33742, 33756, 33762, 33769, 33772, 33777, 33779, 33783, 33785, 33801, 33808, 33816, 33819, 33852, 33892, 33918, 33927, 33981, 34006, 34019, 34041, 34044, 34046, 34049, 34051, 34053, 34056, 34059, 34061, 34064, 34073, 34087, 34145, 34147, 34190, 34219, 34225, 34230, 34242, 34244, 34249, 34253, 34347, 34362, 34363, 34450, 34497, 34512, 34548, 34590, 34603, 34606, 34607, 34608, 34616, 34619, 34621, 34627, 34631, 34634, 34635, 34636, 34652, 34712, 34720, 34749, 34752, 34753, 34766, 34777, 34786, 34823, 34832, 34837, 34850, 34854, 34863, 34881, 34888, 34895, 34903, 34923, 34926, 34931, 34941, 34957, 34981, 35011, 35038, 35069, 35094, 35103, 35105, 35117, 35141, 35173, 35178, 35244, 35294, 35296, 35297, 35302, 35316, 35332, 35343, 35344, 35348, 35351, 35390, 35436, 35492, 35545, 35692, 35705, 35957, 36104, 36124, 36133, 36153, 36526, 36539, 36581, 36608, 36635, 36638, 36789, 36873, 37033, 37049, 37052, 37073, 37109, 37125, 37135, 37149, 37175, 37189, 37207, 37640, 37643, 37693, 37705, 37773, 37994, 38015, 38052, 38227, 38241, 38257, 38268, 38274, 38280, 38288, 38291, 38292, 38293, 38296, 38300, 38305, 38320, 38338, 38363, 38406, 38415, 38714, 38763, 38780, 38807, 38829, 38837, 38843, 38867, 38881, 38886, 38887, 38889, 39033, 39255, 39383, 39399, 39410, 39412, 39418, 39450, 39455, 39467, 39647, 39654, 39658, 39792, 39806, 39832, 39849, 39893, 39896, 39905, 39909, 39915, 39925, 39940, 39954, 39991, 40016, 40036, 40203, 40267, 40272, 40295, 40308, 40309, 40320, 40393, 40444, 40469, 40471, 40508, 40533, 40599, 40664, 40668, 40671, 40673, 40676, 40678, 40717, 40732, 40756, 40775, 40783, 40812, 40818, 40915, 40972, 40999, 41012, 41107, 41123, 41124, 41128, 41165, 41201, 41213, 41260, 41469, 41582, 41588, 41635, 41637, 41642, 41644, 41649, 41668, 41675, 41676, 41687, 41740, 41742, 41744, 41746, 41748, 41750, 41752, 41754, 41756, 41757, 41758, 41760, 41769, 41773, 41783, 41787, 41789, 41792, 41796, 41801, 41806, 41811, 41817, 41825, 41848, 41855, 41907, 41917, 41930, 41935, 41944, 41970, 41975, 41989, 41997, 42002, 42015, 42041, 42053, 42100, 42107, 42116, 42123, 42184, 42203, 42207, 42247, 42249, 42255, 42258, 42271, 42289, 42292, 42296, 42309, 42315, 42331, 42359, 42368, 42393, 42395, 42407, 42465, 42475, 42491, 42517, 42519, 42589, 42681, 42701, 42706, 42733, 42734, 42753, 42758, 42764, 42767, 42770, 42774, 42778, 42782, 42790, 42805, 42836, 42837, 42840, 42843, 42855, 42859, 42863, 42865, 42878, 42892, 42902, 42945, 43002, 43014, 43099, 43107, 43122, 43130, 43184, 43198, 43199, 43216, 43218, 43227, 43253, 43270, 43299, 43304, 43305, 43326, 43329, 43330, 43332, 43333, 43337, 43339, 43340, 43346, 43350, 43352, 43355, 43370, 43412, 43442, 43464, 43467, 43471, 43483, 43554, 43579, 43584, 43593, 43607, 43622, 43623, 43630, 43642, 43662, 43664, 43780, 43794, 43854, 43887, 43890, 43917, 43922, 43927, 43931, 43947, 43957, 43962, 43968, 43988, 44004, 44023, 44046, 44065, 44113, 44139, 44214, 44256, 44261, 44276, 44308, 44315, 44327, 44436, 44451, 44475, 44489, 44492, 44527, 44528, 44538, 44542, 44566, 44570, 44580, 44598, 44619, 44641, 44643, 44647, 44648, 44655, 44673, 44680, 44698, 44731, 44741, 44746, 44760, 44803, 44859, 44863, 44884, 44896, 44946, 44952, 44972, 44975, 44979, 45045, 45067, 45082, 45087, 45111, 45114, 45144, 45150, 45154, 45190, 45259, 45266, 45278, 45301, 45315, 45318, 45361, 45389, 45420, 45424, 45495, 45497, 45504, 45511, 45526, 45554, 45636, 45653, 45654, 45655, 45656, 45657, 45658, 45660, 45661, 45664, 45668, 45671, 45673, 45674, 45675, 45677, 45682, 45685, 45693, 45716, 45783, 45870, 45871, 45898, 45938, 45947, 45974, 46011, 46023, 46041, 46045, 46104, 46116, 46126, 46145, 46147, 46149, 46200, 46226, 46250, 46303, 46331, 46401, 46452, 46585, 46682, 46712, 46718, 46735, 46739, 46742, 46753, 46770, 46791, 46801, 46809, 46812, 46866, 46876, 46951, 47027, 47031, 47209, 47264, 47352, 47357, 47381, 47388, 47400, 47428, 47447, 47512, 47515, 47539, 47562, 47603, 47643, 47667, 47680, 47738, 47773, 47807, 47810, 47812, 47822, 47832, 47837, 47838, 47842, 47847, 47852, 47854, 47857, 47862, 47866, 47871, 48021, 48031, 48033, 48037, 48054, 48065, 48075, 48110, 48171, 48192, 48219, 48346, 48381, 48422, 48427, 48500, 48548, 48611, 48631, 48667, 48724, 48735, 48758, 48787, 48813, 48824, 48827, 48845, 48880, 49046, 49167, 49775, 49780, 49881, 50198, 50217, 50332, 50399, 50511, 50553, 50623, 50626, 50628, 50632, 50635, 50638, 50640, 50690, 50695, 50731, 50767, 50769, 50773, 50969, 50987, 50989, 50991, 50992, 51252, 51329, 51489, 51516, 51558, 52076, 52139, 52405, 52432, 52439, 52481) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: The Picture of Paris

Dance: End II: The Wapping Landlady, as17901204

Entertainment: Monologue Preceding: an Occasional Address-Harley

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: The Picture of Paris

Dance: As17910127

Entertainment: Monologue As17910127

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sir Christopher Curry Actor: Quick

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wilson

Dance: End II: Negro Dance-

Song: End: some of the most favourite Catches and Glees-Bannister, Incledon, Blanchard, Davies, Williamson, Johnstone [for specific songs probably sung, see17910517]

Entertainment: Monologue. After singing: A Description of the Tombs in Westminster Abbey (after the manner of the late Mr Edwin)-the Young Gentleman who performs Trudge

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: Catherine and Petruchio

Song: Probably at end: Black Eyed Susan-Incledon; Wine cannot cure the Pain I endure for my Chloe-Johnstone, Incledon

Music: Between Acts afterpiece: the favourite air of Moggy Lauder (on the Union Pipes)-the celebrated Courtney

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wewitzer

Dance: End: a new Dance, The Kiss; or, Give and Take-Byrn, Platt, Mrs Goodwin, Miss DeCamp

Performances

Mainpiece Title: The Kentish Barons

Cast
Role: Sir Credule Actor: Barrett

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wewitzer

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Sir John English Actor: Usher

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wewitzer

Dance: As17910701

Performances

Mainpiece Title: Half An Hour After Supper

Cast
Role: William Actor: Abbott

Afterpiece Title: Next Door Neighbours

Cast
Role: Sir Richard Vernon Actor: Davies
Role: Sir Walter Blunt Actor: Iliff
Role: Sir John Falstaff Actor: Palmer
Role: Sir Jasper Wilding Actor: Burton
Role: William Actor: Abbott

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wewitzer

Performances

Mainpiece Title: The Young Quaker

Afterpiece Title: The Minor

Cast
Role: Sir William Wealthy Actor: Wewitzer

Performances

Mainpiece Title: Seeing Is Believing

Cast
Role: Sir Credule Actor: Barrett

Afterpiece Title: The Spanish Barber

Cast
Role: Sir William Wealthy Actor: Wewitzer

Afterpiece Title: Katherine and Petruchio

Performances

Mainpiece Title: The Gentle Shepherd

Cast
Role: Sir William Worthy Actor: Sincock

Afterpiece Title: The Double Amour

Cast
Role: Sir Oliver Oafby Actor: Swords

Dance: End IV: a Dance-Allison, Pupils of Allison

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Sultan; or, A Peep into the Seraglio

Dance: Afterpiece: Grand Dance-[See17911210]

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Gentle Shepherd

Cast
Role: Sir William Worthy Actor: Gray

Dance: End 1st song: The Dance in Fetters-Allison

Song: End: The Cries of Edinburgh-Shaw; End I afterpiece: Hark hark to the Woodlands-Miss Thompson (1st appearance)

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: Love a-la-Mode

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Waterman

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: The Miser

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Sir William Cecil Actor: Aickin
Role: Sir Amias Paulet Actor: Fawcett

Afterpiece Title: Bon Ton

Cast
Role: Sir Tunbelly Clumsey Actor: Moody
Role: Sir John Trotley Actor: King

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: Sir Walter Actor: Webb

Afterpiece Title: The Minor

Entertainment: Monologue. Occasional Prologue-Bannister Jun

Performances

Mainpiece Title: The Fugitive

Cast
Role: Sir William Wingrove Actor: Bensley
Role: William Actor: Benson

Afterpiece Title: All the World's a Stage

Cast
Role: Sir Gilbert Pumpkin Actor: Waldron
Role: William Actor: Lyons

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: The Irishman in London; or, The Happy African

Dance: I: a Fair Scene-; Statute Dance-; End: As17920410

Song: In afterpiece: a Planxty, descriptive of Ireland If you travel the wide world all over (Morning Herald, 23 Apr.)-Johnstone in Character

Performances

Mainpiece Title: The Fugitive

Cast
Role: Sir William Wingrove Actor: Bensley
Role: William Actor: Benson

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Fugitive

Cast
Role: Sir William Wingrove Actor: Bensley
Role: William Actor: Benson

Afterpiece Title: High Life below Stairs