SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "P Sandford"/1) | (@(roleclean,performerclean) "P Sandford")') 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 1648 matches on Event Comments, 379 matches on Performance Comments, 17 matches on Performance Title, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Dragon of Wantley

Dance: New entertainments-Salomon, Sga Padouana, Salomon's son

Performances

Mainpiece Title: Susanna, An Oratorio

Performances

Mainpiece Title: The Mistake

Afterpiece Title: The Englishman in Paris

Song: II: The Cantata of Cimon and Iphigenia-Beard

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Lethe

Dance: PPierrots Dance-Settree, Walker, Sga Fiorentina; Hornpipe-a small jolly Tar, seven years old; La Dance de Village-Settree, Sga Fiorentina

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: The Register Office

Performances

Mainpiece Title: Old City Manners

Afterpiece Title: May Day

Dance: The Merry Peasants, as17751018

Performances

Mainpiece Title: The Runaway

Afterpiece Title: May Day

Performances

Mainpiece Title: Zara

Afterpiece Title: The Spleen; or, Islington Spa

Dance: V: The Sailors Revels, as17751220

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Provocation

Performances

Mainpiece Title: Douglas

Afterpiece Title: Harlequin's Museum; or, Mother Shipton Triumphant

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: Douglas

Afterpiece Title: Harlequin Captive; or, The Magick Fire

Performances

Mainpiece Title: Mahmoud; Or, The Prince Of Persia

Afterpiece Title: All the World's a Stage

Performances

Mainpiece Title: Antigona

Dance: As17960423

Performances

Mainpiece Title: Zara

Afterpiece Title: Harlequin and Oberon; or, The Chace to Gretna

Performances

Mainpiece Title: Wit Without Money

Performances

Mainpiece Title: Rollo, Duke Of Normandy

Performances

Mainpiece Title: The Moore Of Venice

Performances

Mainpiece Title: The Maid In The Mill

Performances

Mainpiece Title: The Siege Of Rhodes, Part I