SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "At Hay The Count Of Narbonne"/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 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 Commissary

Afterpiece Title: hay The Mayor of Garratt

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

Performances

Mainpiece Title: At Hay King John

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: At Hay King Lear

Afterpiece Title: The Cheats of Scapin