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 Commissary

Afterpiece Title: The Mayor of Garratt

Dance: As17680913

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Mayor of Garratt

Dance: As17690515

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: TThe Cowkeeper, as17700521

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: TThe Cowkeeper, as17700521

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Dance: End: The Nosegay-Master and Miss West

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Mayor of Garratt

Dance: V: Comic Dance, as17700922

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Mayor of Garratt

Dance: III: Comic Dance, as17701025

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Mayor of Garratt

Dance: II: Comic Dance, as17710416

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: End: As17710515

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Dance: III: A Comic Dance, as17710921

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Mayor of Garratt

Dance: II: The Sailors Revels-Atkins

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: The Mayor of Garratt

Dance: End: The Amusements of Strasburgh, as17720111

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Dance: V: Comic Dance, as17720326

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Mayor of Garratt

Dance: I: The European in America (for 1st time this Season)-Messieurs Daigvilles, Miss Ross, Sga Vidini; II: A Comic Dance, as17720326 V: Psiche, a Grand Historical Ballet (Never performed before)-Daigville, Giorgi, Sga Daigville, Miss Ross, Sga Vidini

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Mayor of Garratt

Entertainment: IV: Scrub's Trip to the Jubilee, as17720427 (for that Night only) a Variety of Imitations-Bannister

Dance: End: The Sailors Revels, as17711008