SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Craftsman"/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 Metamorphosis; Or, The Old Lover Outwitted

Afterpiece Title: The Craftsman; or, The Weekly Journalist

Dance: Cleveland, Turner, Mrs Anderson, Mrs Turner

Performances

Mainpiece Title: The Metamorphosis

Afterpiece Title: The Craftsman

Dance: As17281015

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Afterpiece Title: The Craftsman

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Afterpiece Title: The Craftsman

Dance:

Performances

Mainpiece Title: The Quaker's Opera: With The Escapes Of Jack Shephard

Afterpiece Title: The Craftsman

Performances

Mainpiece Title: The Quaker's Opera

Afterpiece Title: The Craftsman

Dance: TThe Swedish Pellarke-

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: The Craftsman

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: The Craftsman