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 Catch Club [i

Afterpiece Title: The Comet; or, How to Come at Her

Afterpiece Title: The Son-in-Law

Afterpiece Title: The Benevolent Planters

Dance: As17890805

Entertainment: Monologue As17890617

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: A Quarter of an Hour before Dinner

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Son-in-Law

Song: End I afterpiece: a song (composed by Giordani)-Miss George

Entertainment: End: Imitations-Rees

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Battle of Hexham

Performances

Mainpiece Title: As It Should Be

Afterpiece Title: The Battle of Hexham

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: The Battle of Hexham

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Battle of Hexham

Dance: End: Priere apres Souper- [see17890727

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Battle of Hexham

Dance: As17890817

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: The Battle of Hexham

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: The Comet

Performances

Mainpiece Title: The Catch Club

Afterpiece Title: Thimble's Flight from the Shopboard

Afterpiece Title: Gretna Green

Afterpiece Title: The Son-in-Law

Entertainment: Monologue End 3rd piece: As17890617

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Comet

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Minor

Dance: As17890728

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: The Comet

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: The Comet

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Miser

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Miser

Afterpiece Title: Harlequin's Chaplet

Dance: As 31 Dec. 1789

Performances

Mainpiece Title: The Czar

Afterpiece Title: The Miser

Performances

Mainpiece Title: The Crusade

Afterpiece Title: The Miser

Performances

Mainpiece Title: Notoriety

Afterpiece Title: The Miser

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Miser

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Miser

Song: In V: a Dirge, as17980917