SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Johnson"/1) | (@(roleclean,performerclean) "Mr Johnson")') 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 4553 matches on Event Comments, 2378 matches on Performance Comments, 533 matches on Performance Title, 300 matches on Author, and 7 matches on Roles/Actors.

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Old Batchelor

Song: III: Song-Lowe

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Honest Yorkshireman

Dance: II: A Comic Dance-two Masters Granier, Miss Granier; III: The Welch Buffon-two Masters Granier; V: A Comic Ballet-Carney, Mlle Roland, Lapierre, Pelling, Granier, Mrs Saintquient, Mrs Vallois, Miss Story

Performances

Mainpiece Title: Oroonoko

Dance: II: Les Moisoneurs de la Styrie, as17421201; IV: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: Richard Iii

Song: II: Beard; IV: Lowe

Music: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Lying Valet

Song: IV: Beard

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Italian Gardeners, as17421231; III: a New Serious Dance-Sga Aquilanti; V: A New Sicilian Peasant-Checo, Chiaretta

Performances

Mainpiece Title: The Fair Penitent

Dance: DDutch Skipper, as17421025; Characters of Dancing, as17421025; Grand Ballet, as17421108

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Afterpiece Title: The Lying Valet

Dance: I: a Serious Dance-Mlle Roland; III: Sailor's Dance-Delamayne, Mlle Roland; V: (by Desire) a Minuet, Louvre-Delamayne, Mlle Roland. [Dances not in Daily Advertiser.

Performances

Mainpiece Title: Sir Courtly Nice; Or, It Cannot Be

Afterpiece Title: Bickerstaff's Unburied Dead

Song: Mrs Dunstall

Performances

Mainpiece Title: Amelia

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Lying Valet

Song: End of Farce:By Particular Desire, Bumper Squire Jones-Beard

Performances

Mainpiece Title: The Siege Of Damascus

Afterpiece Title: Perseus and Andromeda

Dance: TTambourine-Cooke; Characters of Dancing, as17421025; La Provencale, as17421105

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Scotch Dance-Delamain, Anne Auretti; II: Tambourine-Anne Auretti; III: Characters of Dancing, as17421025; IV: Un Pas de Deux-Anne and Janneton Auretti; V: L'Aimable Vainqueur, Minuet-Picq, Anne Auretti

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Lying Valet

Music: II: Concerto on German Flute-Burk Thumoth

Song: IV: Stella and Flavia-Beard

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Lying Valet

Song: As17430413

Music: As17430416

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Toyshop

Dance: I: Dutch Skipper, as17421025; III: Peasants, as17421230; V: Le Rendezvous Gallant, as17421217

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Lying Valet

Dance: I: A French Peasant-Froment, Mlle Gondeau; III: A New Serious Dance-Desse, Mrs Walter; V: La Florana, as17430408

Song: II: Stella and Flavia-Beard; IV: Bumper Squire Jones-Beard, Lowe

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Song: III: Song-Lowe

Dance: II: Tyrolean Dance, as17421129; IV: Sicilian Peasant, as17430310

Performances

Mainpiece Title: Cato

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Cato

Dance: II, V: As17431003

Performances

Mainpiece Title: Roxana; Or, Alexander In India

Performances

Mainpiece Title: Roxana