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 Runaway

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Judas Maccabaeus

Music: First Violin-Lamotte; after I: Concerto on German Flute-Florio; Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Runaway

Dance: The Dance of The Savage Hunters, as17760210(playbill); the Public Advertiser lists The Grand Garland Dance-Slingsby, Como, Sga Crespi, Sga Paccini

Afterpiece Title: The Sultan

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Syrens

Performances

Mainpiece Title: The Runaway

Dance: the Dance call'd The Jealous Harlequin, as17760117

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: Medea

Afterpiece Title: The Deserter

Dance: End: The Grand Garland Dance-, as17760302 but Sga _Pacini

Performances

Mainpiece Title: Cyrus

Afterpiece Title: A Peep behind the Curtain

Entertainment: End: (for the last time) Comic Paraphrase on Shakespeare's Seven Ages-King

Dance: End Entertainment: The Irish Fair, as17751003

Performances

Mainpiece Title: Concerto Spirituale

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Afterpiece Title: The Man of Quality

Dance: End: The Grand Garland Dance, as17760311

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Messiah

Music: First Violin, Concerto-Linley Jr

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Spleen

Dance: V: The Irish Fair, as17751003

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Spleen

Dance: In: The Savage Hunters, as17751118

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Bon Ton

Dance: In: The Savage Hunters, as17751118

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Man of Quality

Dance: II: The Jealous Harlequin, as17760117

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Waterman

Dance: V: The Irish Fair, as17751003

Performances

Mainpiece Title: Il Bacio

Dance: I: La Fete du Village, as17760224; II: New Serious Ballet, with Chaconne and Minuet de la Cour-Vallouy, Mme Vallouy; End Opera: New Grand Comic Ballet, Les Maissoneurs Distresse-Helm, Mlle Sophie, Sga Tinti, Vallouy, Mrs Vallouy

Performances

Mainpiece Title: The School For Rakes

Afterpiece Title: The Waterman

Dance: End: The Savage Hunters, as17751118

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: The Rival Candidates

Dance: III: The Sailors Revels, as17751220

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Irish Widow

Dance: V: A Comic Dance, as17760415

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Bon Ton

Dance: End Opera: a Favourite Dance call'd The Gardeners, as17760116

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Midas

Dance: I: Rural Merriment, as17751220

Song: IV: At the Request of many Friends, Kate of Aberdeen-DuBellamy

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: The Rival Candidates

Dance: V: The Sailors Revels, as17751220