SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sparkling"/1) | (@(roleclean,performerclean) "Sparkling")') 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 128 matches on Roles/Actors, 48 matches on Performance Comments, 3 matches on Event Comments, 0 matches on Performance Title, and 0 matches on Author.

Performances

Mainpiece Title: The Miser

Afterpiece Title: Flora

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Rites of Hecate

Dance: III: The Italian Gardiners, as17631119

Performances

Mainpiece Title: The Miser

Afterpiece Title: Love in a Camp

Dance: As17870131

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Dumb Cake

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Miser

Dance: As17881107

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Miser

Dance: As17890101

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: As It Should Be

Dance: End II: As17890525; End I: Statute Dance-the Characters

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: A Mogul Tale; or, The Descent of the Balloon

Afterpiece Title: Ut Pictura Poesis

Afterpiece Title: As It Should Be

Dance: As17890525

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: As It Should Be

Dance: End: As17890525; III: Hornpipe-Menage

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: The Romp

Afterpiece Title: Half an Hour after Supper

Afterpiece Title: Ut Pictura Poesis

Dance: As17890525

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Tit for Tat

Afterpiece Title: Ut Pictura Poesis

Afterpiece Title: Half an Hour after Supper

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Vimonda

Afterpiece Title: As It Should Be

Entertainment: Monologue. End 2nd piece: British Loyalty or A Squeeze for St. Paul's-Bannister Jun.; conclude with: God save the King-Chapman, Chambers, Mathews

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Half an Hour after Supper

Dance: End: As17890525

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: As It Should Be

Dance: As17890624

Performances

Mainpiece Title: Summer Amusement; Or, An Adventure At Margate

Afterpiece Title: Half an Hour after Supper

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: A Mogul Tale

Performances

Mainpiece Title: The Married Man

Afterpiece Title: The Romp

Dance: As17890708

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Family Party

Performances

Mainpiece Title: The Married Man

Afterpiece Title: Seeing is Believing

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Married Man

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Village Lawyer

Dance: End 2nd piece: as17890727

Performances

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

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Married Man

Afterpiece Title: Polly Honeycomb

Dance: As17890728