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

Performances

Mainpiece Title: Elisa

Performances

Mainpiece Title: Elisa

Performances

Mainpiece Title: Elisa

Performances

Mainpiece Title: Elisa

Performances

Mainpiece Title: Elisa

Performances

Mainpiece Title: An Act Of Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Dance: End: Les Rivaux Genereux, as17980306End 2nd piece: Elisa- [see17980510]

Performances

Mainpiece Title: Elfrida

Dance: End I: Peggy's Love, as17980428; End Opera: Elisa, as17980515

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: End I: Peggy's Love, as17980428; End Opera: Elisa- , as17980515, in which Mme Rose , who is greatly recovered from her late illness, will, at her own desire, resume her situation

Performances

Mainpiece Title: Gli Schiavi Per Amore

Dance: End I: [a new Divertisement Ballet, composed by Barre with music by Bossi], Le Marchand de Smyrne-; End Opera: Elisa-

Performances

Mainpiece Title: Gli Schiavi Per Amore

Dance: End I: Peggy's Love, as17981211; End Opera: Elisa, as17981226