SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Device"/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: Alexander The Great

Afterpiece Title: The Device; or, The Marriage-Office

Dance: End: The Humours of New@Market with the Pony Races, as17770428

Song: End I: A Welcome to the Spring (composed by Dr Arne)-Mrs Farrell

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Device; or, The Deaf Doctor

Dance: End III: The Dockyard, as17790924

Song: II: The Cottage on the lawn (set by Michael Arne)-Mrs Kennedy

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Device

Dance: End: The Dockyard, as17790924