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

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: Joanna

Afterpiece Title: The Intriguing Chambermaid

Song: Mainpiece: Chorusses-Denman, Lee, Thomas, Lewiss, Little, Potts, Everett, Oddwell, J. Linton, Tett, Smith, Kenrick, Silvester, Jones, Fairclough, Baron, Master Goodwin, Master Slape, Master Bernard, Master Standen, Master Little, Master Speare, Master Sawyer, Master Linton, Ms Trevor, Ms Gilbert, Ms Norton, Ms Watts, Ms Follett, Ms Castelle, Ms Sydney, Ms Burnett, Ms Masters, Ms Lloyd, Ms Blurton, Ms Cox