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

Performances

Mainpiece Title: The Country Wife

Dance:

Performances

Mainpiece Title: Troilus And Cressida

Performances

Mainpiece Title: Venice Preserv'd; Or, A Plot Discover'd

Performances

Mainpiece Title: The Mourning Bride

Performances

Mainpiece Title: The Cheats

Performances

Mainpiece Title: The Cheats

Dance: Two Harlequins and Two Punches-

Performances

Mainpiece Title: The Old Batchelor

Song:

Dance: Particularly The Italian Shadows-

Performances

Mainpiece Title: The Cheats

Dance: As17201128

Performances

Mainpiece Title: The History And Fall Of Caius Marius

Performances

Mainpiece Title: Amphitryon; Or, The Two Sosias

Dance: Shaw, Thurmond Jr, Lally, Mrs Younger, Mrs Tenoe, Miss Smith

Performances

Mainpiece Title: The Country Wife

Dance:

Performances

Mainpiece Title: The History And Fall Of Caius Marius

Performances

Mainpiece Title: The Second Part Of The History Of King Henry The Fourth; With The Humours Of Sir John Falstaffe Henry Iv, Part Ii

Performances

Mainpiece Title: Henry Iv, Part Ii

Performances

Mainpiece Title: The Plain Dealer

Performances

Mainpiece Title: The Plain Dealer

Performances

Mainpiece Title: The Plain Dealer

Performances

Mainpiece Title: Venice Preserv'd

Performances

Mainpiece Title: Macbeth

Dance: Dupre, Newhouse, Cook, Sandham

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17201018

Performances

Mainpiece Title: The Refusal; Or, The Lady's Philosophy

Performances

Mainpiece Title: The Cheats

Performances

Mainpiece Title: Troilus And Cressida

Performances

Mainpiece Title: The Way Of The World

Dance: As17201018

Performances

Mainpiece Title: King Richard The Third