SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Elizabeth"/1) | (@(roleclean,performerclean) "Elizabeth")') 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 552 matches on Roles/Actors, 519 matches on Author, 211 matches on Performance Comments, 88 matches on Event Comments, and 11 matches on Performance Title.

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Genii

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Tom Thumb

Song: Miss Thomas

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Genii

Dance: II: New Pantomime Dance-Children, as17551203

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: Eliza

Afterpiece Title: Lilliput

Performances

Mainpiece Title: Eliza

Afterpiece Title: Lilliput

Music: II:By Particular Desire Concerto on the Harpsichord-Mr Arne Jun

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Lethe

Dance: IV: A Comic Dance call'd The Millers- [no dancers specified]

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Author

Dance: IV: The Millers, as17570129

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Toyshop

Song: IV: By desire, Ellen@a@Roon with variations on the Harp-Parry

Dance: HHornpipe-Walker

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Englishman in Paris

Dance: V: The Cow Keepers, as17600313

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: High Life Below Stairs

Performances

Mainpiece Title: King Richard Iii

Dance: TThe Cow Keepers, as17600529

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: King Richard Iii

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: High Life Below Stairs

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Enchanter

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: High Life Below Stairs

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Enchanter

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Polly Honeycomb

Dance: II: The Enchanted Peasant, as17610124

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Edgar and Emmeline

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Polly Honeycombe

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: High Life below Stairs

Dance: T+The May Day Morning Fingalian Dance, as17610416

Song: By Particular Desire, the Mimic Comic Opera Song-Mrs Clive

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: High Life below Stairs

Entertainment: M$Mr Foote's Epilogue to the Minor-Master Summers, a child 4 years old