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 Cave of Trophonius" | "Poor Old Drury!!!" | "Poor Old Drury!" | "Poor Old Drury" | "Cymon" | "Dido, Queen of Carthage" | "Dido Queen Of Carthage" | "The Pirates" | "The Prize" | "or, 2.5.3.8" | "My Grandmother" | "Lodoiska" | "The Glorious First of June" | "The Three and the Deuce!" | "The Three and the Deuce" | "The Iron Chest" | "Mahmoud" | "or, The Prince of Persia")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION