SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Famiglia In Scompiglio"/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: Il Bacio

Dance: Les Deux Soeurs, as17760224; La Fete du Village, as17760224; End Opera: La Generosite de Scipion, as17760213

Performances

Mainpiece Title: Il Bacio

Dance: I: La Fete du Village, as17760224; II: New Serious Ballet, with Chaconne and Minuet de la Cour-Vallouy, Mme Vallouy; End Opera: New Grand Comic Ballet, Les Maissoneurs Distresse-Helm, Mlle Sophie, Sga Tinti, Vallouy, Mrs Vallouy

Performances

Mainpiece Title: La Vestale

Dance: Apollon e Daphne, as17751031; Minuet de la Cour-the two Vallouys; End II: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Caio Mario

Dance: I: La Fete du Village, as17760224; II: Diane et Endymion, as17760312 End Opera: Ballet-; with a Chaconne-; and a Minuet de la Cour-the two Vallouys

Performances

Mainpiece Title: Caio Mario

Dance: La Fete du Village, as17760504; Diane et Endymion, as17760504; Minuet de la Cour, as17760504

Performances

Mainpiece Title: Antigono

Dance: La Fete du Village, as17760504; Diane et Endymion, as17760504; Le Minuet de la Cour, as17760504

Performances

Mainpiece Title: L'isola D'amore

Dance: After Overture: Le Minuet a la Cour-the two Vallouys; End I: Diane et Endymion, as17760312 End Opera: La Fete du Village, as17760224

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 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: 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: 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: 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