SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sandham"/1) | (@(roleclean,performerclean) "Sandham")') 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 457 matches on Roles/Actors, 177 matches on Performance Title, 78 matches on Performance Comments, 15 matches on Event Comments, and 0 matches on Author.

Performances

Mainpiece Title: The Fatal Marriage

Performances

Mainpiece Title: Love Makes A Man

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: The Distrest Mother

Performances

Mainpiece Title: King Richard Iii

Performances

Mainpiece Title: Don John

Performances

Mainpiece Title: The Orphan

Performances

Mainpiece Title: Aurengzebe

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Cato

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Sir Courtly Nice

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Mithridates, King Of Pontus

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Committee

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Lancashire Witches; Or, Teague O'divelly

Afterpiece Title: Harlequin's Triumph

Music: ll the Witches Musick both Vocal and Instrumental, by the late Mr Barret-

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Julius Caesar

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: Cato

Afterpiece Title: Harlequin's Triumph

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Amorous Sportsman

Song: Master Cuttin