SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Genoese Pirate" | "Black Beard" | "The Genoese Pirate or Black Beard" | "British Fortitude and Hibernian Friendship" | "An Escape from France" | "British Fortitude And Hibernian Friendship Or An Escape From France" | "The Charity Boy" | "A Divertisement" | "The Purse" | "Benevolent Tar" | "THE PURSE or Benevolent Tar" | "Naples Bay" | "The British Seamen at Anchor" | "NAPLES BAY or The British Seamen at Anchor" | "The New Divertisement" | "THE NEW DIVERTISEMENT" | "The Apparition" | "The Way to Get Un Married" | "The Point at Herqui" | "British Bravery Triumphant" | "The Point at Herqui or British Bravery Triumphant" | "The Surrender of Trinidad" | "Safe Moord at Last" | "The Surrender of Trinidad" | "Safe Moored at Last" | "The Surrender of Trinidad or Safe Moord at Last" | "An Escape into Prison" | "The Round Tower" | "The Chieftains of Ireland" | "The Round Tower or The Chieftains of Ireland" | "Harlequin and Quixotte" | "The Magic Arm" | "Harlequin and Quixotte or The Magic Arm" | "Joan of Arc" | "The Maid of Orleans" | "Joan of Arc or The Maid of Orleans" | "The Raft" | "Both Sides of the Water" | "The Raft" | "The Raft or Both Sides of the Water" | "Harlequins Return" | "Theyve Bit the Old One" | "The Scheming Butler" | "Theyve Bit the Old One" | "Theyve Bit The Old One Or The Scheming Butler")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION