SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The General"/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 Iron Chest

Afterpiece Title: The Agreeable Surprise

Song: Mainpiece: General Chorus, as17970814, but added: Lyons, Miss +Andrews, _Walker, _Dibble, _Caulfield Jun., Ms _Edward, Ms _Gaudry, Ms _Hale

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Sylvester Daggerwood

Afterpiece Title: The Children in the Wood

Song: 1st piece: General Chorus, as17970816

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Peeping Tom

Song: 1st piece: General Chorus, as17970816

Performances

Mainpiece Title: General Fast

Performances

Mainpiece Title: general Fast

Performances

Mainpiece Title: General Fast