SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "W Hamilton"/1) | (@(roleclean,performerclean) "W Hamilton")') 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 1749 matches on Performance Comments, 305 matches on Event Comments, 50 matches on Roles/Actors, 42 matches on Performance Title, and 10 matches on Author.

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Cato

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The London Merchant; Or, The History Of George Barnwell

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Miser

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Unhappy Favorite; Or, The Earl Of Essex

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Afterpiece Title: The Virgin Unmasked

Song: I: Sullivan

Dance: III: A New Dance-Desse, Mrs Walter, Leviez, Shawford, Miss Scott

Performances

Mainpiece Title: The Mourning Bride

Song: II: Song-Sullivan

Dance: III: Dance, as17431013; V: a New Dance-Muilment, Desse, Liviez, Mrs Walter

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplish'd Fools

Afterpiece Title: The Lying Valet

Song: As17431018

Dance: As17431018

Performances

Mainpiece Title: Aesop

Afterpiece Title: The Lying Valet

Song: I, III: Sullivan

Dance: II, IV: As17431018

Performances

Mainpiece Title: The True And Ancient History Of King Lear, And His Three Daughters

Afterpiece Title: The School Boy

Song: I, III: Sullivan

Dance: As17431022

Performances

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

Afterpiece Title: The Lying Valet

Song: I, III: Sullivan

Dance: II, IV: As17431015

Performances

Mainpiece Title: Tamerlane

Song: As17431027

Dance: As17431027

Performances

Mainpiece Title: Women Pleased

Song: As17431029

Dance: V: A Grand Dance-Muilment, Mrs Walter, Mrs Thomson

Performances

Mainpiece Title: The Rival Queens; Or, Alexander The Great

Afterpiece Title: The Lying Valet

Song: As17431029

Dance: III: A New Dance, as17431015

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: The Anatomist

Song: I, IV: Sullivan

Dance: III: Dance-Muilment, Desse, Leviez, Mrs Walter, Miss Scott

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Anatomist

Song: III, IV: Sullivan

Dance: II: Dance, as17431123

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Lying Valet

Song: II: Sullivan; IV: Bumper Squire Jones-Sullivan

Dance: III: Italian Masquerade-Muilment, Desse, Leviez, Mrs Walter, Mrs Thomson

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Lying Valet

Dance: V: Dance, as17431123

Performances

Mainpiece Title: The Rehearsal

Performances

Mainpiece Title: Hamlet

Song: II: Song-Morland

Dance: IV: As17431123

Performances

Mainpiece Title: The Wonder; Or, A Woman Keeps A Secret

Afterpiece Title: The Virgin Unmasked

Song: II: Song-Morland

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth; With The Humours Of Sir John Falstaff, Justice Shallow, Ancient Pistol

Afterpiece Title: Columbine Courtezan

Performances

Mainpiece Title: Oedipus, King Of Thebes

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Fatal Marriage; Or, The Innocent Adultery

Afterpiece Title: The Lying Valet

Dance: Muilment, Mlle Auguste