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: The Suspicious Husband

Afterpiece Title: The Padlock

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: The Note of Hand

Dance: I: The Schoolmaster-Como, Sga Crespi

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: Harlequin's Jacket

Dance: I: The Irish Fair, as17751003

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Orpheus and Eurydice; or, The Metamorphoses of Harlequin

Performances

Mainpiece Title: The Distress'd Mother

Afterpiece Title: Harlequin's Jacket

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: Bon Ton; or, High Life Above Stairs

Dance: II: The Savage Hunters, as17751020

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: The Theatrical Candidates

Afterpiece Title: Bon Ton

Dance: End: The Merry Peasants, as17751018

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: Bon Ton

Dance: End: The Merry Peasants, as17751018

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: The Elopement

Dance: II: The Savage Hunters, as17751020

Performances

Mainpiece Title: Braganza

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: May Day

Dance: II: By Particular Desire, The Savage Hunters, as17751020, but Blurton

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Queen Mab

Dance: I: The Savage Hunters, as17751118

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Queen Mab

Dance: II: The Savage Hunters, as17751118

Performances

Mainpiece Title: Old City Manners

Afterpiece Title: The Deserter

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Braganza

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Lyar

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Sultan; or, A Peep into the Seraglio

Performances

Mainpiece Title: Matilda

Afterpiece Title: The Sultan

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Miss in Her Teens