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: Oroonoko

Afterpiece Title: The Fairy Tale

Dance: IV: New Tambourine, as17640929

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Fairy Tale

Dance: III: The Lamplighters, as17641029

Performances

Mainpiece Title: The Platonic Wife

Afterpiece Title: The Fairy Tale

Dance: III: The Millers, as17650118; End: New Tambourine, as17640929

Performances

Mainpiece Title: The Platonic Wife

Afterpiece Title: The Fairy Tale

Dance: II: A Comic Dance, as17641213; IV: New Tambourine, as17640929

Performances

Mainpiece Title: The Platonic Wife

Afterpiece Title: The Fairy Tale

Dance: II: A Comic Dance, as17641213; IV: New Tambourine, as17640929

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: The Fairy Tale

Dance: I: A New Dance call'd The Irish Milkmaids-Miss Ford; End: The Medley, as17641120

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Fairy Tale

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: The Foundling

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: Almena

Afterpiece Title: A Fairy Tale

Dance: I: Comic Dance, as17660207; III: Hearts of Oak, as17660207

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: A Fairy Tale

Dance: End: The Irish Lilt, as17651004

Performances

Mainpiece Title: Falstaff's Wedding

Afterpiece Title: A Fairy Tale

Dance: II: A Dance called Hearts of Oak-Aldridge, Miss Baker

Performances

Mainpiece Title: The Tempest

Afterpiece Title: A Fairy Tale

Dance: End: Hearts of Oak, as17660207

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: A Fairy Tale

Dance: End: Comic Dance, as17660207

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: A Fairy Tale

Dance: End: Hearts of Oak, as17670212

Performances

Mainpiece Title: The Sheep-shearing

Afterpiece Title: The Fairy Tale

Dance: With aPastoral Dance (incident to the [main]piece)-; End: As17770707

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Polly

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Fairy Tale

Dance: As17770618

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: The Fairy Tale

Dance: End: Dance-