SELECT * FROM london_stages WHERE eventid IN (40110, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40166, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40229, 40241, 40246, 40255, 40260, 40268, 40273, 40280, 40293, 40317, 40321, 40404, 40414, 40429, 40434, 40482) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Demofoonte

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17791128, but Mlle Baccelli

Performances

Mainpiece Title: Demofoonte

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: Demofoonte

Dance: As17790311

Song: In III: an additional song, as17790311

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: Les Oiseleurs, as17790123; End Opera: New Ballet, as17790227

Ballet: End II: Annette et Lubin. As17781124

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: L'avaro Deluso

Dance: End I: Les Oiseleurs, as17790123; End II: Ballet by Fairies, as17790302End Opera: New Ballet, as17790227

Performances

Mainpiece Title: L'olimpiade

Dance: End I: Les Paysans Voles-LeDet, Sg and Sga Zuchelli; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, with Quadrilles, as17790615