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

Afterpiece Title: The Italian Monk

Song: 2nd piece: General Chorus [of Assassins and Nuns (text)]-Linton, Brown, Lyons, Aylmer, Little, Willoughby, Dibble, Kenrick, Caulfield Jun., Mrs Andrews, Miss Menage, Mrs Butler, Mrs Brown, Mrs Benson, Mrs Masters, Mrs Norton, Mrs Gaudry, Miss Leserve

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Rosina

Song: 1st piece: General Chorus, as17970815, but _Dibble, _Kenrick, _Caulfield Jun., Mrs _Gaudry, Mrs _Brown

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: Cheap Living

Afterpiece Title: Fast Asleep

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Fast Asleep

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Fast Asleep

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Fast Asleep

Afterpiece Title: A Trip to the Nore

Song: IV: as17971104