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 Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: A new Tambourine Dance-Rogier, Miss Valois; End: The Venetian Gardeners, as17640629

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17640705, but order reversed%

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: The Dutchman and Provincials-Gherardi, Master Clinton, Miss Street; End: Tambourine Dance, as17640705

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17640710, but order reversed%

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640710

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640710 but order reversed

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: I: As17640727 End: A new comic Dance called The Shepherdess and the Faux Aveugle-Gherardi jun, Master Clinton, Miss Street

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17640730 but order reversed

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: The Shepherdess and the Faux Aveugle, as17640801; End: The Calabrian Peasants-Rogier, Miss Valois

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17640806

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17640815, but order reversed

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17640824, but order reversed

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: I: The Carpenter and Fruit Dealer, as17640727 End: Comic Dance-Rogier, Miss Valois

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: I: The Shepherdess and the Faux Aveugle, as17640730 End: Comic Dance-Rogier, Miss Valois

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17640905

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17650708

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: I: Le Chasseur, as17650708 La Berge, as17650708 End: The Dutchman-Master Clinton, Miss Street

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17650719

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: I: The Dutchman; End: The English Sailor at Marseilles-Miss Street; the New Hornpipe-Master Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650809

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650708

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: I: The Carpenter, as17650708 End: The Dutchman, as17650719

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650821

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17650719