SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Devil of a Duke"/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 Jew

Afterpiece Title: My Grandmother

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: Ways and Means

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: False And True

Afterpiece Title: Blue Devils

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: False And True

Afterpiece Title: Blue Devils

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: False and True

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: The Birth Day

Afterpiece Title: The Devil to Pay

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: The Egyptian Festival

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: De Montfort

Afterpiece Title: The Devil to Pay

Song: Vocal Parts, as18000429, but Mrs Coates

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Jew

Afterpiece Title: The Castle of Sorrento

Song: 3rd piece: Chorus-Kenrick, Little, Willoughby, Dibble, Aylmer

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: Obi; or, Three-Finger'd Jack

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Point of Honour

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Point of Honour

Afterpiece Title: The Castle of Sorrento

Song: As18000614

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: The Birth Day

Afterpiece Title: The Review