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