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

Performances

Mainpiece Title: Philaster

Afterpiece Title: The Oxonian in Town

Dance: II: A Serious Dance, as17670916; III: The Sicilian Peasants-Sga Manesiere, Mrs Bulkley. [See17641001.

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Irish Fine Lady

Dance: End: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: Philaster

Afterpiece Title: Midas

Dance: II: The Merry Sailors, as17671009; III: The Sicilian Peasants, as17671123

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Love a-la-Mode

Dance: III: A New Comic Dance, as17671126

Performances

Mainpiece Title: The Royal Merchant

Dance: I: A New Comic Dance, as17671021; II: A Grand Ballet The Garland-Fishar, Mrs Bulkley. [See17651003.

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Deuce Is in Him

Dance: End: Hearts of Oak, as17671022

Performances

Mainpiece Title: The Royal Merchant

Afterpiece Title: The Oxonian in Town

Dance: End of Opera: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: The Royal Merchant

Afterpiece Title: The Upholsterer

Dance: End of Opera: The Garland, as17671214

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Thomasand Sally

Dance: III: The Garland, as17671214

Performances

Mainpiece Title: The Cure Of Saul

Music: I: Concerto on Hautboy-Giustinelli; II: Solo on Violin-Pinto (first violin)

Performances

Mainpiece Title: False Delicacy

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Samson

Music: As17680219

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Dr Faustus (With a New Additional Scene)

Performances

Mainpiece Title: Abimelech

Music: VViolin Solo-Barthelemon; Concerto on Hautboy-Simpson

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Lyar

Entertainment: End: A Search After Scrubs-Baddeley

Performances

Mainpiece Title: She Wou'd And She Wou'd Not; Or, The Kind Imposter

Afterpiece Title: Thomasand Sally

Song: I: Angelic Fair, a new song-DuBellamy; IV: By Particular Desire, the Cantata of Cymon and Iphigenia-DuBellamy

Ballet: End: The Wapping Landlady. As17680416

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Orpheus and Eurydice

Dance: II: A Hornpipe-Miss Besford, 2nd time

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Orpheus and Eurydice

Dance: II: The Highland Reel, as17680307

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Thomasand Sally

Dance: Between the acts: Duquesnay, Miss Street, scholars of Gherardi

Performances

Mainpiece Title: Catches And Glees

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Judgment of Paris

Dance: As17680530

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Flora; or, Hob in the Well

Performances

Mainpiece Title: Macbeth

Dance: TThe Lilliputian Camp-

Performances

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

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: The Earl Of Warwick

Afterpiece Title: The Padlock