SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "hay The Citizen"/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 Stranger

Afterpiece Title: The Citizen

Music: Vocal Parts-Mrs Bland, Miss Leak; their songs: To welcome mirth and harmless glee-Mrs Bland, Miss Leak; I have a silent sorrow here-Mrs Bland

Dance: Principal Dancer-Sga Bossi DelCaro

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Egyptian Festival

Afterpiece Title: The Citizen

Performances

Mainpiece Title: De Montfort

Afterpiece Title: The Citizen

Song: As18000430

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Fortunatus

Dance: II: A Dance call'd The Irish Hay@makers-Giorgi, Mrs King

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: High Life below Stairs

Dance: End: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: King Lear

Afterpiece Title: High Life below Stairs

Dance: End: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: As You Like It

Afterpiece Title: A Peep behind the Curtain

Dance: I: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Devil to Pay

Dance: IV: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: A Peep behind the Curtain

Dance: V: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The National Prejudice

Dance: Act I afterpiece: a French Dance call'd The Cotillion-Giorgi, Duquesney, Tassoni, Rolley, Mrs King, Sga Giorgi, Miss Tetley, Mrs Grimaldi; V: The Irish Hay@makers, as17670919