SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Lord Mayor\'s 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: Speculation

Afterpiece Title: Lord Mayors Day

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Lord Mayors Day

Song: As17950921, but Vocal Parts-_

Performances

Mainpiece Title: Whittington a Puppet Show

Performances

Mainpiece Title: The Amorous Widow

Afterpiece Title: The Mayor of Queenborough

Song:

Dance:

Performances

Mainpiece Title: Hurlothrumbo Or News From Terra Australis Incognita With The Whimsical Flights Of My Lord Flame

Performances

Mainpiece Title: The Chesire Comicks Or The Amours Of Lord Flame

Performances

Mainpiece Title: All For Love

Afterpiece Title: Marfor1o being a Comi Tragical Farce called The Critick of Taste or A Tale of a Tub with Characters of Singlewit Drawcansir Modern Dapper Buskin Prompter the Great Mogul Dunceada Prince Prettyman Common Sense the Embryo of Common Sense Lord Haranguewell Falarini Signior Tweedledum Signior Tweedledee Prologues Senators Patriots Courtiers Fidlers Eunucks Gentleman Usher Ghosts and Chorus of Ghosts

Dance: Tambourine by Miss Rogers. Peasants by Lalauze, Mlle D'Hervigni, &c. Harlequine by Mlle De L'Isle

Performances

Mainpiece Title: Pasquin

Afterpiece Title: Fame or Queen Elizabeths Trumpets or Never pleads Hopes of being a Lord Chancellor or The Lover turnd Philosopher or The Misers Resolve upon the Lowering of Interest

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: The Honest Yorkshireman

Song: I: Dialogue (composed by Purcell)-the Masters Hamilton; III: A Song of Lord Flame's out of the Opera of All Alive and Merry-Master W. Hamilton

Dance: II: Tambourine-Mlle Roland; V: A new Serious Dance-Mlle Roland

Performances

Mainpiece Title: Esther

Song: I: Praise the Lord- accompanied by Parry

Music: II: Concerto (Arne) on Harpsichord-Miss Turner

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

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Dance: As17630704

Performances

Mainpiece Title: The Citizen

Afterpiece Title: The Mayor of Garratt

Dance: As17630704