SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Wright"/1) | (@(roleclean,performerclean) "Mr Wright")') 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
We found 4308 matches on Event Comments, 2051 matches on Performance Comments, 730 matches on Performance Title, 20 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Recruiting Officer

Song: Four and Twenty Stockjobbers-

Dance: Drunken Man-

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17201018

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: 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