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: A Christmas Tale

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Padlock

Dance: II: The Corsican Sailors-Fishar, Miss Twist, Mas. Blurton, Miss Besford, as17731013

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: She Wou'd And She Wou'd Not; Or, The Kind Imposter

Afterpiece Title: The Sylphs

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Man Of Business

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Neck or Nothing

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: The Genii

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Irish Widow

Dance: V: The Mountaineers, as17730930; End I Farce: The Irish Fair, as17730918

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Author

Performances

Mainpiece Title: Don Sebastian, King Of Portugal

Afterpiece Title: The Upholsterer

Dance: End: The Old Ground Young, as17731208

Performances

Mainpiece Title: The Fall Of Egypt

Music: As17740218

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Elopement