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

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: Romeo And Juliet

Afterpiece Title: The Fair

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: Much Ado About Nothing

Afterpiece Title: Lethe

Dance: End: Venetian Gardeners-Grandchamps, Mlle Auretti

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: Phebe

Dance: I: New Dance-Cooke, Miss Hillyard; II: Dutch Dance, as17500319 but -Cooke, Miss Hillyard; III: Grand Scotch Ballet, as17500201; End of Play: Louvre, Minuet-Cooke, Miss Hillyard

Performances

Mainpiece Title: All For Love; Or, The World Well Lost

Afterpiece Title: The Intriguing Chambermaid

Song: III: Miss Norris

Dance: VVenetian Gardeners-Grandchamps, Mlle Auretti

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Miss in Her Teens

Dance: As17500201