SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Fairy Tale"/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 Jealous Wife

Afterpiece Title: The Fairy Tale

Dance: TThe Italian Gardiners, as17631119

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Fairy Tale

Dance: The Irish Lilt, as17630922

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: King Henry Iv, Part Ii

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Philaster

Afterpiece Title: The Fairy Tale

Dance: II: The Provancalle, as17631014

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Orphan Of China

Afterpiece Title: The Fairy Tale

Dance: The Irish Lilt, as17630922

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Fairy Tale

Dance: The Irish Lilt, as17630922

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Fairy Tale

Dance: End: The Cow@Keepers, as17640504

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: The Fairy Tale

Dance: II: By Desire, a Hornpipe-Miss Watkins; IV: The Provancalle, as17631014

Entertainment: End: A New Panegyri@Satiri@Serio@Comic Epilogue upon Epilogues-Tomlinson

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: The Fairy Tale

Dance: II: A Double Hornpipe-Mas. Cape, Miss Rogers; III: The Gypsies-Mas. Clinton, Miss Street (Gerhardi's Scholars); V: A Minuet-the two Miss Rogers's (Mr Noverre's Scholars); End: A Dance call'd The Carpenters and the Fruit Dealers-Miss Street, Mas. Gherardy, first appearance on English Stage

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Fairy Tale

Dance: II: Irish Lilt-Aldrige, Miss Baker

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Fairy Tale

Dance: II: The Irish Lilt-Aldridge, Miss Baker; III: The Provencalle, as17640918; V: New Tambourine, as17640929

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: King Henry Iv, Part I

Afterpiece Title: The Fairy Tale

Dance: II: New Tambourine, as17640929