SELECT *
FROM london_stages
WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Clarke William Drunken Negro Simmons Servants Negro Boy Master Standen Lieut Maynard Sailors Nancy Servants Orra Ismena For the three assigned parts see Songs below the following new Scenes Songs Grand Cabin While the jolly grog Townsend Hill Linton "/1) | (@(roleclean,performerclean) "Clarke William Drunken Negro Simmons Servants Negro Boy Master Standen Lieut Maynard Sailors Nancy Servants Orra Ismena For the three assigned parts see Songs below the following new Scenes Songs Grand Cabin While the jolly grog Townsend Hill Linton ")')
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