SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "He Woud be a Soldier" | "He Would be a Soldier" | "He Woud Be A Soldier" | "The Magic Cavern" | "Virtues Triumph" | "The Invasion" | "A Trip to Brighthelmstone" | "The Invasion" | "The Invasion or A Trip to Brighthelmstone" | "The Liverpool Prize" | "Illumination" | "The Glaziers Conspiracy" | "Illumination Or The Glaziers Conspiracy" | "The Device" | "The Deaf Doctor" | "The Device or The Deaf Doctor" | "The Deaf Lover" | "A Gazette Extraordinary" | "The Illumination" | "The Siege of Gibraltar" | "The Siege Of Gibraltar" | "The Humours of an Election" | "Thelypthora" | "More Wives than One" | "The Fair American" | "Aerostation" | "The Templars Stratagem" | "Aerostation" | "Aerostation or The Templars Stratagem" | "Barataria" | "Sancho Turnd Governor" | "Barataria" | "Sancho turned Governour" | "Barataria or Sancho Turnd Governor" | "Alls Well that Ends Well" | "Alls Well That Ends Well" | "The Device" | "Illumination")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION