SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Mayor of Garrett"/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 Lame Lover

Afterpiece Title: The Mayor of Garrett

Dance: As17700716

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garrett

Dance: The Shoemaker, as17710517

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garrett

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Mayor of Garrett

Dance: The Shoemaker-Master West, Miss West

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Mayor of Garrett

Song: II: Song (composed by Arne)-Phillips

Dance: As17710517

Performances

Mainpiece Title: London's Glory; Or, The Lord Mayor's Show

Performances

Mainpiece Title: London's Joy; Or, The Lord Mayor's Show

Performances

Mainpiece Title: The Lord Mayor's Show

Performances

Mainpiece Title: The Amorous Widow

Afterpiece Title: The Mayor of Queenborough

Song:

Dance:

Performances

Mainpiece Title: The True And Ancient History Of Sir Richard Whittington, Thrice Lord Mayor Of London, And The Diverting Humours Of Madge The Cook-maid And Her Sweetheart John The Butler

Song:

Dance:

Performances

Mainpiece Title: Wat Tyler And Jack Straw: Being The Representation Of That Celebrated And Heroick Action Of Sir William Walworth A lord Mayor Of London, Perform'd In The Reign Of king Richard The Second; Shewing How He Stab'd The Insolent Rebel, wat Tyler, At The Head Of His Rout, In smithfield, For Which Reason The Dagger, Which He So Loyally Employ'd, Was Added To The City's Arms, And Loyalty

Performances

Mainpiece Title: The True And Ancient History Of Whittington, Thrice Lord Mayor Of London

Dance: [Between the acts: Entertainments of Dancing-

Song: [Between the acts: Entertainments of Singing-; A good Band of Musick

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: II: Rogier, Miss Capitani; III: Double Hornpipe-Rogier, Miss Capitani

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: Rogier, Miss Capitani

Performances

Mainpiece Title: The Diversions Of The Morning

Afterpiece Title: The Mayor of Garratt

Dance: As17630704

Performances

Mainpiece Title: The Diversions Of The Morning

Afterpiece Title: The Mayor of Garratt

Dance: As17630704

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630704

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Dance: As17630620

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Dance: As17630704