SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Costanza Di Rosinella"/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: 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 Committee; Or, The Faithful Irishman

Dance: II: a New Comic Dance La Mascarada-Brunoro, Borromeo, Mlle Bonneval, Sga Costanza; V: New Comic Dance Les Matelotes-Brunoro, Borromeo, Mlle Bonneval, Sga Constanza

Song: III: Song-Beard

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Miss Lucy in Town

Dance: II: La Mascarada-Brunoro, Mlle Bonneval; IV: Turkish Seraglio-Brunoro,Signora Costanza

Music: III: Concerto-Piantinada

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 Clemenza Di Tito

Dance: Under the direction of Gallini:Mlle Asselin, Maranesi, Sga Provenzale

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito

Performances

Mainpiece Title: La Clemenza Di Tito