SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Changeling" | "The Maid in the Mill" | "The Maid In The Mill" | "A Cure for a Cuckold" | "Alls Lost by Lust" | "Alls Lost By Lust" | "Birth of Merlin" | "The Childe hath found his Father" | "The Spanish Gypsies" | "The Noble Gentlemen" | "A Shoemakers a Gentleman" | "A Shoemaker a Gent" | "A Shoemaker A Gent" | "The Maid of the Mill" | "The Country Revels" | "The Maid of the Mill or The Country Revels")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION