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

Afterpiece Title: The Author

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: St

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Positive Man

Dance: End of mainpiece new Pastoral Ballet (composed by Harris), The Rival Nymphs, by Byrn, Ratchford, Harris, Miss Byrn, Miss Matthews

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Retaliation

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Rosina

Dance: End of mainpiece, as17830917

Song: In Act I of afterpiece a favourite song by Sga Sestini; In Act II she will introduce the celebrated tune of Marlborough, with English words adapted to it

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Song: End of mainpiece September the Thirteenth proud Bourbon may mourn, from Gretna Green (composed by Dr Arnold) by Bannister

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Rosina

Song: End of mainpiece Edwin's favorite song in The Castle of Andalusia, A Master I have, by Master Sestini

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Rosina

Dance: As17841001

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Deserter

Dance: End of mainpiece The fancy Races {performers not listed]

Song: End of Act I of mainpiece Tantivy, the welkin resounds (the Music by Hook); End of Act II a new song, The New Blown Rose (the Words by Mrs Cumyns, the Music by Dale), both by Mrs Martyr

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Commissary

Performances

Mainpiece Title: The Castle Of Andalusia [and See 14 Oct

Afterpiece Title: Omai

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Drummer

Dance: As17851019

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Omai

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Enchanted Castle