SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Apollo and Daphne" | "The Burgomaster Trickd" | "Apollo and Daphne" | "The Burgo Master Trickd" | "Apollo and Daphne or The Burgomaster Trickd" | "Perseus and Andromeda" | "The Spaniard Outwitted" | "Perseus and Andromeda" | "Perseus and Andromeda or The Spaniard Outwitted" | "The Persian Princess or The Royal Villain" | "The Persian Princess" | "The Royal Villain" | "The Persian Princess Or The Royal Villain" | "The Perfidious Brother" | "Pan and Syrinx" | "The Ladys Triumph" | "The Tragedy of King Richard II" | "King Richard the Second" | "King Richard The Second" | "Harlequin a Sorcerer With the Loves of Pluto and Proserpine" | "Harlequin a Sorcerer With The Loves of Pluto and Proserpine" | "The Rape of Proserpine With The Birth and Adventures of Harlequin" | "The Rape of Proserpine" | "Double Falsehood" | "The Distrest Lovers" | "Double Falsehood Or The Distrest Lovers" | "Orestes" | "The Fatal Secret" | "The Fatal Secret" | "Merlin" | "The Devil of Stone Henge" | "Merlin or The Devil of Stone Henge" | "The Happy Captive" | "The Temple of Dulness" | "with the Humours of Sg Capochio and Sga Dorinna" | "The Medley" | "Harlequin At All" | "The Medley or Harlequin At All")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION