SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "La Cameriera Accorta"/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 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 Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village-Vallouy, Mme Vallouy, Helm, Mlle Sophie, Sga Tinti; End Opera: Pigmalion Amoureuse de La Statue, as17751031

Performances

Mainpiece Title: Il Bacio

Dance: I: New Serious Ballet-Fierville, Mlle Baccelli; II: La Fete du Village, as17760224; End Opera: La Generosite, as17760109

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