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: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Dance: As17650828

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650719 but New Hornpipe-Mas. Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650909

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650909

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Entertainment: Dancing-

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17660715

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17660715

Performances

Mainpiece Title: Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17660715

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Entertainment: Dancing-

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17660715

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17660715

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: II: New Tambourine Dance-; End: Hornpipe-Froment

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: FFingalian-; Italian Peasant, as17670729

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: Miss Froment

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Mayor of Garratt

Dance: SSerious Dance-; The Gallant Peasant, as17670904

Entertainment: By Desire, Occasional Prologue on opening the Theatre-Mr Foote; in which will be introduced Through the Wood Laddie-the real Blackamoor Lady (Neville)

Performances

Mainpiece Title: The Countess Of Salisbury

Afterpiece Title: The Mayor of Garratt

Dance: End: Serious Dance-; End I Farce: Hornpipe-Miss Froment

Performances

Mainpiece Title: The Messiah

Music: Instrumental parts-Hay, the most capital performers; with a solo on the violin-Hay

Performances

Mainpiece Title: The Mayor Of Garratt

Afterpiece Title: The Stratagem

Dance: As17680530

Music: CConcerto on Violin-Barthelemon

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Mayor of Garratt

Dance: As17680801

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Mayor of Garratt

Dance: DDouble Hornpipe, as17680801