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

Performances

Mainpiece Title: The Miser

Afterpiece Title: Pyramus and Thisbe

Performances

Mainpiece Title: Tancred And Sigismunda

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Damon and Phillida

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Afterpiece Title: Phebe; or, The Beggar's Wedding

Performances

Mainpiece Title: Coriolanus

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: None

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: Samson

Afterpiece Title: Concerto

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Henry and Emma; or, The Nut Brown Maid

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Anatomist

Dance: In I: a Dutch Dance, as17481203; Savoyards, as17480920

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Lethe and Jumpedo

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The Rehearsal

Dance: As17491220

Song: III: Master Mattocks

Performances

Mainpiece Title: None

Performances

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

Afterpiece Title: Lethe

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: The Orphan

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Mock Doctor

Dance: II: Comic Dance, as17501117

Ballet: V: The Birdcatchers. As17501127

Performances

Mainpiece Title: None

Performances

Mainpiece Title: None

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Joshua