SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Lavaro"/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: L'avaro Deluso

Dance: With new Dances composed by Simonet. End II: La Noche Hollandoise-Banti, Zuchelli, Slingsby, Sga Zuchelli, Sga Tinti; End Opera: a new grand Serious Ballet, Les Nymphes de Diane; ou, L'Amour Faune-Mons Simonet, Mme Simonet, Banti, Sga Tinti

Ballet: End I: new Pantomime Ballet Annette et Lubin. Bailly-LeDet; Sig. du Village-Simonet; Lubin-Slingsby; Annette-Mme Simonet; unassigned-Sg Zuchelli, Sga Zuchelli

Performances

Mainpiece Title: L'avaro Deluso

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Dance: End I: Les Oiseleurs, as17790123; End II: Ballet by Fairies, as17790302End Opera: New Ballet, as17790227

Performances

Mainpiece Title: L'avaro

Dance: End of Act I La Begueule, as17830531; End of Act II Le Tuteur Trompe, as17830111, but omitted: Slingsby, Mlle Theodore

Performances

Mainpiece Title: L'avaro

Dance: End of Act I Il Riposo del Campo, as17830603 with Pas de Deux, as17830603 and Pas de Basque, as17830111; End of Act II Le Tuteur Trompe, as17830506