SELECT * FROM london_stages WHERE eventid IN (31889, 31891, 31893, 31895, 31897, 31899, 31901, 31903, 31905, 31907, 31909, 31911, 31913, 31915, 31917, 31925, 31969, 31977, 32071, 32092, 32100, 32111, 32136, 32148, 32258, 32629, 33597, 33635, 36153, 36201, 36317, 36437, 36473, 36508, 36516, 36555, 36558, 36564, 36565, 36651, 36673, 36688, 36692, 36698, 36706, 36722, 36731, 36738, 36750, 36770, 36784, 36808, 36844, 36871, 36895, 36904, 36925, 36985, 37021, 37028, 37063, 37080, 37124, 37214, 37216, 37229, 37247, 37266, 37286, 37288, 37290, 37299, 37305, 37312, 37317, 37326, 37335, 37343, 37354, 37363, 37368, 37380, 37407, 37424, 37426, 37433, 37445, 37451, 37453, 37460, 37462, 37477, 37479, 37503, 37524, 37548, 37560, 37572, 37579, 37582, 37594, 37606, 37613, 37621, 37626, 37640, 37643, 37659, 37675, 37680, 37787, 37799, 37801, 37835, 37839, 37843, 37852, 37854, 37895, 37943, 37954, 37994, 37998, 38067, 38102, 38133, 38153, 38158, 38221, 38236, 38239, 38313, 38369, 38376, 38381, 38383, 38385, 38387, 38390, 38392, 38394, 38396, 38399, 38401, 38404, 38410, 38412, 38420, 38422, 38434, 38439, 38457, 38459, 38464, 38471, 38477, 38479, 38496, 38500, 38505, 38525, 38528, 38534, 38538, 38540, 38543, 38559, 38561, 38568, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38611, 38613, 38619, 38624, 38629, 38634, 38639, 38656, 38658, 38663, 38668, 38673, 38680, 38684, 38689, 38692, 38694, 38700, 38703, 38706, 38714, 38724, 38729, 38739, 38741, 38748, 38750, 38753, 38755, 38758, 38766, 38768, 38775, 38778, 38785, 38794, 38796, 38801, 38856, 38873, 38883, 38891, 38901, 38906, 38908, 38924, 38930, 38932, 38934, 38937, 38942, 38948, 38951, 38956, 38958, 38960, 38962, 38965, 38967, 38970, 38972, 38974, 38979, 38984, 38988, 38990, 38998, 39006, 39008, 39011, 39015, 39026, 39036, 39043, 39045, 39047, 39051, 39058, 39067, 39072, 39076, 39083, 39086, 39090, 39098, 39107, 39109, 39114, 39121, 39128, 39181, 39202, 39216, 39230, 39239, 39242, 39250, 39257, 39260, 39265, 39273, 39276, 39280, 39282, 39285, 39293, 39296, 39298, 39301, 39303, 39306, 39312, 39315, 39317, 39320, 39322, 39324, 39326, 39329, 39331, 39335, 39339, 39343, 39345, 39346, 39347, 39349, 39445, 39447, 39449, 39453, 39462, 39474, 39478, 39482, 39484, 39486, 39489, 39491, 39495, 39499, 39504, 39508, 39516, 39518, 39522, 39530, 39534, 39536, 39544, 39548, 39550, 39553, 39558, 39560, 39562, 39567, 39569, 39574, 39576, 39586, 39597, 39613, 39615, 39623, 39627, 39629, 39634, 39639, 39643, 39646, 39655, 39660, 39666, 39684, 39690, 39693, 39697, 39702, 39704, 39711, 39713, 39716, 39718, 39723, 39731, 39740, 39743, 39745, 39754, 39764, 39772, 39775, 39781, 39786, 39789, 39802, 39807, 39823, 39826, 39830, 39835, 39837, 39840, 39847, 39852, 39857, 39859, 39868, 39871, 39873, 39880, 39883, 39886, 39888, 39891, 39907, 40774, 40780, 40914, 40916, 40927, 40937, 40942, 40955, 44956, 44972, 44974, 44979, 44985, 44994, 45203, 45205, 45207, 45211, 45215, 45217, 45221, 45225, 45229, 46570, 46574, 46584, 46599, 46608, 46626, 46710, 48376, 48539, 48543, 48561, 48573, 48575, 48585, 48592, 48609, 48615, 48635, 48643, 48667, 48675, 48705, 48735, 48744, 48757, 48796, 48819, 48824, 48828, 48856, 48865, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48952, 48956, 48959, 48961, 48967, 48971, 48980, 48982, 48986, 48988, 48990, 48993, 48995, 49000, 49004, 49007, 49009, 49014, 49018, 49021, 49023, 49028, 49033, 49036, 49038, 49041, 49043, 49046, 49051, 49053, 49056, 49058, 49061, 49066, 49069, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49097, 49100, 49188, 49193, 49197, 49199, 49206, 49209, 49214, 49216, 49219, 49224, 49234, 49238, 49242, 49246, 49248, 49250, 49254, 49260, 49264, 49268, 49302, 49305, 49307, 49310, 49326, 49328, 49333, 49338, 49343, 49373, 49380, 49387, 49401, 49408, 49411, 49413, 49418, 49420, 49509, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49563, 49570, 49573, 49575, 49578, 49580, 49583, 49589, 49592, 49597, 49602, 49604, 49607, 49609, 49612, 49614, 49620, 49625, 49635, 49637, 49640, 49642, 49644, 49650, 49655, 49657, 49659, 49662, 49664, 49667) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Deserter

