SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Drummer; Or The Haunted House"/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 Fatal Extravagance

Afterpiece Title: The Country House

Afterpiece Title: The Magician

Performances

Mainpiece Title: The Emperor Of The Moon

Afterpiece Title: The Country House

Performances

Mainpiece Title: The Fatal Extravagance

Afterpiece Title: The Country House

Afterpiece Title: The Jealous Doctor

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Harlequin Executed

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Harlequin Executed

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Cheats

Song: As17211220

Dance:

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Cheats

Song: As17211220

Dance:

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Magician

Song: The South Sea Ballad-Aston

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Magician

Song: As17220210

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Amadis

Song: With some Chansons a Boir to be sung-Leveridge; Also a New Ballad call's, The Faithful Mariner, after the Manner of a true English Sailor-

Performances

Mainpiece Title: The Drummer

Dance: Lally, Pelling, Feild, Mrs Rogeir, Mrs Bullock, Miss Hutton

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Jealous Doctor

Music: Between the Acts: Select Pieces of Musick-; accompanied with Trumpets Flutes German Flutes and French Horns-; Particularly Hendel's Water Musick-

Dance: As17211003

Performances

Mainpiece Title: The Drummer

Dance:

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Walking Statue

Dance:

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Jealous Doctor; or, The Intriguing Dame

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Jealous Doctor

Dance: Myrtillo-

Performances

Mainpiece Title: The Drummer

Dance:

Performances

Mainpiece Title: Cartouche; Or, The French Robbers

Afterpiece Title: The Country House

Dance:

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Dance: Lally, Lally Jr, Newhouse, Pelling, Mrs Rogier, Mrs Bullock, Mrs Cross

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Dance: As17230219

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Dance: As17230219

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Afterpiece Title: Amadis

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Jupiter and Europa

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Afterpiece Title: Hob

Performances

Mainpiece Title: Cartouche

Afterpiece Title: The Country House

Dance: