SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Handel"/1) | (@(roleclean,performerclean) "Mr Handel")') 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 4410 matches on Event Comments, 1294 matches on Performance Comments, 695 matches on Performance Title, 18 matches on Author, and 6 matches on Roles/Actors.

Performances

Mainpiece Title: Edward The Black Prince

Performances

Mainpiece Title: Edward The Black Prince

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Edward The Black Prince

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Comus

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Merope

Ballet: SSavoyard Travellers. As17491110, but Principal Savoyards-Mrs _Addison

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Merope

Ballet: SSavoyard Travellers. As17500126

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The Tempest

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Don Saverio

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: A Duke and no Duke

Dance: AAcis and Galatea, as17491130, but MacNeale, Pelling, Shawford, Mlle Mariet, Mlle Memi omitted

Performances

Mainpiece Title: Merope

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Miller of Mansfield

Dance: III: Comic Dance, as17500221; IV: Swedish Gardeners, as17491219

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: [The Lying Valet]The Devil to Pay

Dance: AAcis and Galatea, as17500219

Performances

Mainpiece Title: The Roman Father

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Rehearsal; or, Bayes in Petticoats

Dance: Grandchamps, Mlle Auretti

Performances

Mainpiece Title: The Foundling

Afterpiece Title: Miss in Her Teens

Dance: CComic Dance, as17500221; L'Entree de Flore-Mlle Auretti

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Lethe

Dance: End: Venetian Gardeners-Grandchamps, Mlle Auretti