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

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Dance: Comic dances-the Devonshire Girl, Mrs Bicknell

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Song: As17050922

Dance: As17050929

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Song: As17161022

Dance: Mimic Night Scene, as17161022

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Dance: Shaw, Topham, Mrs Santlow, Mrs Bicknell

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers

Performances

Mainpiece Title: The Rover; Or, The Banish'd Cavaliers