SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Castle Of Andalusia"/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: 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

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

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Mysteries Of The Castle

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

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

Performances

Mainpiece Title: England Preserv'd

Afterpiece Title: The Irish Mimick; or, Blunders at Brighton

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Irish Mimick

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: The Irish Mimick

Afterpiece Title: Windsor Castle

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Windsor Castle

Song: Vocal Parts, as17950309but Mrs _Lloyd, Mrs _Bayzand, Mrs _Blurton, Mrs _Masters

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: Wives As They Were, And Maids As They Are

Afterpiece Title: Raymond and Agnes; or, The Castle of Lindenbergh

Song: Afterpiece: Vocal Parts-Gray, Linton, Street, Mrs Henley, Mrs Castelle, Miss Leserve. [Not listed on playbill, but in Songs (see below).

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Raymond and Agnes; or, The Castle of Lindenbergh

Dance: In II: as17971006; Afterpiece to conclude with: a Finale-; Spanish Fandango-

Entertainment: Monologue. As17971006