SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Haskey"/1) | (@(roleclean,performerclean) "Haskey")') 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
We found 265 matches on Roles/Actors, 34 matches on Performance Comments, 5 matches on Event Comments, 4 matches on Performance Title, and 0 matches on Author.

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: Who's the Dupe

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Douglas

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Honey Moon

Performances

Mainpiece Title: The London Merchant

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Siege Of Belgrade

Dance: As17970104

Performances

Mainpiece Title: Isabella

Ballet: The Scotch Ghost. As17961221

Song: As17960924

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Prize

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: Theodosius; Or, The Force Of Love

Song: Mainpiece: Vocal Parts-Dignum, Sedgwick, Cooke, Wentworth, Maddocks, Welsh, Grimaldi, Evans, J. Fisher, Gregson, Tett, Mrs Butler, Mrs Maddocks, Mrs Granger, Mrs Roffey, Mrs Gawdry, Mrs Benson, Mrs Menage

Performances

Mainpiece Title: Theodosius

Ballet: The Scotch Ghost. As17961221

Song: As17970120

Performances

Mainpiece Title: The London Merchant

Performances

Mainpiece Title: Tamerlane

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Isabella

Afterpiece Title: Blue-Beard

Song: As17971030

Performances

Mainpiece Title: The Will

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Jew

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Knave Or Not

Afterpiece Title: Blue-Beard