SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Clemenza di Scipione"/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 Twin Rivals

Afterpiece Title: The Intriguing Chambermaid

Dance: I: La Terpsichore (new)-Mlle Chateauneuf; II: Muilment; III: La Sabotiere-Mlle Chateauneuf; IV: L'Allemande-Muilment, Mlle Chateauneuf; V: A new Tambourine-Muilment, Mlle Chateauneuf

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Intriguing Chambermaid

Dance: I: La Tambourine-Mlle Chateauneuf; II: Shepherds and Shepherdesses-Muilment, Mlle Chateauneuf; III: Les Caprices des Rebelles (new)-Mlle Maltere; IV: L'Allemande-Muilment, Mlle Chateauneuf; V: La Rose Boree et Ziphirs (new)-Maltere, Mlle Maltere

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Toy Shop

Dance: LLe Paisan-LaPierre; II: La Provan Sale (Sailor's Dance)-Maltere, Mlle Maltere; III: Indian Dance (never in England before)-Maltere, Mlle Maltere; IV: Les Caprices des Rebelles-Mlle Maltere; V: La Rose Boree and Ziphirs-Maltere, Mlle Maltere

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Devil to Pay

Dance: II: La Tambourine-Mlle Chateauneuf; III: Les Caprices des Rebelles-Mlle Maltere; IV: La Terpsichore-Mlle Chateauneuf; V: Miss Scott

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: 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: La Disfatta Di Dario

Performances

Mainpiece Title: La Disfatta Di Dario

Performances

Mainpiece Title: La Disfatta Di Dario

Performances

Mainpiece Title: La Disfatta Di Dario

Performances

Mainpiece Title: La Disfatta Di Dario

Performances

Mainpiece Title: La Calamita Di Cuori

Performances

Mainpiece Title: La Calamita Di Cuori