SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "J Clegg"/1) | (@(roleclean,performerclean) "J Clegg")') 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 879 matches on Performance Comments, 450 matches on Event Comments, 100 matches on Performance Title, 12 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Mayor of Garratt

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: Othello

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Devil to Pay

Dance: IV: The Mountaineers, as17730930

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Genii

Dance: I: The Sailors Revels, as17730928

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The King and Miller of Mansfield

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: Sethona

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Citizen

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Irish Widow

Dance: V: The Mountaineers, as17730930; End I Farce: The Irish Fair, as17730918

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Register Office

Dance: The Sailors Revels, as17730928

Monologue: End: Linco's Travels. Linco-King; Old Woman-Mrs Bradshaw

Performances

Mainpiece Title: As You Like It

Afterpiece Title: A Peep behind the Curtain

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: The Brothers

Afterpiece Title: The School Boy

Entertainment: Bucks Have at ye All-Dodd

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Deserter

Dance: III: The Mountaineers, as17730930

Performances

Mainpiece Title: The Committee

Afterpiece Title: Edgar and Emmeline

Dance: V: The Irish Fair, as17730918

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Wedding Ring

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: Phaedra And Hippolitus

Afterpiece Title: The Irish Widow

Entertainment: II: (By Particular Desire) Hippsley's Drunken Man-Weston; IV: An Ode on Masonry-Vernon, Dodd, Bannister; End: (1st and only time this season) Imitations with several new characters-Bannister

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: All For Love

Afterpiece Title: The Pigmy Revels

Dance: IV: A Pantomime Dance call'd The Taylors-Grimaldi, Atkins, Mrs Sutton; V: A Hornpipe-a Scholar of Grimaldi