Cast
Role: Louisa Actor: Miss Collett.

Performances

Mainpiece Title: The Fair Quaker

Cast
Role: Belinda Actor: Miss Hopkins
Role: Jenny Private Actor: Miss Platt
Role: Dorcas Zeal Actor: Miss Pope.

Afterpiece Title: The Devil to Pay

Dance: As17761109; End II: Comic Dance, as17761217

Song: Rule Britannia-as17761109, but _Fawcett, Gaudry

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: Miss in her Teens

Cast
Role: Miss Biddy Actor: Miss Hamilton.
Role: Maria Actor: Mrs Hopkins
Role: Viola Actor: Miss Younge.

Performances

Mainpiece Title: George Barnwell

Cast
Role: Maria Actor: Miss Hopkins

Afterpiece Title: The Mayor of Garratt

Cast
Role: Bertha Actor: Miss Platt
Role: Matilda Actor: Miss Younge.
Role: Mrs Bruin Actor: Miss Platt

Dance: As17761214

Song: In I: song-Miss Abrams

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Padlock

Cast
Role: Leonora Actor: Miss Abrams.

Performances

Afterpiece Title: All the World's a Stage

Dance: I: Dance of Spirits-Miss Armstrong; III: Dance of Fantastic Spirits-; [These were danced, as here assigned, in all subsequent performances.] V: a Ballet, Demie Caractere, composed by Gallet, The Double Festival-Gallet, Slingsby, Miss Armstrong, Sga Dupre

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Lady Freelove Actor: Mrs Hopkins
Role: Harriet Actor: Miss Hopkins
Role: Mrs Oakly Actor: Miss Younge.

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Miss Sterling Actor: Miss Pope
Role: Fanny Actor: Miss P. Hopkins
Role: Mrs Heidelberg Actor: Mrs Hopkins.

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Hamlet

Cast
Role: Queen Actor: Mrs Hopkins

Afterpiece Title: All the World's a Stage

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Laetitia Actor: Miss Pope
Role: Silvia Actor: Miss P. Hopkins
Role: Belinda Actor: Miss Younge.

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Dance: End II: Rural Grace, as17771002

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Maria Actor: Miss P. Hopkins
Role: Viola Actor: Miss Younge.

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Dance: In: Rural Grace, as17771002

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Song: In III: song-Vernon. [This was sung, as here assigned, in all subsequent performances, except on 20 May 1778.

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valeria Actor: Miss Hopkins

Afterpiece Title: Selima and Azor

Cast
Role: Fatima Actor: Miss Collett
Role: Liesbia Actor: Miss Abrams

Music: With a Grand Triumphal Entry of Publius, with theoriginal Music by Boyce-

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valeria Actor: Miss Hopkins

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Dance: As17771018

Music: As17771028

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Performances

Mainpiece Title: Tamerlane

Cast
Role: Selima Actor: Miss Hopkins
Role: Arpasia Actor: Miss Younge

Afterpiece Title: Harlequin's Invasion

Cast
Role: Dolly Snip Actor: Miss Pope.

Song: IV: the original song To thee oh gentle sleep-Miss Abrams

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Quaker

Cast
Role: Gillian Actor: Miss Walpole

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: All the World's a Stage

Dance: III: a Hornpipe-Blurton. [This was danced, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Padlock

Cast
Role: Leonora Actor: Miss Abrams.

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Mariana Actor: Miss Hopkins

Afterpiece Title: The Elopement

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: All the World's a Stage

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Mrs Candour Actor: Miss Pope
Role: Maria Actor: Miss P. Hopkins
Role: Lady Sneerwell Actor: Miss Sherry

Afterpiece Title: The Waterman

Cast
Role: Wilhelmina Actor: Miss Walpole