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

Performances

Mainpiece Title: The Flitch Of Bacon

Afterpiece Title: Tit for Tat

Afterpiece Title: Caernarvon Castle

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930823

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: THE WARD OF THE CASTLE

Song: In afterpiece Chorusses by Linton, Tett, Sawyer, Little, Street, Kendrick//Miss Stuart, Mrs Watts, Mrs Follett, Mrs Castelle, Miss Kirton, Mrs Lloyd, Miss Paye, Miss Leserve, Mrs Bayzand, Mrs Blurton

Performances

Mainpiece Title: Grief A-la-mode [i

Afterpiece Title: THE WARD OF THE CASTLE

Song: As17931024

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: THE WARD OF THE CASTLE

Dance: As17931022

Song: In Act III of mainpiece, as17931008; In afterpiece, as17931024

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE MAID OF THE OAKS

Dance: End of mainpiece The Drunken Swiss, as17931015; In Act I of afterpiece a Dance by Holland and Mlle St. Amand

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE PRISONER AT LARGE

Dance: End of mainpiece The Wapping Landlady by Blurton and Mrs Watts

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: He Wou'd be a Soldier

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Modern Antiques

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The School for Arrogance

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Hartford Bridge

Dance: As17941001

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Midas

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge