SELECT * FROM london_stages WHERE eventid IN (18186, 18191, 18203, 18210, 18231, 18239, 18266, 18288, 18297, 18306, 18327, 18335, 18338, 18345, 18365, 18379, 18398, 18415, 18436, 18440, 18476, 18483, 18593, 18752, 18777, 18780, 18795, 18808, 18811, 18871, 18875, 18890, 18894, 18907, 18911, 18913, 18931, 18933, 18935, 18937, 18941, 18945, 18949, 18955, 18960, 18964, 18969, 18974, 18997, 19002, 19006, 19014, 19020, 19070, 19080, 19103, 19118, 19127, 19130, 19132, 19139, 19149, 19151, 19171, 19177, 19179, 19182, 19184, 19188, 19235, 19239, 19245, 19251, 19259, 19263, 19269, 19278, 19283, 19288, 19295, 19298, 19306, 19314, 19316, 19319, 19321, 19331, 19333, 19347, 19355, 19357, 19359, 19361, 19365, 19371, 19378, 19380, 19382, 19387, 19393, 19399, 19401, 19410, 19414, 19416, 19428, 19430, 19435, 19439, 19441, 19443, 19454, 19456, 19465, 19470, 19472, 19476, 19481, 19483, 19487, 19505, 19507, 19513, 19523, 19530, 19532, 19535, 19537, 19539, 19541, 19544, 19546, 19554, 19563, 19571, 19575, 19577, 19580, 19582, 19586, 19589, 19591, 19594, 19596, 19598, 19600, 19604, 19606, 19610, 19612, 19615, 19618, 19621, 19622, 19624, 19626, 19632, 19637, 19643, 19655, 19657, 19660, 19662, 19670, 19676, 19684, 19686, 19718, 19722, 19724, 19728, 19738, 19744, 19746, 19748, 19752, 19754, 19760, 19780, 19782, 19790, 19814, 19821, 19831, 19843, 19849, 19853, 19862, 19869, 19872, 19873, 19879, 19971, 19975, 19982, 19988, 20016, 20036, 20041, 20056, 20061, 20070, 20075, 20085, 20096, 20100, 20104, 20109, 20138, 20144, 20146, 20150, 20179, 20182, 20197, 20206, 20243, 20249, 20258, 20261, 20265, 20268, 20271, 20274, 20277, 20280, 20284, 20287, 20293, 20305, 20324, 20333, 20337, 20340, 20351, 20360, 20382, 20386, 20390, 20393, 20396, 20406, 20410, 20416, 20426, 20439, 20442, 20446, 20449, 20458, 20526, 20529, 20533, 20547, 20584, 20587, 20601, 20618, 20622, 20628, 20631, 20642, 20647, 20657, 20660, 20663, 20666, 20674, 20740, 20754, 20790, 20803, 20823, 20826, 20846, 20873, 20887, 20903, 20912, 20915, 20956, 20961, 20981, 20994, 21042, 21052, 21120, 21127, 21158, 21185, 21213, 21227, 21231, 21235, 21261, 21282, 21288, 21389, 21393, 21461, 21468, 21480, 21594, 22625, 22636, 22639, 22644, 22647, 22650, 22654, 22657, 22747, 24426, 24539, 24541, 24545, 24548, 24551, 24553, 24555, 24557, 24560, 24562, 24732, 25152, 25191, 25802, 25812, 25814, 25816, 25824, 25836, 25891, 25939, 26024, 26472, 26755, 26920, 27062, 27197, 27203, 27205, 27207, 27209, 27223, 27250, 27258, 27268, 27274, 27279, 27282, 27284, 27298, 27300, 27302, 27310, 27313, 27315, 27319, 27328, 27335, 27341, 27343, 27375, 27377, 27384, 27405, 27407, 27412, 27430, 27437, 27463, 27468, 27480, 27489, 27492, 27495, 27497, 27502, 27506, 27512, 27517, 27521, 27530, 27534, 27544, 27547, 27549, 27573, 27576, 27585, 27597, 27607, 27613, 27618, 27622, 27683, 27686, 27695, 27705, 27711, 27713, 27717, 27719, 27721, 27723, 27725, 27727, 27740, 27749, 27755, 27758, 27762, 27766, 27771, 27780, 27782, 27811, 27814, 27820, 27823, 27825, 27830, 27834, 27837, 27858, 27862, 27865, 27868, 27873, 27877, 27880, 27885, 27890, 27897, 27900, 27903, 27906, 27909, 27911, 27914, 27917, 27919, 27921, 27923, 27928, 27933, 27935, 27939, 27941, 27943, 27948, 27953, 27959, 27966, 27973, 27979, 27982, 27993, 28007, 28010, 28012, 28031, 28036, 28044, 28060, 28063, 28068, 28082, 28087, 28469, 28755, 28760, 28766, 28769, 28774, 28778, 28785, 28789, 28798, 28808, 28816, 28819, 28824, 28829, 28845, 28853, 28855, 28858, 28862, 28867, 28877, 28883, 28888, 28894, 28899, 28906, 28920, 28927, 28931, 28940, 28943, 28947, 28951, 28957, 28959, 28961, 28974, 28982, 28987, 28992, 29001, 29006, 29017, 29032, 29037, 29039, 29051, 29166, 29168, 29173, 29182, 29183, 29186, 29194, 29200, 29202, 29204, 29210, 29222, 29228, 29233, 29236, 29245, 29260, 29265, 29269, 29272, 29274, 29277, 29279, 29281, 29283, 29286, 29288, 29290, 29292, 29294, 29296, 29299, 29303, 29305, 29307, 29309, 29313, 29321, 29323, 29326, 29337, 29339, 29343, 29347, 29350, 29358, 29382, 29385, 29394, 29396, 29417, 29420, 29425, 29435, 29440, 29450, 29456, 29466, 29469, 29471, 29474, 29482, 29489, 29493, 29497, 29500, 29509, 29511, 29514, 29516, 29533, 29540, 29545, 29548, 29550, 29557, 29561, 29569, 29572, 29584, 29591, 29594, 30811, 30815, 30821, 30825, 30827, 30829, 30835, 30841, 30853, 30855, 30857, 30861, 30868, 30871, 30881, 30901, 30903, 30906, 30908, 30911, 30913, 30915, 30917, 30920, 30923, 30925, 30927, 30929, 30931, 30934, 30936, 30938, 30941, 30943, 30945, 30948, 30951, 30953, 30988, 30994, 31016, 31018, 31022, 31036, 31058, 31103, 31134, 31224, 32438, 32443, 32467, 32480, 32494, 32508, 32519, 32522, 32531, 32537, 32579, 32624, 32630, 32632, 32643, 32663, 32672, 32675, 32689, 32694, 32699, 32707, 32716, 32728, 32733, 32747, 32810, 32812, 32814, 32831, 32839, 32857, 32867, 32881, 32883, 32902, 32921, 32927, 32950, 32957, 33016, 33021, 33025, 33030, 33051, 33058, 33068, 33073, 33093, 33096, 33101, 33107, 33109, 33135, 33144, 33151, 33153, 33162, 33173, 33175, 33180, 33182, 33192, 33196, 33202, 33377, 33389, 33398, 33401, 33429, 33475, 33482, 33527, 33530, 33558, 33571, 33586, 33593, 33596, 33605, 33608, 33610, 33634, 33636, 33645, 33648, 33663, 33677, 33682, 33699, 33708, 33711, 33714, 33716, 33797, 33809, 33813, 33817, 33820, 33824, 33832, 33840, 33842, 33844, 33863, 33865, 33888, 33890, 33894, 33897, 33922, 33970, 33990, 34152, 34156, 34193, 34200, 34205, 34213, 34317, 34328, 34349, 34354, 34360, 34438, 34462, 34532, 34534, 34588, 34590, 34607, 34700, 34718, 34723, 34739, 34748, 34752, 34776, 34780, 34787, 34910, 34944, 34960, 34962, 34971, 34981, 35001, 35071, 35093, 35098, 35153, 35161, 35165, 35173, 35175, 35231, 35241, 35256, 35290, 35317, 35333, 39420, 39423, 41010, 47121, 47136, 47153, 47170, 47176, 47189, 47195) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Queen Actor: Mrs Bellamy.
Role: Lady Anne Actor: Mrs Vincent
Role: Duchess of York Actor: Mrs Elmy

Afterpiece Title: The Sheep Shearing; or, Florizel and Perdita

Dance: As17571217

Ballet: TThe Judgment of Paris. As17571217

Cast
Role: Pallas Actor: Mrs Granier

Performances

Afterpiece Title: The Sheep Shearing

Dance: As17571217

Ballet: TThe Judgment of Paris. As17571217

Cast
Role: Pallas Actor: Mrs Granier

Performances

Mainpiece Title: Douglas

Cast
Role: Anna Actor: Mrs Vincent
Role: Lady Randolph Actor: Mrs Bellamy, 1st time.

Afterpiece Title: Lethe

Cast
Role: Fine Lady Actor: Mrs Green.

Dance: SSicilian Peasants, as17571217

Performances

Mainpiece Title: Theodosius

Cast
Role: Pulcheria Actor: Mrs Vincent
Role: Athenais Actor: Mrs Bellamy.

Afterpiece Title: The Contrivances

Cast
Role: Betty Actor: Mrs Pitt
Role: Arethusa Actor: Mrs Chambers.

Dance: As17571217

Ballet: TThe Judgment of Paris. As17571217

Cast
Role: Pallas Actor: Mrs Granier

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Lady Capulet Actor: Mrs Barrington
Role: Nurse Actor: Mrs Pitt
Role: Juliet Actor: Mrs Bellamy

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Sysigambis Actor: Mrs Vincent
Role: Parisatis Actor: Mrs Baker
Role: Roxana Actor: Mrs Hamilton
Role: Statira Actor: Mrs Bellamy

Afterpiece Title: The Knights

Dance: SSicilian Peasants, as17571217

Performances

Mainpiece Title: The Siege Of Damascus

Cast
Role: Eudocia Actor: Mrs Bellamy.

Afterpiece Title: The Anniversary : Being a Sequel to Lethe

Dance: SSicilian Peasants, as17571217; Fingalian Dance, by Desire, as17571013

Performances

Mainpiece Title: Othello

Cast
Role: Desdemona Actor: Mrs Bellamy.
Role: Emilia Actor: Mrs Hamilton

Afterpiece Title: Lethe

Cast
Role: Fine Lady Actor: Mrs Green.

Dance: SSicilian Peasants, as17571217; Fingalian Dance, as17571013

Performances

Mainpiece Title: King Lear

Cast
Role: Goneril Actor: Mrs Stephens
Role: Regan Actor: Mrs Elmy
Role: Cordelia Actor: Mrs Bellamy.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Ballet: JJudgment of Paris. As17571217, but Venus-Mlle Capdeville

Cast
Role: Pallas Actor: Mrs Granier

Performances

Mainpiece Title: Anna Bullen; Or, Virtue Betrayed

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Ballet: JJudgment of Paris. As17580407

Cast
Role: Pallas Actor: Mrs Granier

Dance: JJovial Coopers, as17571107

Music: By Desire, a piece onthe Welch Harp-Roberts

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Lavinia Actor: Mrs Elmy
Role: Lucilla Actor: Mrs Barrington
Role: Calista Actor: Mrs Bellamy.

Afterpiece Title: Lethe

Cast
Role: Fine Lady Actor: Mrs Green.

Dance: II: By Desire, a new dance-Gallini, Mrs Granier, Miss Viviez; III: Sicilian Peasants, as17571217, but Mlle Capdeville, Miss _Hilliard; IV: +She Wou'd and She Wou'd Not-Gallini, Sga Forti; V: A Minuet-Gallini, a Gentlewoman

Ballet: I: Judgment of Paris. As17580407

Cast
Role: Pallas Actor: Mrs Granier

Performances

Mainpiece Title: King John

Cast
Role: Queen Elinor Actor: Mrs Elmy
Role: Lady Blanche Actor: Mrs Vincent
Role: Constance Actor: Mrs Bellamy, 1st time.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green.

Ballet: Judgment of Paris. As17580413

Cast
Role: Pallas Actor: Mrs Granier

Dance: likewise a newClikewise a newComic Dance-Lucas, Mlle Capdeville

Performances

Mainpiece Title: Alzira

Cast
Role: Cephania Actor: Mrs Stephens
Role: Alzira Actor: Mrs Bellamy.

Afterpiece Title: Harlequin Statue; or, The Jealous Farmer Deceiv'd

Cast
Role: Colombine Actor: Mrs Dyer

Dance: I: Fingalian Dance-Miss Toogood, Apprentice to Lalauze; III: The Provincial Sailors, as17580408 IV: By Desire, Louvre, Minuet-Lalauze, Miss Toogood; V: Savoyards, as17580408

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Phillis Actor: Mrs Green
Role: Indiana Actor: Mrs Bellamy
Role: Singing Actor: Mrs Chambers.
Role: Lucinda Actor: Mrs Baker
Role: Mrs Sealand Actor: Mrs Stephens

Afterpiece Title: Harlequin Statue

Cast
Role: Colombine Actor: Mrs Dyer

Dance: A Tambourine-Miss Vallois

Performances

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Rutland Actor: Mrs Bellamy.

Afterpiece Title: Lethe

Cast
Role: Fine Lady Actor: Mrs Green.

Song: III, V: Legg

Dance: IV: Comic Ballet, as17580502

Performances

Mainpiece Title: The Siege Of Damascus

Cast
Role: Eudocia Actor: Mrs Bellamy.

Afterpiece Title: The School Boy

Cast
Role: Lady Manlove Actor: Mrs Pitt.

Dance: II: Tambourine-Miss Vallois; IV: Dutch Dance-Miss Vallois; End: By Particular Desire, The Roast Beef of Old England, as17580420

Performances

Mainpiece Title: Theodosius

Cast
Role: Pulcheria Actor: Mrs Vincent
Role: Athenais Actor: Mrs Bellamy.

Afterpiece Title: Miss in Her Teens

Cast
Role: Biddy Actor: Mrs Green

Dance: NewComic Dance, as17580417

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Rutland Actor: Mrs Bellamy
Role: Nottingham Actor: Mrs Vincent
Role: Queen Actor: Mrs Hamilton.

Afterpiece Title: Lethe

Cast
Role: Fine Lady Actor: Mrs Green.

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Lucinda Actor: Mrs Baker
Role: Phillis Actor: Mrs Vincent
Role: Mrs Sealand Actor: Mrs Stephens
Role: Indiana Actor: Mrs Bellamy.

Afterpiece Title: The Knights

Song: Lowe

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Cast
Role: Serina Actor: Mrs Baker
Role: Florella Actor: Mrs Pitt
Role: Monimia Actor: Mrs Bellamy.

Afterpiece Title: Harlequin Skeleton

Cast
Role: Aerial Spirits Actor: Granier, Mrs Granier
Role: Columbine Actor: Mrs Dyer

Performances

Mainpiece Title: Tancred And Sigismunda

Cast
Role: Laura Actor: Mrs Vincent
Role: Sigismunda Actor: Mrs Bellamy.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green

Dance: New comic Dance call'd%The Threshers-Lucas, Leppie, Mlle Capdeville, Rochford, Desse, Dumai, Goslin, Mrs Viviez, Mrs Granier, Mrs Jansolin, Mrs Dawson, Mrs Leppie, Mrs Dulies

Performances

Mainpiece Title: Tancred And Sigismunda

Cast
Role: Laura Actor: Mrs Vincent
Role: Sigismunda Actor: Mrs Bellamy.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17581014 [but Goslin now spelled Gosly.

Performances

Mainpiece Title: Tancred And Sigismunda

Cast
Role: Laura Actor: Mrs Vincent
Role: Sigismunda Actor: Mrs Bellamy.

Afterpiece Title: The Virgin Unmasked

Cast
Role: Lucy Actor: Mrs Green.

Dance: As17581016

Performances

Mainpiece Title: Othello

Cast
Role: Emilia Actor: Mrs Hamilton
Role: Desdemona Actor: Mrs Bellamy.

Afterpiece Title: The Double Disappointment

Dance: As17581016