SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Sganarelle ou Le Cocu imaginaire"/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: Erifile

Dance: End I: La Polonaise Favourite, as17780131; End II: Les Bohemiens, as17771216; End Opera: Divertisement-Mons and Mlle Banti, Vallouy@le@cadet, Mlle Baccelli

Song: In II: Air-Sga Danzi; accompanied on the Hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: End I: Divertisement, as17780207; End Opera: new grand Serious Ballet, Les Amans unis par l'Hymen-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet

Song: II: an air-Sga Danzi; [accompanied on the violin-Cramer; violoncello-Cervetto; German flute-Florio; hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331