SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Maid of the Oaks" | "The Maid Of The Oaks" | "The Lord of the Manor" | "The Lord Of The Manor" | "The Heiress" | "Richard Coeur de Lion")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION