SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "At Hay The Grecian Daughter"/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 Deserted Daughter

Afterpiece Title: Hercules and Omphale

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Rosina

Afterpiece Title: The Tythe Pig

Performances

Mainpiece Title: The Mayor Of Garratt

Afterpiece Title: New Hay at the Old Market

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

Performances

Mainpiece Title: The Agreeable Surprise

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The London Hermit; Or, Rambles In Dorsetshire

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: Ways And Means

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: New Hay at the Old Market

Song: 2nd piece: Vocal Parts-Cooke, Lyons, Aylmer, Boyce, Brown, Dibble, Dorion, Kenrick, Linton, Little, Walker, Miss Leak, Miss DeCamp, Mrs Gaudry, Mrs Hale, Mrs Butler, Mrs Norton, Miss Menage, Miss Granger

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: The Poor Sailor

Afterpiece Title: The Tythe Pig

Dance: As17950609

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: Peeping Tom

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: The Dead Alive

Afterpiece Title: Ways and Means

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: The London Hermit

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: New Hay at the Old Market

Song: As17950613

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: The Prisoner At Large

Afterpiece Title: Peeping Tom

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: My Grandmother

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: The London Hermit

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: A Bold Stroke for a Wife

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Zorinski

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: The Jew

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: The Son-in-Law

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Jew

Afterpiece Title: New Hay at the Old Market