SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "hay The Mayor of Garratt"/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: Tit For Tat

Afterpiece Title: The Son-in-Law

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Jew

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Mountaineers

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Prize; or, 2

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Flitch Of Bacon

Afterpiece Title: The Recruiting Officer

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: A Bold Stroke for a Wife

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Peeping Tom

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: Love And Money

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Love And Money

Afterpiece Title: The Three and the Deuce

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Love And Money

Afterpiece Title: The Three and the Deuce

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Love And Money

Afterpiece Title: The Three and the Deuce

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Love And Money

Afterpiece Title: The Three and the Deuce

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Love And Money

Afterpiece Title: Three and the Deuce

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Speculation

Afterpiece Title: Lord Mayor's Day; or, A Flight from Lapland

Dance: I afterpiece: The Long Minuet- taken from the Caricature Print of that title [The Long Minuet as Danced at Bath, by H. W. Bunbury; see17951116]

Performances

Mainpiece Title: Speculation

Afterpiece Title: Lord Mayor's Day

Dance: As17951109

Performances

Mainpiece Title: Speculation

Afterpiece Title: Lord Mayor's Day

Dance: As17951109

Performances

Mainpiece Title: Speculation

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Lord Mayor's Day

Song: As17950921, but Vocal Parts-_

Performances

Mainpiece Title: The Smugglers

Afterpiece Title: A Favourite Scene from New Hay [Sylvester Daggerwood]

Afterpiece Title: The Critic

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Fortunatus

Dance: II: A Dance call'd The Irish Hay@makers-Giorgi, Mrs King

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: High Life below Stairs

Dance: End: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: King Lear

Afterpiece Title: High Life below Stairs

Dance: End: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: As You Like It

Afterpiece Title: A Peep behind the Curtain

Dance: I: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Devil to Pay

Dance: IV: The Irish Hay@makers, as17670919