The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "THE MAYOR OF GARRATT"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

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

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