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: The Platonic Wife

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Witches

Dance: III: The Medley, as17641120

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Rosamond

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: Ezio

Dance: Between the acts:

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Witches

Dance: II: Double Hornpipe-Walker, Miss Tetley

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Dance: As17650828

Performances

Mainpiece Title: The London Merchant; Or, The History Of George Barnwell

Afterpiece Title: The Witches

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Double Mistake

Dance: III: The Village Romps, as17651019

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Hermit

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Hermit

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Lethe

Performances

Mainpiece Title: A Variety Show

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Apprentice

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Citizen

Dance: II: Rural Love, as17661120

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman in Paris

Dance: II: The Village Romps, as17661008

Entertainment: OOccasional Prologue-Ross; The London Cries-Shuter

Performances

Mainpiece Title: The Accomplish'd Maid

Dance: As17661215The Peasants-_

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Cymon

Performances

Mainpiece Title: The Accomplish'd Maid

Afterpiece Title: The Apprentice

Dance: TThe Happy Villagers-; The Female Archer, as17670109

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Cymon