SELECT * FROM london_stages WHERE eventid IN (40890, 45221, 45471, 46382, 46386, 46402, 46406, 46449, 46454, 46592, 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, 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, 48736, 48740, 48746, 48748, 48750, 48756, 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, 49123, 49125, 49126, 49127, 49129, 49130, 49131, 49132, 49133, 49134, 49135, 49137, 49138, 49140, 49141, 49143, 49144, 49146, 49148, 49149, 49153, 49154, 49157, 49160, 49161, 49162, 49163, 49164, 49165, 49167, 49168, 49170, 49172, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49183, 49187, 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, 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, 50287, 50288, 50289, 50290, 50291, 50292, 50293, 50294, 50295, 50297, 50298, 50299, 50302, 50303, 50304, 50306, 50308, 50310, 50312, 50314, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50806, 50809, 50814, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50830, 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, 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, 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) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Goatherds Actor: Waldron, Burton, Waldron Jun.
Role: Ganem Actor: Palmer Jun.

Afterpiece Title: The Mock Doctor

Cast
Role: Cudden Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: The Battle of Hexham

Cast
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Afterpiece Title: Katharine and Petruchio

Cast
Role: Musick Master Actor: Waldron Jun.

Performances

Mainpiece Title: All In Good Humour

Cast
Role: Anvil Actor: Waldron Jun.

Afterpiece Title: The Jew

Afterpiece Title: The Deaf Lover

Cast
Role: Old Wrongward Actor: Waldron
Role: Young Wrongward Actor: Palmer Jun.
Role: Groom Actor: Waldron Jun.

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Goatherds Actor: Waldron, Burton, Waldron Jun.
Role: Ganem Actor: Palmer Jun.

Afterpiece Title: Gretna Green

Cast
Role: Servant Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: The Jew

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Purse

Cast
Role: Theodore Actor: Palmer Jun.

Afterpiece Title: The London Hermit

Cast
Role: Natty Maggs Actor: Palmer Jun.
Role: Carter Actor: Waldron Jun.
Role: Count Fripon Actor: Waldron Jun.

Afterpiece Title: Peeping Tom

Cast
Role: Servant Actor: Waldron Jun.

Performances

Mainpiece Title: Tit For Tat

Cast
Role: Young Meanwell Actor: Palmer Jun.

Afterpiece Title: The Citizen

Cast
Role: Young Philpot Actor: Bannister Jun.
Role: Quildrive Actor: Waldron Jun.

Afterpiece Title: The Village Lawyer

Cast
Role: Scout Actor: Bannister Jun.

Performances

Mainpiece Title: All The World's A Stage

Afterpiece Title: No Song No Supper

Cast
Role: Robin Actor: Bannister Jun.
Role: Billy Taylor Actor: Bannister Jun.

Afterpiece Title: The Son-in-Law

Cast
Role: Bowkitt Actor: Bannister Jun.
Role: Idle Actor: Palmer Jun.
Role: Walter Actor: Bannister Jun.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: A Bold Stroke for a Wife

Cast
Role: Feignwell Actor: Bannister Jun.
Role: Sir Philip Modelove Actor: Waldron
Role: Simon Pure Actor: Waldron Jun.
Role: Freeman Actor: Palmer Jun.

Afterpiece Title: The Purse

Cast
Role: Servant Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.

Performances

Mainpiece Title: The Author

Cast
Role: Sprightly Actor: Palmer Jun.
Role: Poet Actor: Waldron

Afterpiece Title: The Prize; or, 2

Cast
Role: Lenitive Actor: Bannister Jun.
Role: Heartwell Actor: Palmer Jun.

Afterpiece Title: The Village Lawyer

Cast
Role: Young Philpot Actor: Bannister Jun.
Role: Quildrive Actor: Waldron Jun.
Role: Scout Actor: Bannister Jun.

Performances

Mainpiece Title: The Prisoner At Large

Cast
Role: Theodore Actor: Palmer Jun.

Afterpiece Title: The Mock Doctor

Cast
Role: Gregory Actor: Bannister Jun.
Role: Cudden Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Afterpiece Title: Bannian Day

Cast
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Performances

Mainpiece Title: Love And Money; Or, The Fair Caledonian

Cast
Role: Lord Rakish Actor: Palmer Jun.
Role: Runlet Actor: Waldron Jun.

