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 Mysteries Of The Castle

Afterpiece Title: Two Strings to Your Bow

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

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Merry Sherwood

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: A Divertisement

Entertainment: MonologueAfter dancing: Belles! Have at ye All-Mrs Mattocks

Ballet: End: Dermot and Kathlane; or, The Irish Wedding (composed by Byrn). Dermot-Byrn; Darby-Jackson; Patrick-Holland; Father Luke-Platt; Norah-Mlle St.Amand; Old Kathlane-Miss Smyth; Kathlane (only time [i.e. appearance] this season)-Mme Rossi. [And see17931018.

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Harlequin and Oberon

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Harlequin and Oberon

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: A Divertisement

Dance: As17971013