SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Spanish Rogue" | "The Empress of Morocco" | "The Amorous Old Woman" | "Tis Well if it Take" | "The Amorous Old Woman Or tis Well If It Take" | "The Mock Tempest" | "The Enchanted Castle" | "The Mock tempest Or The Enchanted Castle" | "Psyche Debauched" | "Beauties Triumph" | "The Mock Tempest")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION