SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Regina di Golconda"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Antigono

Dance: I: Minuet a la Cour-the two Vallouys; II: Pigmalion-Fierville, Helm, Mlle Sophie, Mlle Baccelli; End Opera: La Fete du Village, as17760224

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770524; End II: Serious Ballet, as17770225; End Opera: La Clochette, as17770315

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Force de l'Amour, as17761214; End II: New Serious Ballet, as17770412; End Opera: La Clochette, as17770531

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770524; End II: Serious Ballet, as17770225; End Opera: La Clochette, as17770531

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Paysane Distraite, as17770524, but Sga _Zuchelli; End II: Serious Ballet, as17770225, but Sga _Zuchelli; End Opera: La Clochette, as17770315but Sga _Zuchelli

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770617 End II: Serious Ballet, as17770617 End Opera: La Clochette, as17770315but Sga _Zuchelli, Mlle DeCamp

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770617 End II: La Clochette, as17770624 End Opera: Serious Ballet, as17770621

Performances

Mainpiece Title: L'ali D'amore

Dance: End I: La Clochette, as17770617, but omitted: Sga Zuchelli; End II: Minuet de la Cour, as17770508; End Opera: Serious Ballet-Mons and Mme Simonet, Vallouy@le@cadet, Mlle Baccelli

Song: Preceding last ballet: Address of Thanks (composed for the occasion by Rauzzini)-Rauzzini, Miss Storace

Performances

Mainpiece Title: Le Due Contesse

Dance: End I: Le Devin du Village, as17771104; End II: La Polonaise Favourite, as17771104; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: End I: Divertisement, as17780207; End Opera: new grand Serious Ballet, Les Amans unis par l'Hymen-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet

Song: II: an air-Sga Danzi; [accompanied on the violin-Cramer; violoncello-Cervetto; German flute-Florio; hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: End I: Divertisement, as17780207; End II: La Serenade Interrompuee, as17780224; End Opera: Les Amans unis par l'Hymen, as17780404

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: As17780404

Performances

Mainpiece Title: La Vera Costanza

Dance: End I: Divertisement, as17780207; End II: Les Bohemiens, as17771216; End Opera: Masquerade Dance, as17780303Minuet de la Cour=, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: As17780404

Ballet: La Surprize de Daphnis et Cephise. As17780404

Performances

Mainpiece Title: L'amore Soldato

Dance: As17780331nd I: Masquerade Dance; End II: La Surprize de Daphnis et Cephise; End Opera: La Serenade Interrompuee.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: As17780404

Ballet: La Surprize de Daphnis et Cephise. As17780404

Performances

Mainpiece Title: L'amore Soldato

Dance: End I: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End II: Les Bohemiens, as17771216; End Opera: Serious Ballet, as17780120

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: As17780404

Ballet: La Surprize de Daphnis et Cephise. As17780404

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: As17780404

Ballet: La Surprize de Daphne et Cephise. As17780404

Performances

Mainpiece Title: L'amore Soldato

Dance: End I: Divertisement, as17780207; with a Minuet-Mons and Mme Simonet; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: L'Amour dans la Vendange, as17780519; End II: The Masquerade Ballet-; in which a Minuet-Mme Simonet en homme, or in man's dress,, Mlle Baccelli; End Opera: La Serenade Interrompuee, as17780224; in which the Minuet Dauphin-Mme Simonet in man's dress, Mlle Banti

Performances

Mainpiece Title: Il Re Pastore

Dance: End I: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: Les Amans unis par l'Hymen, as17780404

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Dance: End I: Divertisement, as17780526; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: L'amore Soldato

Dance: End I: Divertisement, as17780207; End II: L'Amour dans la Vendange, as17780519; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: Creso

Dance: End I: La Polonaise Favourite, as17771104; End Opera: La Serenade Interrompuee, as17780224

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331