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

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Apprentice

Dance: I: A Hornpipe-Miss Cranfield; II: The Pilgrim, as17750503

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Bon Ton

Dance: V: The Grand Provencalle Dance, as17750202

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: End: A Dance-

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: A Trip to Scotland

Song: III: The Favourite Song of Gramachree Molly-Mrs Wrighten

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Note of Hand

Dance: II: The Pirates, as17750422

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: High Life below Stairs

Dance: V: The Pirates, as17750422

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Rival Candidates

Dance: Slingsby, Sga Hidou [title of dance not specified]

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: I: Chaconne-Mlle Baccelli; (by Particular Desire) a Minuet-M and Mme Vallouis; II: Ballet Pastorale et Pantomime-M and Mme Vallouis

Ballet: End Opera: Grand Ballet Tragique called Oreste et Electre. Oreste-Vallouis; Electre-Mme Vallouis; Clytemnestre-Mlle Baccelli

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Cross Purposes

Dance: End: The Pilgrim, as17750503

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: St Patrick's Day

Dance: End: The Irish Lilt, as17741202

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