SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Blind Lady" | "The Surprisal" | "The Surprizal" | "The Surprizal" | "The Committee" | "The Indian Queen" | "The Great Favourite" | "The Duke of Lerma" | "The Great Favourite Or The Duke Of Lerma" | "The Committee" | "The Faithful Irishman" | "The Committee" | "The Faithful Irish Man" | "The Committee Or The Faithful Irishman")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION