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 Orators

Afterpiece Title: The Mayor of Garratt

Dance: Roger, Miss Capitani; Provincial Dance, as17630805; Venetian Gardeners, as17630805

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: VVenetian Gardeners, as17630811; Provincial Dance, as17630811

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: VVenetian Gardeners, as17630810; New Comic Dance-Master Clinton, Miss Street

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17630815

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17630815

Performances

Mainpiece Title: The Englishman Return'd From Paris

Afterpiece Title: The Mayor of Garratt

Dance: VVenetian Gardeners-Rogier, Miss Street; Provincial Dance-Master Clinton, Miss Twist

Performances

Mainpiece Title: The Citizen

Afterpiece Title: The Mayor of Garratt

Dance: I: Venetian Gardeners, as17630822; III: New Comic Dance-Master Clinton, Miss Street

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630824

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17630824

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17630824

Performances

Mainpiece Title: The Citizen

Afterpiece Title: The Mayor of Garratt

Dance: As17630824

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630824

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: Rogier, Master Clinton, Miss Street

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Mayor of Garratt

Dance: IV: The Provancalle, as17631014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Mayor of Garratt

Dance: TThe Italian Gardiners, as17631119

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: The Mayor of Garratt

Dance: TThe Italian Gardiners, as17631119

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Mayor of Garratt

Dance: III: The Provancalle, as17631014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: Sicilian Peasants-Master Rogier, Miss Valois; End: A new comic Dance, The Carpenter and the Fruit Dealer-Gherardi Jr, Master Clinton, Miss Street

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640626, but order reversed%

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: Sicilian Peasants, as17640626 End: The Venetian Gardeners-Master Clinton, Miss Street

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640629, but order reversed%