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; Entrance into Cabin iMy Willy was a Sailor boldi Miss Gray; Between Decks iStand to your guns our cannons thunderi Townsend Hill; Entrance into Cabin iA pirates Lifei Townsend; Roads of iMadagascari Negro Air iWhen sunny Beamsi Master Standen; Sea Ballad iThree Years Ive bade sweet Home adieui Hill; Inside of Black Beards Hut West Indian View Seaman and Drunken Negro iIn Search of a Piratei Clarke Simmons; Romantic Heights with Black Beards Ship at a Distance Grand cabin by Moonlight iNo longer heave the heartfelt sighi Hill Miss Gray The Powder Magazine To conclude with a representation of the recent Glorious Engagement fought by iHis Majestys Sloop LEspoiri of 14 Guns and the Genoese Pirates Ship the Liguria"/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; Entrance into Cabin iMy Willy was a Sailor boldi Miss Gray; Between Decks iStand to your guns our cannons thunderi Townsend Hill; Entrance into Cabin iA pirates Lifei Townsend; Roads of iMadagascari Negro Air iWhen sunny Beamsi Master Standen; Sea Ballad iThree Years Ive bade sweet Home adieui Hill; Inside of Black Beards Hut West Indian View Seaman and Drunken Negro iIn Search of a Piratei Clarke Simmons; Romantic Heights with Black Beards Ship at a Distance Grand cabin by Moonlight iNo longer heave the heartfelt sighi Hill Miss Gray The Powder Magazine To conclude with a representation of the recent Glorious Engagement fought by iHis Majestys Sloop LEspoiri of 14 Guns and the Genoese Pirates Ship the Liguria")')
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