SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Rosamond" | "Cato" | "The Drummer" | "The Haunted House" | "The Drummer" | "The Drummer Or The Haunted House")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION