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

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Love a-la-Mode

Song: End I: Wine cannot cure the pain I endure for my Chloe-Johnstone, Incledon; with new accompaniments by Shield-; End: Catches and Glees-Bannister, Johnstone, Incledon, Davies, Blanchard, Williamson; The Anacreontic Song-Bannister; The Introductory Dialogue, in Irish Character-Rock

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Deaf Lover

Dance: As17910507

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Midnight Hour

Dance: As17920420

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: Mainpiece: As17930803

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: Mainpiece: Vocal Parts, as17930803, but _Little, _Brown, _Hobler, _Horsfall, _Saunders, _Dibble, _Lyons

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930816

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