Search

Toggle Sphinx Query

SELECT * FROM london_stages WHERE eventid IN (1578, 1794, 2046, 4571, 4903, 5147, 13278, 13285, 13293, 13300, 13303, 13323, 13336, 13340, 13348, 13496, 13499, 13500, 13502, 13523, 13555, 13636, 13720, 13829, 13858, 13868, 13872, 13951, 16091, 16097, 20562, 22267, 22347, 23202, 23925, 23928, 23932, 23935, 23944, 23987, 24002, 24017, 24059, 24064, 24160, 24185, 30392, 30794, 30817, 30848, 30873, 31041, 31060, 31166, 31190, 31260, 31468, 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, 31600, 31606, 31630, 31643, 31661, 31668, 31697, 31746, 31774, 31868, 31876, 31884, 32355, 32369, 32387, 32400, 32415, 32440, 32478, 32485, 32499, 32513, 32543, 32545, 32547, 32550, 32552, 32555, 32557, 32559, 32561, 32564, 32566, 32569, 32571, 32576, 32581, 32585, 32589, 32592, 32594, 32598, 32601, 32604, 32606, 32610, 32614, 32617, 32627, 32640, 32649, 32657, 32667, 32681, 32711, 32730, 32744, 32826, 32841, 32853, 32863, 32875, 32885, 32893, 32895, 32904, 32911, 32916, 32952, 32970, 33018, 33032, 33040, 33048, 33060, 33071, 33085, 33113, 33127, 33130, 33142, 33171, 33184, 33186, 33280, 33288, 33333, 33382, 33438, 33487, 33532, 33541, 33544, 33546, 33549, 33568, 33655, 33689, 33826, 33846, 33904, 33934, 33992, 34029, 34169, 34208, 34243, 34247, 34898, 34950, 35006, 35095, 35148, 35261, 35273, 35309, 35657, 35663, 35697, 35757, 35772, 35855, 35900, 37219, 37222, 37230, 37240, 37277, 37327, 37401, 37403, 37593, 37652, 37686, 41777, 41782, 41791, 41798, 41805, 41810, 41819, 41824, 41829, 41834, 41844, 41849, 41854, 41859, 41864, 41873, 41878, 41883, 41888, 41894, 41899, 41904, 41910, 41919, 41924, 41927, 41932, 41937, 41942, 41946, 41951, 41955, 41959, 41964, 41968, 41972, 41977, 41981, 41985, 41991, 41995, 41999, 42004, 42008, 42012, 42018, 42023, 42027, 42038, 42043, 42048, 42054, 42064, 42069, 42074, 42079, 42084, 42089, 42094, 42109, 42130, 42155, 42158, 42167, 42185, 42196, 47271, 51748) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Search Filters

Event

Performance

Cast

Keyword

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: As17820219 throughout

Cast

Song: In Act II two new songs by Sga Allegranti, one of which composed by Giardini

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I Pastoral Dance, as17820129; End of Act II Divertisement Dance, as17820307End of Opera Adela of Pontbieu, as II Apr

Cast

Performances

Mainpiece Title: La Contadina In Corte

Dance: As17820402 throughout

Cast

Performances

Mainpiece Title: I Vlaggiatori Felici

Dance: End of Act I Le Triomphe de l'Amour Conjugal, as17820110; End of Opera Medea and Jason, as17820411

Cast

Performances

Mainpiece Title: La Contadina In Corte

Dance: End of Act I Le Triomphe de l'Amour Conjugal, as17820110; End of Opera Adela of Pontbieu, as17820411

Cast

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I Pastoral Dance, as17811128; End of Act II Apollon et les Muses, as17820502; End of Opera New Dance, as17820502

Cast

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I New Divertisement Dance, as17820216; End of Act II Apollon et les Muses, as17820509; End of Act III New Dance, as17820507

Cast

Performances

Mainpiece Title: Ifigenia In Aulide

Dance: End of Act I Divertisement Dana, as17811117, but omitted: Gardel, Mlle Baccelli; End of Opera Mirsa, as17820516

Cast

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Le Triompbe de l'Amour Conjugal, as17820312End of Act II Rinaldo and Armida, as17820223

Cast

Performances

Mainpiece Title: La Contadina In Corte

Dance: End of Act I Divertisement Dance, as17820525; End of Opera Apollon et les Muses, as17820502, but omitted: Mme Simonet, Mlle Baccelli

Cast

Performances

Mainpiece Title: Ezio

Dance: End of Act I New Divertisement Dance, as17820216, but omitted: Nivelon; End of Act II Apelles and Campaspe, as17820605 End of Opera Adela of Pontbieu, as17820411

Cast

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Apollon et les Muses, as17820601 End of Opera Medea and Jason, as17820411

Cast

Performances

Mainpiece Title: Entertainments Of Music And Dancing

Cast

Dance: End I: Divertissement-all the Principal Dancers; will be introduced the favourite Pas Russe, as17910519; End II: Orpheus and Eurydice, as17910326but Mlle St.Amand

Performances

Mainpiece Title: Grand Selection 0 Of Music, From The Works Of handel, boyce, arne, And purcell

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violoncello-Charles Ashley