SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "J Roach"/1) | (@(roleclean,performerclean) "J Roach")') 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 880 matches on Performance Comments, 449 matches on Event Comments, 94 matches on Performance Title, 12 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17721023

Performances

Mainpiece Title: Othello

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17721023

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Witches

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Harlequin's Invasion

Dance: I: A Comic Dance, as17720922

Performances

Mainpiece Title: Zara

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: King Arthur; Or, The British Worthy

Afterpiece Title: Wits Last Stake

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Irish Widow

Dance: I: Comic Dance, as17720922

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Witches

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Witches

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Devil to Pay

Dance: V: Comic Dance, as17720922

Performances

Mainpiece Title: All For Love; Or, The World Well Lost

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Orphan

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: The Drummer; Or, The Haunted House

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: Theodosius; Or, The Force Of Love

Afterpiece Title: The Pigmy Revels

Dance: III: The Butterfly, as17721204

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Pigmy Revels

Dance: III: Comic Dance, as17720922

Performances

Mainpiece Title: All For Love

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: Merope

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Lyar

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Wedding Ring