SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Mirror or Harlequin Every where"/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 Earl Of Essex Or The Unhappy Favorite

Afterpiece Title: The Volcano or The Rival Harlequins

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Volcano

Performances

Mainpiece Title: Speed The Plough

Afterpiece Title: Oscar and Malvina or The Hall of Fingal

Song: In afterpiece: I am a jolly gay Pedlar-Townsend; Come every jovial fellow-Miss Sims, Mrs Castelle, Miss Wheatley; O ever in my bosom live-Mrs Chapman, Mrs Atkins

Performances

Mainpiece Title: Speed The Plough

Afterpiece Title: Oscar and Malvina

Song: I am a jolly gay Pedlar, as18000304O ever in my bosom live, as18000304Come every jovial fellow-Simmons, Mrs Sydney, Miss Wheatley

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Birth Day

Afterpiece Title: A Song for Every Body

Afterpiece Title: Obi