SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Creusa"/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: Creusa, Queen Of Athens

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Performances

Mainpiece Title: Creusa

Afterpiece Title: Lethe

Performances

Mainpiece Title: Creusa

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Creusa

Afterpiece Title: The Devil to Pay

Dance: I: As17550203; V: The Last New Comic Dance-Sg and Sga Sabatini

Song: III: Rule Britannia, as17550402-Beard%; concluding with: Hornpipe-Mathews

Performances

Mainpiece Title: Creusa

Afterpiece Title: The Tamer Tam'd

Song: Beard

Performances

Mainpiece Title: Creusa

Afterpiece Title: Mercury Harlequin

Performances

Mainpiece Title: Creusa

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Creusa

Afterpiece Title: The Author

Dance: II: The Italian Peasants, as17571004

Performances

Mainpiece Title: Creusa

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Creusa

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Creusa In Delfo

Dance: End of Act I La Begucule, as17830320End of Act II Le Tuteur Trompe, as17830426

Performances

Mainpiece Title: Creusa In Delfo

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II Le Tuteur Trompe, as17830426, but omitted: Slingsby