SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Cheats" | "The Tavern Bilkers" | "The Cheats" | "The Cheats or The Tavern Bilkers" | "The Jealous Doctor or The Intriguing Dame" | "The Jealous Doctor" | "The Intriguing Dame" | "Harlequin Executed" | "Harlequin Executed" | "The Farmer Disappointed" | "Amadis" | "The Loves of Harlequin and Colombine" | "Amadis" | "Jupiter and Europa" | "The Intrigues of Harlequin" | "Jupiter and Europa or The Intrigues of Harlequin" | "The Necromancer" | "Harlequin Doctor Faustus" | "Doctor Faustus" | "The Necromancer" | "The Necromancer or Harlequin Doctor Faustus" | "Apollo and Daphne" | "The Burgomaster Trickd" | "Apollo and Daphne" | "The Burgo Master Trickd" | "Apollo and Daphne or The Burgomaster Trickd" | "The Fair" | "The Spirit of Contradiction" | "The Magician" | "Harlequin a Director" | "The Magician or Harlequin a Director")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION