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 Queen Of Spain

Afterpiece Title: The Kiss Accepted and Returned

Performances

Mainpiece Title: Julius Caesar

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Life Of King Henry The Fifth

Afterpiece Title: Damon and Phillida

Dance: As17440404

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin Hermit

Performances

Mainpiece Title: The Recruiting Officer

Music: Between the Acts: Select Pieces of Musick-

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: Deborah

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Anatomist

Song: Lowe

Dance: Muilment

Performances

Mainpiece Title: The Rehearsal

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: Rosamond

Performances

Mainpiece Title: The Double Gallant; Or, The Sick Lady's Cure

Afterpiece Title: The Picture; or, Cuckold in Conceit

Dance: IV: Peasant's Dance-Muilment

Performances

Mainpiece Title: Alfred The Great

Music: I: a Concerto new by Arne on the Violin-Gordon; II: a Concerto on the Organ-Burgess

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Lying Valet

Dance: II: New Grand Dance-Muilment; III: New Dance-Muilment; V: Muilment

Song: IV: Gentle Shepherd-Mrs Arne

Performances

Mainpiece Title: The Nonjuror

Afterpiece Title: The Debauchees

Dance: V: Grand Comic Dance, as17450926

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Debauchees

Song: II: The Subscription-Lowe

Dance: III: Dance-the Mechels

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Virgin Unmasked

Song: II: Britons Strike Home-Lowe

Dance: V: Mechel, Mlle Mechel

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Lottery

Dance: VIII: Grand Comic Dance, as17450926

Song: V: The Subscription-Lowe

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Lottery

Song: III: Lowe

Dance: V: Mechels, Mlle Mechel

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Flora

Song: Brett

Dance: As17451028

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Flora

Song: Brett

Dance: As17460101

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Stage Coach

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Devil to Pay

Song: II: Lowe; III: Duet My Faith and Truth, as17460104 IV: Miss Edwards

Dance: V: Muilment