SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Hayley"/1) | (@(roleclean,performerclean) "Mr Hayley")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 4229 matches on Event Comments, 1139 matches on Performance Comments, 528 matches on Performance Title, 48 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Musical Lady

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Mayor of Garratt

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Meeting of the Company

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The West Indian

Afterpiece Title: Harlequin's Jacket

Dance: II: Grand Provencalle Dance, as17750202

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Zara

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: May Day

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Roman Father (with Alterations)

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: La Cosa Rara

Dance: End I: New Divertissement, as17890110, but _Didelot; End Opera: Les Fetes Provencales, as17890207, but _Didelot, Mlle _Normand

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Song: Mainpiece: Vocal Parts-Incledon, Johnstone, Townsend, Hill, Linton, Blurton, Street, Gray, Little, Lee, Sawyer, Tett, Dyke, Mrs Chapman, Miss Mitchell, Miss Wheatley, Mrs Iliff, Miss Sims, Mrs Whitmore, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Mrs Martyr

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Lying Valet

Ballet: The Scotch Ghost. As17990628

Song: As17990628

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Afterpiece Title: Hunt the Slipper

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Afterpiece Title: Hunt the Slipper

Dance: As17840713

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Performances

Mainpiece Title: The Two Connoisseurs

Related Works
Related Work: The Two Connoisseurs Author(s): William Hayley

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Lord Russel

Related Works
Related Work: Lord Russel Author(s): William Hayley

Afterpiece Title: Peeping Tom