Afterpiece Title: The Spanish Barber

Cast
Role: Lazarillo Actor: Bannister Jun.
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Afterpiece Title: Katharine and Petruchio

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: Officer Actor: Palmer Jun.
Role: Old Man Actor: Waldron
Role: Citizens Actor: Caulfield, Waldron Jun., Lyons
Role: La Gloire Actor: Bannister Jun.

Afterpiece Title: The Devil to Pay; or, The Wives Metamorphosed

Cast
Role: Jobson Actor: Bannister Jun.

Song: Mainpiece: Vocal Parts-Aylmer, Boyce, Brown, Dibble, Kenrick, Linton, Little, Walker, Willoughby, Miss Leak, Miss DeCamp, Mrs Gaudry, Mrs Hale, Mrs Butler, Mrs Masters, Mrs Norton, Miss Menage, Miss Granger

Performances

Mainpiece Title: Ways And Means

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Agreeable Surprise

Cast
Role: Cudden Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Performances

Mainpiece Title: The Citizen

Cast
Role: Young Meanwell Actor: Palmer Jun.

Afterpiece Title: The Liar

Cast
Role: Servant Actor: Waldron Jun.

Afterpiece Title: The Prize

Cast
Role: Lenitive Actor: Bannister Jun.
Role: Heartwell Actor: Palmer Jun.
Role: Young Philpot Actor: Bannister Jun.
Role: Quildrive Actor: Waldron Jun.
Role: Scout Actor: Bannister Jun.

Performances

Mainpiece Title: All In Good Humour

Cast
Role: Bellamy Actor: Palmer Jun.
Role: Robin Actor: Waldron Jun.

Afterpiece Title: A Bold Stroke for a Wife

Cast
Role: Feignwell Actor: Bannister Jun.
Role: Sir Philip Modelove Actor: Waldron
Role: Simon Pure Actor: Waldron Jun.
Role: Freeman Actor: Palmer Jun.
Role: Fifer Actor: Waldron Jun.

Afterpiece Title: The Purse

Cast
Role: Servant Actor: Waldron Jun.
Role: Fifer Actor: Waldron Jun.

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: The Battle of Hexham

Afterpiece Title: Peeping Tom

Cast
Role: Servant Actor: Waldron Jun.

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Waiter Actor: Waldron Jun.

Afterpiece Title: The Children in the Wood

Cast
Role: Bowkitt Actor: Bannister Jun.
Role: Idle Actor: Palmer Jun.
Role: Walter Actor: Bannister Jun.

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: Officer Actor: Palmer Jun.
Role: Old Man Actor: Waldron
Role: La Gloire Actor: Bannister Jun.

Afterpiece Title: The Village Lawyer

Cast
Role: Young Philpot Actor: Bannister Jun.
Role: Quildrive Actor: Waldron Jun.
Role: Scout Actor: Bannister Jun.

Song: As17960715

Performances

Mainpiece Title: The Quaker

Afterpiece Title: Don Pedro

Cast
Role: Lopez Actor: Palmer Jun.
Role: Martin Actor: Waldron Jun.

Performances

Mainpiece Title: The Purse

Cast
Role: Theodore Actor: Palmer Jun.

Afterpiece Title: Don Pedro

Cast
Role: Lopez Actor: Palmer Jun.
Role: Martin Actor: Waldron Jun.

Afterpiece Title: Sylvester Daggerwood

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Katharine and Petruchio

Cast
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.
Role: Musick Master Actor: Waldron Jun.

Performances

Mainpiece Title: Don Pedro

Afterpiece Title: Peeping Tom

Cast
Role: Servant Actor: Waldron Jun.

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Level Actor: Palmer Jun.

Afterpiece Title: The Dead Alive

Cast
Role: Fifer Actor: Waldron Jun.
Role: Servant Actor: _Waldron Jun.

Performances

Mainpiece Title: The Prisoner At Large

Cast
Role: Theodore Actor: Palmer Jun.

Afterpiece Title: The Village Lawyer

Cast
Role: Young Philpot Actor: Bannister Jun.
Role: Quildrive Actor: Waldron Jun.
Role: Scout Actor: Bannister Jun.

Afterpiece Title: The Children in the Wood

Cast
Role: Bowkitt Actor: Bannister Jun.
Role: Idle Actor: Palmer Jun.
Role: Walter Actor: Bannister Jun.