SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Apollo And Daphne" | "Or, The Burgomaster Trick\'d" | "Or, The Burgo-Master Trick\'d" | "Apollo And Daphne Or The Burgo Master Trickd" | "Perseus And Andromeda" | "Or, The Spaniard Outwitted" | "The Persian Princess: Or, The Royal Villain" | "The Persian Princess" | "The Persian Princess Or The Royal Villain" | "The Perfidious Brother" | "Pan And Syrinx" | "The Lady\'s Triumph" | "The Tragedy Of 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" | "The Rape Of Proserpine With The Birth And Adventures Of Harlequin" | "Double Falsehood" | "Or, The Distrest Lovers" | "Orestes" | "The Fatal Secret" | "Merlin" | "Or, The Devil Of Stone-Henge" | "The Happy Captive")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION