SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Duenna" | "The Double Elopement" | "The Duenna" | "The Duenna Or The Double Elopement" | "The Rivals" | "St Patricks Day" | "The Scheming Lieutenant")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION