SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Haunted Tower" | "The Cherokee" | "La Cameriera Astuta" | "The Doctor and the Apothecary" | "No Song No Supper" | "The Siege of Belgrade" | "The Siege Of Belgrade" | "The Cave of Trophonius" | "Poor Old Drury" | "Cymon" | "Dido Queen of Carthage" | "The Pirates" | "The Prize" | "2538" | "My Grandmother" | "MY GRANDMOTHER" | "Lodoiska" | "LODOISKA" | "The Glorious First of June" | "THE GLORIOUS FIRST OF JUNE" | "The Three and the Deuce" | "The Iron Chest" | "Mahmoud" | "The Prince of Persia" | "Mahmoud Or The Prince Of Persia")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION