SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Enchanted 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 Provokd Wife

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: He Woud Be A Soldier

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Enchanted Castle

Dance: As17861023

Song: As17861211, but Vocal Parts-_Pemberton

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Enchanted Castle

Song: As17861021

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: The Provokd Husband

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Enchanted Castle

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

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Performances

Mainpiece Title: Brutus Of Alba Or The Enchanted Lovers

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Performances

Mainpiece Title: The Tempest Or The Enchanted Island

Entertainment: To be expressed in the Bills

Performances

Mainpiece Title: The Enchanted Island Of Arcadia Or The Magician Doctor With Harlequin King Of The Woods Flights Decorations And Transformations Of Harlequin Cupid Pantalon Venus And Brighella Jupiter And The Sacrifice Of Harlequin

Dance: Furies, Nymphs, Shepherds, Statues-; , the latter performing the Labours of Hercules-Statues , after the Manner of the Venetian Gondaliers at Venice: The whole full of Variety