SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "THE ALCHYMIST"/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: Isabella

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Alchymist

Dance: As17821003

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Alchymist

Dance: As17821122

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: THE ALCHYMIST

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Alchymist

Dance: In Act I of mainpiece a Country Dance incident to the Piece (performers not listed); End of Act II, as17830918

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Alchymist

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Alchymist