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

Afterpiece Title: COMUS

Song: As17931029

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARTFORD BRIDGE

Dance: As17930916

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: THE HIGHLAND REEL

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: THE IRISHMAN IN LONDON

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: NETLEY ABBEY

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: NETLEY ABBEY

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: British Fortitude And Hibernian Friendship

Afterpiece Title: FONTAINVILLE FOREST

Afterpiece Title: NETLEY ABBEY

Performances

Mainpiece Title: British Fortitude And Hibernian Friendship

Afterpiece Title: FONTAINVILLE FOREST

Afterpiece Title: NETLEY ABBEY

Performances

Mainpiece Title: Annette And Lubin

Afterpiece Title: FONTAINVILLE FOREST

Afterpiece Title: THE SICILIAN ROMANCE

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: A LOYAL EFFUSION

Afterpiece Title: THE SICILIAN ROMANCE

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: Harlequin and Faustus

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: Hercules and Omphale

Performances

Mainpiece Title: Cross Purposes

Afterpiece Title: Fontainville Forest

Afterpiece Title: Merry Sherwood