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 Lame Lover

Afterpiece Title: The Mayor of Garrett

Dance: As17700716

Performances

Mainpiece Title: The Orphan

Afterpiece Title: hay The Wrangling Lovers

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: King John

Afterpiece Title: hay Miss in Her Teens

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: hay The Citizen

Dance: hay End of Play: The Cowkeeper, as17700521

Song: hay II: A favorite song from The Captive; III: An Italian Song-Mrs Jewell

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: hay The Vintner Trick'd

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: hay The Author

Dance: hay IV: The Nosegay, as17700611

Song: hay IV: By Mrs Jewell

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: hay Taste

Dance: hay End of Play: The Nosegay, as17700611

Song: hay As17700824

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Nosegay, as17700611

Performances

Mainpiece Title: King Lear

Afterpiece Title: hay Damon and Phillida

Dance: hay End of Play: The Nosegay, as17700611

Performances

Mainpiece Title: The Lame Lover

Afterpiece Title: hay The Author

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: hay Taste

Dance: hay The Cowkeeper, as17700521

Song: hay As17700824

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: hay The Vintner Tricked

Music: hay End of Opera: A Favourite Concerto on Harpsichord by Hook

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: The Messiah

Music: First Violin, Concerto-Hay; Organ-Stanley

Performances

Mainpiece Title: The East Indian

Afterpiece Title: None are so Blind as Those HAY Who Won't See

Dance: As17820613

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