SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Lord Mayors Show"/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: 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 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: Zara

Afterpiece Title: Lord Mayor's Day; or, A Flight from Lapland

Performances

Mainpiece Title: Which Is The Man

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: Lord Mayor's Day

Dance: End of Act II of mainpiece, as17821009

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Discovery

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Lord Mayor's Day

Song: As17821206

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Percy

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Lord Mayor's Day

Song: As17821118

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Lord Mayor's Day

Dance: As17821007

Song: As17821007

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: Lord Mayor's Day

Song: Vocal Parts [in Entry] by Mattocks, Reinhold, Brett, Doyle, Darley, Bannister; Mrs Kennedy, Mrs Martyr, Miss Stuart, Miss Morris, Miss Harper

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: Lord Mayor's Day

Song: In Act III song by Mrs Kennedy