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

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Irish Fine Lady

Dance: End: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: A Trip to Scotland

Dance: II: A Dance, as17730506

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Pigmy Revels

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Padlock

Dance: III: The Highland Reel-Aldridge, Miss Valois, Miss Besford. [See17730519.

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Golden Pippin

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Achilles in Petticoats

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Afterpiece Title: Midas

Performances

Mainpiece Title: The Winter's Tale

Afterpiece Title: The Citizen

Afterpiece Title: The Sylphs

Performances

Mainpiece Title: The South Briton

Afterpiece Title: The Apprentice

Dance: IV: A Double Hornpipe-Mas. Blurton, Miss Besford; End I Farce: A Minuet-Aldridge, Mrs Bulkley

Monologue: Interlude.End: True Blue. As 26 March

Performances

Mainpiece Title: Lady Jane Grey

Afterpiece Title: The Citizen

Dance: End: The Frolick, as17740510; End I Farce: A Double Hornpipe-Mr and Mrs Holloway

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: The Elopement

Dance: II: The Savage Hunters, as17751020

Performances

Mainpiece Title: The Earl Of Warwick

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Lyar

Performances

Mainpiece Title: The Discovery

Afterpiece Title: The Lottery

Dance: II: The Gardeners, as17760116

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Bon Ton

Dance: In: The Savage Hunters, as17751118

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Waterman

Song: V: (By Desire) The Soldier Tir'd-Miss Abrams

Performances

Mainpiece Title: Isabella; Or, The Fatal Marriage

Afterpiece Title: Catherine and Petruchio

Performances

Mainpiece Title: The School For Rakes

Afterpiece Title: The Waterman

Dance: End: The Savage Hunters, as17751118

Performances

Mainpiece Title: The Plain Dealer

Afterpiece Title: A Peep behind the Curtain

Dance: V: A Grand Chaconne-Como, Sga Crespi