SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "J F Lampe"/1) | (@(roleclean,performerclean) "J F Lampe")') 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 1197 matches on Performance Comments, 679 matches on Event Comments, 416 matches on Author, 150 matches on Performance Title, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Macbeth

Performance Comment: Macbeth-Macklin; Macduff-Clarke; Duncan-Hull; Malcolm-Wroughton; Banquo-Aickin; Lenox-L'Estrange; Seyton-Thompson; Hecate-Reinhold; The Witches-Dunstall, Mrs Pitt, Quick; the Vocal parts-Mattocks, DuBellamy, Baker, Fox, Miss Brown, Miss Dayes, Miss Valois, Mrs Willems, Mrs Lampe, Mrs Jones.

Afterpiece Title: St Patricks Day

Performances

Mainpiece Title: tis Well Its No Worse

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Beggars Opera

Afterpiece Title: A Trip to Scotland

Dance: II: A Dance, as17730506

Performances

Mainpiece Title: Matilda

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: All For Love

Afterpiece Title: The Absent Man

Dance: V: The Wake, as17680220

Performances

Mainpiece Title: Alonzo

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Black Prince

Performances

Mainpiece Title: The Temple Of Love

Performances

Mainpiece Title: Theseus

Performances

Mainpiece Title: The Emperor Of The Moon

Afterpiece Title: The City Ramble

Dance: Swedish Dal Karl and His Wife, as17150509; Harlequin and Two Punches-duPre, Moreau, Boval; Scaramouch-Thurmond Jr

Performances

Mainpiece Title: The Relapse

Song: As17151028

Performances

Mainpiece Title: Philaster Or Love Lies A Bleeding

Performances

Mainpiece Title: The Recruiting Officer

Performances

Mainpiece Title: The Relapse

Song: As17151028

Dance:

Performances

Mainpiece Title: Love For Love

Song: As17151028

Dance: As17151122

Performances

Mainpiece Title: The Country Wit Or Sir Mannerly Shallow

Dance: Boval, Prince, Birkhead

Song: As17151028

Performances

Mainpiece Title: The Pilgrim

Song: New Songs-Mrs Bowman

Dance: The Boor Left In The Lurch (new)-Burkhead, Mrs Willis

Performances

Mainpiece Title: Love For Love

Song: As17161004

Dance: Dupre, Boval, Dupre Jr, Mrs Santlow, Mrs Bicknell, Miss Younger

Performances

Mainpiece Title: The Spanish Fryar Or The Double Discovery

Performances

Mainpiece Title: The Relapse Or Virtue In Danger

Song: As17161004

Dance: As17161009

Performances

Mainpiece Title: The Country Wit Or Sir Mannerly Shallow

Song: As17161022

Dance: Dupre, Boval, Dupre Jr, Prince, Birkhead; Mimic Night Scene, as17161022

Performances

Mainpiece Title: She Woud If She Coud

Dance: Mrs Santlow

Performances

Mainpiece Title: Bartholomew Fair

Afterpiece Title: Harlequin Turnd Judge

Performances

Mainpiece Title: The Chances

Afterpiece Title: The What Dye Call It

Dance: As17180114

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The What Dye Call It

Dance: As17180318

Song: Ray, Mrs Boman