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: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930823

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

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2