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: King Richard The Third

Performances

Mainpiece Title: Concert

Music: First Violin-Dubourg; Concert-Kytch; Solo-J. Festing

Performances

Mainpiece Title: Abra Mule

Afterpiece Title: Amadis

Performances

Mainpiece Title: All For Love

Dance: As17201018

Performances

Mainpiece Title: King Richard The Third

Performances

Mainpiece Title: The Country Wife

Dance: Shaw, Denoyer, Mrs Younger, Miss Smith

Performances

Mainpiece Title: The Way Of The World

Dance: Shaw, Desnoyer, Thurmond Jr, Mrs Booth, Mrs Bicknell, Mrs Younger; Myrtillo-

Performances

Mainpiece Title: The History And Fall Of Caius Marius

Dance:

Performances

Mainpiece Title: The Spanish Fryar

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: Desnoyer, Boval, Mrs Bicknell, Mrs Bullock, Miss Tenoe

Performances

Mainpiece Title: Amphitryon

Dance:

Performances

Mainpiece Title: The Fair Penitent

Dance:

Performances

Mainpiece Title: Cleomenes; Or, The Spartan Hero

Dance: Mrs Rogeir, Mrs Tenoe

Performances

Mainpiece Title: The London Cuckolds

Dance: As17210704

Performances

Mainpiece Title: The Tempest

Performances

Mainpiece Title: The Injur'd General; Or, The Blind Beggar Of Bednal-green; With The Comical Humours Of Squire Sousecrown And His Man Gudgeon

Song: Mrs Willis

Dance: Mrs Willis

Performances

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

Performances

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

Performances

Mainpiece Title: Love's Last Shift; Or, The Fool In Fashion

Performances

Mainpiece Title: Amphitryon; Or, The Two Sosias

Performances

Mainpiece Title: King Richard The Third

Performances

Mainpiece Title: The Country Wife

Dance:

Performances

Mainpiece Title: The Recruiting Officer

Performances

Mainpiece Title: The Lancashire Witches; Or, Teague O'divelly