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 Beggar's Opera

Song: TThe Ladies' Lamentation, as17370414

Dance: JJe ne scai quoi-Tench, Villeneuve, Miss Oates

Performances

Mainpiece Title: Three Hours After Marriage

Afterpiece Title: The Mock Doctor

Dance: Tench, Villeneuve, Miss Oates

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Othello, Moor Of Venice

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Fall of Phaeton; With Harlequin a Captive

Dance: A Ballet-Haughton (his first appearance at dl in five years)

Performances

Mainpiece Title: The Beggar's Opera

Dance: Lilliputians , Scholars of Livier

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Harlot's Progress

Dance: As17371025

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Harlot's Progress

Dance: Two Misses Scott; who never appeared on that Stage before: I: A Saraband, Minuet-Miss Scott; II: Comic Dance-Miss Scott's Sister; IV: Serious Dance-the two Misses Scott

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fall of Phaeton

Dance: As17371018

Performances

Mainpiece Title: Faramondo

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Burgomaster Trick'd

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Burgomaster Trick'd

Dance: Denoyer, Haughton, Miss Thompson

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: The Fall of Phaeton

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: The Fall of Phaeton

Performances

Mainpiece Title: The Northern Lass

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: The Devil to Pay

Dance: III: Flanderkins-Master Ferg, Miss Wright; V: Ballet-Muilment, Mrs Walter, Livier, Miss Thompson, Pelling

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: Flanderkins, as17380120 III: Russian Sailor=-Denoyer; V: Ballet, as17380120

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Dragon of Wantley

Dance: Mlle Roland; Je ne scai quoi-Tench, Villeneuve, Miss Oates

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Grand Volgi

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Harlequin Grand Volgi

Dance: I: Flanderkins, as17380120 II: Grand Polish Dance, as17380128 III: Drunken Peasant-Philips; IV: Ballet-Denoyer, Haughton, Miss Thompson