SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Sandford"/1) | (@(roleclean,performerclean) "Mr Sandford")') 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 4230 matches on Event Comments, 1192 matches on Performance Comments, 528 matches on Performance Title, 18 matches on Author, and 3 matches on Roles/Actors.

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Genii

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: Philaster

Afterpiece Title: Daphne and Amintor

Dance: II: The Provencale, as17740928; III: The Vintage Festival, as17741007

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Deserter

Dance: II: The Irish Fair, as17740917

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Election

Afterpiece Title: The Elopement

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Cross Purposes

Dance: End Opera: The Merry Sailors, as17741026

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Election

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Election

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Election

Afterpiece Title: The Elopement

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Deserter

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Genii

Dance: III: The Irish Fair, as17740917

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17740917

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Cobler

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Cobler

Performances

Mainpiece Title: The Choleric Man

Afterpiece Title: The Anatomist

Dance: End: The Grand Provencalle Dance, as17741213

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Deserter

Dance: II: The Grand Provencalle Dance, as17741213

Performances

Mainpiece Title: The Choleric Man

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17740917

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Matilda

Afterpiece Title: The Irish Widow

Performances

Mainpiece Title: The Choleric Man

Afterpiece Title: Harlequin's Jacket

Dance: I: Grand Provencalle Dance, as17741213

Performances

Mainpiece Title: Matilda

Afterpiece Title: The Mayor of Garratt

Dance: V: The Irish Fair, as17740917

Performances

Mainpiece Title: Matilda

Afterpiece Title: Harlequin's Jacket

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Rival Candidates

Dance: In Course: The Grand Provencalle Dance, as17750202