SELECT * FROM london_stages WHERE eventid IN (39463, 39467, 41988, 42015, 42053, 42295, 42309, 42337, 42405, 42449, 42469, 42476, 42517, 42558, 42565, 42580, 42589, 42602, 42671, 42696, 42711, 42746, 42759, 42913, 42917, 42921, 42927, 42943, 42949, 42964, 42973, 42981, 42983, 42985, 43007, 43039, 43073, 43088, 43203, 43228, 43238, 43243, 43259, 43262, 43271, 43273, 43276, 43287, 43302, 43307, 43309, 43459, 43461, 43501, 43518, 43524, 43526, 43530, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43586, 43598, 43609, 43612, 43617, 43628, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43658, 43663, 43667, 43701, 43706, 43717, 43764, 43794, 43800, 43835, 43837, 43840, 43843, 43846, 43848, 43851, 43853, 43857, 43860, 43870, 43872, 43875, 43877, 43880, 43882, 43890, 44030, 44034, 44038, 44044, 44047, 44053, 44055, 44057, 44060, 44062, 44064, 44065, 44069, 44071, 44075, 44077, 44079, 44082, 44084, 44088, 44090, 44092, 44096, 44102, 44106, 44114, 44126, 44142, 44150, 44154, 44166, 44169, 44171, 44185, 44189, 44246, 44260, 44292, 44298, 44302, 44371, 44378, 44411, 44431, 44443, 44453, 44471, 44473, 44590, 44606, 44607, 44691, 44751, 44754, 44756, 44759, 44763, 44768, 44770, 44773, 44775, 44777, 44782, 44784, 44786, 44793, 44800, 44816, 44827, 44833, 44848, 44856, 44866, 44875, 44896, 44912, 44916, 44928, 44938, 44956, 44970, 44972, 44974, 44979, 44985, 44991, 44994, 45000, 45003, 45012, 45017, 45021, 45024, 45036, 45136, 45138, 45140, 45144, 45149, 45161, 45165, 45170, 45172, 45177, 45181, 45183, 45185, 45189, 45193, 45199, 45201, 45203, 45205, 45207, 45209, 45211, 45215, 45217, 45221, 45223, 45225, 45229, 45231, 45233, 45237, 45241, 45249, 45256, 45261, 45263, 45265, 45273, 45275, 45277, 45282, 45284, 45286, 45288, 45290, 45292, 45294, 45296, 45299, 45301, 45304, 45306, 45309, 45311, 45313, 45315, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45351, 45353, 45360, 45364, 45371, 45377, 45380, 45383, 45389, 45393, 45398, 45402, 45409, 45411, 45419, 45424, 45435, 45437, 45439, 45448, 45455, 45460, 45476, 45479, 45481, 45486, 45489, 45499, 45508, 45514, 45518, 45533, 45546, 45556, 45561, 45566, 45568, 45571, 45578, 45581, 45583, 45586, 45590, 45596, 45599, 45601, 45603, 45697, 45703, 45705, 45707, 45712, 45721, 45725, 45741, 45749, 45753, 45762, 45768, 45770, 45774, 45776, 45782, 45788, 45790, 45794, 45796, 45798, 45800, 45802, 45806, 45808, 45812, 45816, 45818, 45824, 45826, 45830, 45832, 45834, 45837, 45839, 45843, 45847, 45849, 45851, 45855, 45857, 45861, 45868, 45870, 45873, 45875, 45877, 45882, 45884, 45887, 45889, 45896, 45898, 45908, 45917, 45922, 45924, 45931, 45938, 45941, 45943, 45950, 45957, 45964, 45977, 45983, 45990, 45992, 46001, 46004, 46006, 46014, 46019, 46027, 46039, 46041, 46046, 46051, 46057, 46062, 46064, 46067, 46069, 46072, 46074, 46077, 46084, 46087, 46089, 46094, 46099, 46105, 46108, 46114, 46117, 46126, 46129, 46132, 46136, 46139, 46142, 46147, 46150, 46153, 46156, 46159, 46168, 46260, 46274, 46278, 46280, 46283, 46288, 46291, 46293, 46300, 46306, 46310, 46312, 46318, 46320, 46326, 46332, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46362, 46366, 46376, 46378, 46400, 46408, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46451, 46456, 46461, 46463, 46465, 46468, 46470, 46473, 46475, 46477, 46482, 46485, 46487, 46489, 46491, 46494, 46496, 46499, 46503, 46508, 46510, 46518, 46521, 46523, 46528, 46532, 46535, 46537, 46546, 46549, 46551, 46556, 46560, 46565, 46574, 46577, 46589, 46597, 46601, 46603, 46606, 46611, 46613, 46616, 46618, 46621, 46623, 46631, 46633, 46638, 46641, 46648, 46651, 46658, 46660, 46665, 46677, 46680, 46687, 46690, 46694, 46704, 46707, 46715, 46720, 46843, 46848, 46853, 46857, 46859, 46860, 46864, 46866, 46870, 46872, 46874, 46876, 46878, 46880, 46884, 46886, 46890, 46892, 46894, 46898, 46900, 46902, 46904, 46908, 46910, 46914, 46916, 46918, 46922, 46924, 46926, 46928, 46932, 46934, 46938, 46940, 46942, 46946, 46948, 46950, 46952, 46954, 46956, 46958, 46960, 46962, 46964, 46966, 46970, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46988, 46990, 46992, 46994, 46996, 47000, 47004, 47006, 47008, 47010, 47012, 47014, 47016, 47018, 47020, 47024, 47026, 47032, 47042, 47044, 47046, 47052, 47054, 47060, 47062, 47065, 47070, 47072, 47075, 47078, 47080, 47085, 47087, 47090, 47097, 47103, 47107, 47113, 47116, 47123, 47127, 47130, 47132, 47143, 47147, 47149, 47155, 47172, 47178, 47182, 47185, 47191, 47197, 47203, 47206, 47208, 47211, 47223, 47228, 47237, 47241, 47243, 47246, 47252, 47254, 47258, 47260, 47272, 47278, 47294, 47296, 47303, 47448, 47453, 47457, 47463, 47468, 47476, 47488, 47492, 47498, 47500, 47504, 47506, 47508, 47516, 47526, 47528, 47532, 47534, 47538, 47540, 47542, 47544, 47546, 47548, 47550, 47554, 47556, 47560, 47565, 47567, 47569, 47574, 47576, 47579, 47583, 47585, 47588, 47592, 47602, 47610, 47615, 47624, 47627, 47634, 47636, 47638, 47642, 47648, 47650, 47654, 47658, 47662, 47673, 47682, 47684, 47699, 47728, 47738, 47748, 47751, 47758, 47763, 47766, 47768, 47773, 47778, 47781, 47783, 47786, 47788, 47791, 47793, 47799, 47802, 47804, 47807, 47809, 47814, 47822, 47824, 47829, 47839, 47847, 47864, 47866, 47868, 47871, 47876, 47884, 47889, 47893, 47895, 47899, 47901, 47905, 47907, 47913, 47998, 48001, 48003, 48007, 48011, 48013, 48018, 48021, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48044, 48046, 48048, 48050, 48054, 48058, 48060, 48065, 48067, 48073, 48075, 48077, 48079, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48120, 48122, 48124, 48126, 48128, 48130, 48132, 48136, 48138, 48141, 48143, 48145, 48147, 48149, 48151, 48153, 48155, 48157, 48159, 48161, 48165, 48169, 48171, 48173, 48175, 48177, 48179, 48181, 48185, 48203, 48208, 48210, 48213, 48215, 48217, 48219, 48222, 48224, 48235, 48237, 48251, 48256, 48263, 48265, 48274, 48277, 48279, 48288, 48291, 48298, 48310, 48312, 48314, 48319, 48326, 48328, 48333, 48338, 48340, 48343, 48346, 48351, 48353, 48365, 48367, 48371, 48376, 48381, 48390, 48397, 48401, 48415, 48422, 48429, 48431, 48448, 48449, 48453, 48457, 48459, 48461, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48483, 48484, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48512, 48515, 48519, 48526, 48528, 48530, 48532, 48533, 48713, 48733, 48753, 48763, 48765, 48773) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Deaf Lover

Cast
Role: William Actor: Alfred

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Ledger, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Surrender of Calais

Cast
Role: Crier Actor: Alfred

Song: In 2nd piece: Singing-Cooke, Kenrick, Willoughby, Linton, Dorion, Aylmer, Little, Brown, Lyons, Miss DeCamp, Miss Dall, Miss Fontenelle, Mrs Powell, Mrs Masters, Mrs Bramwell, Mrs Hatton

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Ledger, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: A Mogul Tale; or, The Descent of the Balloon

Performances

Mainpiece Title: The Pad

Cast
Role: Gentlemen Actor: _Bland, Alfred.

Afterpiece Title: The Surrender of Calais

Cast
Role: Crier Actor: Alfred

Song: As17930617

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit; or, Rambles in Dorsetshire

Cast
Role: John Grum Actor: Alfred

Afterpiece Title: The Deaf Lover

Cast
Role: William Actor: Alfred

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Pad

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Katharine and Petruchio

Cast
Role: Cook Actor: Alfred

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Son-in-Law

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: The Son-in-Law

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Citizen

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Flitch of Bacon

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: A Mogul Tale

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Son-in-Law

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Ledger, Alfred

Afterpiece Title: Peeping Tom

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: Who's the Dupe

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Lying Valet

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: Ways and Means

Afterpiece Title: The Flitch of Bacon

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred