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: Cymon

Afterpiece Title: The Mayor of Garratt

Entertainment: V: Scrub's Trip, as17720427

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17720518

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Mayor of Garratt

Dance: As17720518

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Mayor of Garratt

Dance: As17720817

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: The Haymakers-Giorgi's scholars

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: I: Wooden Shoe Dance-; End: The Haymakers, as17730526

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: I: The Haymakers, as17730526; End: The Medley, as17730517

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: I: Double Hornpipe-; End: A New Tambourine Dance-Giorgi's scholars

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Mayor of Garratt

Dance: As17730526

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Mayor of Garratt

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Mayor of Garratt

Song: (By Particular Desire) O! What a Charming Thing's a Battle!-Mr Bannister

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Mayor of Garratt

Dance: As17740603

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: I: As17740613 End: Minuet, Allemande-Master and Miss Burn

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: The Mayor of Garratt

Dance: As17740613

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Matilda

Afterpiece Title: The Mayor of Garratt

Dance: V: The Irish Fair, as17740917