SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Devil In The Wine cellar"/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: Artaxerxes

Afterpiece Title: The Devil upon Two Sticks

Dance: As17870131

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Afterpiece Title: The Devil to Pay

Song: As17870515

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Devil upon Two Sticks

Dance: As17870131

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Devil upon Two Sticks

Dance: End: A Divertissement-Byrn, Mrs Goodwin

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Devil upon Two Sticks

Dance: As17881107

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Devil to Pay; or, The Wives Metamorphosed

Dance: As17881113

Song: As17881002

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Impostors

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Devil to Pay

Song: In afterpiece: a new Hunting Glee ['Tis health that gives birth] (1st time; composed by Callcott)-Kelly, Dignum, Sedgwick

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Devil to Pay

Dance: End I: The Russian Minuet, as17890519

Song: V: song-Miss Barnes

Entertainment: Monologue. End: A Picture of a Play@house or Bucks have at ye all-Palmer

Performances

Mainpiece Title: The Friends; Or, The Benevolent Planters

Afterpiece Title: The Prisoner at Large

Afterpiece Title: The Devil to Pay

Dance: In: a new dance, Liberty or We Slaves Rejoice-

Entertainment: Monologues End 2nd piece: As17890617 Preceding: An Address to the Humane Society on the Abolition of the Slave Trade in the character of a Negro , by-Kemble; End 3rd piece: Belles have at Ye All-Mrs Kemble

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Devil upon Two Sticks

Dance: The Deserter-[, See17891113

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Devil to Pay; or, The Wives Metamorphosed