SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Finta Sposa"/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: The Miser

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: La Tambourine-Mlle Chateauneuf; II: La Tambourine Matelote-Maltere, Mlle Maltere; IV: Miss Scott; V: Serious Dance-Maltere, Mlle Maltere

Song: III: Was Ever Nymph Like Rosamond-Lowe

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: Grand Ballet-Maltere, Mlle Maltere; III: La Tambourine-Mlle Chateauneuf; V: La Matelote-Maltere, Mlle Maltere

Song: II: Noon Tide Air-Lowe; IV: The Happy Pair-Lowe

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Mock Doctor

Song: I: The Eccho Song in Comus-Mrs Arne; II: Blow Blow thou Winter Wind-Lowe; V: The Noon@Tide Air-Mrs Clive

Dance: III: La Tambourine-Mlle Chateauneuf; IV: La Matelote-Maltere, Mlle Maltere

Performances

Mainpiece Title: The Orphan

Dance: II: Les Moisoneurs de la Styrie, as17421201; IV: A New Comic Dance call'd La Recrue des Houssars-Checo, Chiaretta, Boromeo, Mlle Bonneval

Song:

Performances

Mainpiece Title: Oroonoko

Dance: II: Les Moisoneurs de la Styrie, as17421201; IV: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: The Rehearsal

Dance: I: Les Moisoneurs de la Styrie, as17421201; III: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: The Conscious Lovers

Dance: II: Les Moisoneurs de la Styrie, as17421201; V: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: As You Like It

Dance: I: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars-Checo, Chiaretti

Performances

Mainpiece Title: The Stratagem

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: The Miser

Dance: II: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars, as17421221

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: The Devil to Pay

Song: I: Lowe; IV: Beard

Dance: II: Les Moisoneurs de la Styrie, as17421201; La Florana, as17430408

Performances

Mainpiece Title: La Finta Frascatana

Dance: Between Acts: Dancing-

Performances

Mainpiece Title: Les Jeux De L'amour Et Du Hazard

Afterpiece Title: La Coquette sans la Savoir

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Lethe

Song: I: The Highland Lad (set by Master Arne)-Master Mattocks; III: Singing-Master Mattocks

Dance: II: La Sabotiere-Master Maltere, Miss Foulcade; IV: Les Fantasies de la Dance-Mlle DelaContri; End: Minuet-Mathews, Mlle Contri

Performances

Mainpiece Title: La Je Ne Sca Quoi; Or, Wooden Spoons A La Mode

Dance: LLady Pentweazle's Vagaries-; Hornpipe-Timbertoe; Kettle Drums-Woodbridge

Entertainment: Concert On Salt@Box-Signora Tatteratro

Performances

Mainpiece Title: Il Ratto De La Sposa

Performances

Mainpiece Title: Il Ratto De La Sposa

Performances

Mainpiece Title: Il Ratto De La Sposa

Performances

Mainpiece Title: La Sposa Fedele

Dance: I: New Pantomime Ballet, Apollon e Daphne-Helm, Mlle Sophie; with new Pastoral Entree-Sga Tinti; End Opera: New Grand Pantomime Ballet, PigmalionAmoureuse de La Statue-Fierville, Helm, Mlle Baccelli, Sga Tinti, Mlle Sophie

Ballet: II: Le Triomphe D'Euthime sur Le Genie de Liba. Euthime-Fierville; La Victime-Baccelli; L'Ombre-Helm; with Pas de Deux-Henery, Mlle Sophie

Performances

Mainpiece Title: La Sposa Fedele

Dance: Apollon e Daphne, as17751031; End Opera: Pigmalion, as17751031

Ballet: I: Le Triomphe D'Euthime sur Le Genie de Liba. Euthime, As17751031

Performances

Mainpiece Title: La Sposa Fedele

Dance: I: Il Filosofo Amoroso-Paladini (first appearance), Sga Tinti; II: Apollon e Daphne, as17751031; End Opera: Pigmalion, as17751031

Performances

Mainpiece Title: La Sposa Fedele

Dance: As17751104

Ballet: Le Triomphe D'Euthime sur Le Genie de Liba. As17751104

Performances

Mainpiece Title: La Sposa Fedele

Dance: Le Triomphe-; Il Filosofo-Paladini, Sga Tinti, Helm; Pigmalion, as17751116

Performances

Mainpiece Title: La Sposa Fedele

Dance: Apollon e Daphne, as17751031; Il Filosofo, as17751128; Pigmalion, as17751128

Performances

Mainpiece Title: La Sposa Fedele

Dance: As17751128