SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Delavals"/1) | (@(roleclean,performerclean) "Delavals")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 18 matches on Roles/Actors, 13 matches on Performance Title, 4 matches on Event Comments, 3 matches on Performance Comments, and 0 matches on Author.

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Botheration

Dance: Between mainpiece and afterpiece: a Hornpipe-Jackson

Song: End: The Irish Newsman-Clarke; In afterpiece: Mr O'Blarney's Description of London, as17980508

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Rosina

Performances

Mainpiece Title: Tamerlane

Dance: As17050109

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Taste

Song: III: Haughty Strephon by Dr Arne-Master Vernon

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Englishman in Paris