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 span class"/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 span class")') 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