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

Afterpiece Title: The Midnight Hour

Dance: As17920420

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE MAID OF THE OAKS

Dance: End of mainpiece The Drunken Swiss, as17931015; In Act I of afterpiece a Dance by Holland and Mlle St. Amand

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE PRISONER AT LARGE

Dance: End of mainpiece The Wapping Landlady by Blurton and Mrs Watts

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Witch of the Wood; or, The Nutting Girls

Dance: In: The Spanish Fandango-Byrn, Mlle St.Amand; II afterpiece: The Humours of a Country Fair-Holland, Platt, Bayzand, Cranfield, Ratchford, Mrs Lloyd, Mrs Blurton, Miss Smyth, Mrs Watts

Song: End: Sally in our Alley-Incledon

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Honest Thieves

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Round Tower

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Raymond and Agnes

Dance: As17971012

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Afterpiece Title: Bon Ton

Song: Mainpiece: Vocal Parts-Dignum, Danby, Brown, Mrs Bland, Miss Menage, Master Heather, Miss Jackson; End II: Jerry Sneak in his Glory-Roberts; End IV: The Town Crier-Suett; End: As burns the charger (from Robin Hood)-Sedgwick; End I afterpiece: At the peaceful Midnight Hour (from The Castle of Andalusia)-Sedgwick

Opera: V: Masque of Neptune and Amphitrite. Neptune-Caulfield; Amphitrite-Miss Wentworth

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Catherine and Petruchio

Performances

Mainpiece Title: The Northern Castle

Performances

Mainpiece Title: The Mock-tempest; Or, The Enchanted Castle

Performances

Mainpiece Title: L'honorata Poverta Di Rinaldo: Viz, The Honourable Poverty Of Rinaldo, False Accused By The Maganzesians: With Harlequin Guardian To His Master's Family And Defender Of His Castle

Performances

Mainpiece Title: Ephalus: With The Death Of Procris

Afterpiece Title: Harlequin Restor'd

Dance: DDrunken Peasant-Phillips; Hornpipe-Phillips; The Parting Lovers-Phillips

Song: TThe Maid's Wish-Mrs Phillips; A song by Lampe-Parry in Praise of Admiral Vernon upon his taking Chagre Castle

Performances

Mainpiece Title: The Gentle Shepherd; Or, Patie And Roger

Afterpiece Title: Entertainments of Singing and Dancing

Dance: Conclude: reel-the characters

Song: End I: The Banks of the Tweed-Mrs Moss; End III: Rosilind Castle-Mrs Moss; End: The Banks of Invermay-Mrs Moss