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: Artaxerxes

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Bonds without Judgement

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Enchanted Castle

Song: As17870924

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: The Enchanted Castle

Song: III: song-Mrs Kennedy

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Enchanted Castle

Song: V: a Roman Ovation-; Vocal Parts-Johnstone, Cubitt, Darley, Doyle, Bonville, Rock, Janson, Mrs Martyr, Mrs Mountain, Miss Stuart, Mrs Davenett, Mrs Watts, Mrs Gray, Miss Rowson, Miss Paye, Mrs Byrne, Mrs Kennedy

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Commissary

Ballet: End: The Wapping Landlady; or, Jack in Distress. Jack in Distress-Blurton; Wapping Landlady-Mr King; Orange Woman-Mrs Watts

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Omai

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Minor

Dance: As17880328

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Poor Soldier

Dance: As17880328

Performances

Mainpiece Title: The Brothers

Afterpiece Title: Love and War

Dance: End: a new dance, The Cobler of Castle Dormot-Ratchford, Miller, Mrs Ratchford

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Look before You Leap

Afterpiece Title: Such Things Have Been

Song: End 3rd piece: Paddy's Ramble from Dublin to Londonwritten and to be sung-Ryder

Entertainment: Monologue. In course of Entertainments: Bucks have at Ye All-Ryder

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Midnight Hour

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