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 Capricious Lady

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: King Lear

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Lord Mayor's Day

Dance: End of mainpiece The Fingalian; or, The Female Frolic by Miss Besford and others

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: Lord Mayor's Day; or, A Flight from Lapland in an Air Balloon

Song: In Act III of mainpiece a song by Mrs Kennedy

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: The Mysterious Husband

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Robin Hood

Afterpiece Title: Lord Mayor's Day; or, A Flight from Lapland in an Air Balloon

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Marcella

Afterpiece Title: The Citizen

Dance: End afterpiece: A Grand Ballet of Action, as performed at the King's Opera House in the Hay-market [most recently in season of 1787-88] The Deserter[. Principal Characters-Cranfield, Delpini, Boyce, Byrne, Mrs Davenett, the two Miss Simonets (1st appearance [at this theatre])

Performances

Mainpiece Title: Poor Old Hay-market; Or, Two Sides Of The Gutter

Afterpiece Title: The Young Quaker

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Battle of Hexham; or, Days of Old

Afterpiece Title: Seeing is Believing

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Battle of Hexham

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Suicide

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Battle of Hexham

Afterpiece Title: Poor Old Hay-Market

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Surrender of Calais

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: Poor Old Hay-Market

Performances

Mainpiece Title: Poor Old Hay-market

Afterpiece Title: The Suicide

Afterpiece Title: All in Good Humour

Performances

Mainpiece Title: At Hay Jane Shore

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: At Hay The Gamester

Afterpiece Title: The Divorce

Performances

Mainpiece Title: At Hay The Grecian Daughter

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: At Hay The Mourning Bride

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: At Hay Mary Queen Of Scots

Afterpiece Title: No Song No Supper