SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Mysteries of the Castle"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

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: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Afterpiece Title: Caernarvon Castle; or, The Birth of the Prince of Wales

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 Rage

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Song: Part I: concludes with ancient British Airs-; Chorus of Bards-, accompanied on the Harp by Jones

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2