SELECT *
FROM london_stages
WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Clarkei iWilliami iDrunken Negro Simmonsi iServantsi iNegro Boy Master Standeni iLieut Maynardi iSailorsi iNancyi Servants iOrrai iIsmenai For the three assigned parts see Songs below the following new Scenes Songs Grand Cabin iWhile the jolly grogi Townsend Hill Linton Street Abbot"/1) | (@(roleclean,performerclean) "Clarkei iWilliami iDrunken Negro Simmonsi iServantsi iNegro Boy Master Standeni iLieut Maynardi iSailorsi iNancyi Servants iOrrai iIsmenai For the three assigned parts see Songs below the following new Scenes Songs Grand Cabin iWhile the jolly grogi Townsend Hill Linton Street Abbot")')
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