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 Wonder

Afterpiece Title: The Author

Song: By particular Desire, Ellen@a@roon-Mrs Clive

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Englishman in Paris

Song: I: The Country Wedding-Beard; II: The Bonny Broom-Miss Young; III: By Desire, Music: Sir Watkins Delighton the Harp-Parry; IV: The Toast-Beard; V: A Duetto When Phoebus the top of the Hills does Adorn-Beard, Miss Young

Performances

Mainpiece Title: None

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman Returned from Paris

Dance: FFingalian Revels, as17570329

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The What D'ye Call It

Dance: As17570103

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin Statue; or, The Jealous Farmer Outwitted

Dance: FFingalian Revels, as17570329 Hornpipe-Poitier Jr

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: A Duke and no Duke

Dance: I: Hornpipe-Poitier Jr; II: Old Scotch Dance-Leppie, Miss Hilliard; III: Fingalian Revels, as17570329 V: Louvre and Minuet-Leppie, Miss Hilliard

Song: IV: A song-Mrs Chambers

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Tamer Tam'd

Song: I: Miss Young

Dance: II: A Comic Dance [dancers unspecified]-; III: A Hornpipe-Harrison; IV: A New Comic Dance-

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: None

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The School Boy

Dance: I: Country Lass, as17570512; II: Dutch Sailor, as17570525; III: Dutch Peasant, as17570512

Performances

Mainpiece Title: A Medley Concert And Auction

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: None

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Country Lasses; Or, The Custom Of The Manor

Afterpiece Title: The Contrivances

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Chaplet

Dance: II: The Italian Peasants, as17571004

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Mercury Harlequin

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: The Devil to Pay

Dance: II: The Italian Peasants, as17571004

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: The Inconstant; Or, The Way To Win Him

Afterpiece Title: Merlin (Harlequin Skeleton)

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Merlin (Harlequin Skeleton)

Dance: JJovial Coopers, as17571107

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Fatal Marriage

Afterpiece Title: The Male Coquette

Dance: IV: The Italian Peasants, as17571004

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: The Author

Dance: III: The Market, as17571126