SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "A Midsummer Nights Dream" | "The Musical Lady" | "Philaster" | "Occasional Prelude" | "Comus" | "Epicœne" | "The Silent Woman" | "Epicoene" | "The Silent Woman" | "Epicoene Or The Silent Woman" | "A Preludio" | "Polly Honeycomb" | "Polly Honeycombe" | "The Jealous Wife" | "The Deuce is in Him" | "The Deuce Is in Him" | "The Fairy Tale" | "A Fairy Tale" | "The Portrait" | "The Portrait" | "The Painters Easel" | "Mother Shipton" | "The Fairy Prince with the Installation of the Knights of the Garter" | "Elfrida" | "Achilles in Petticoats" | "The Man of Business" | "The Man Of Business" | "The Spleen" | "Islington Spa" | "The Spleen or Islington Spa" | "Polly" | "The Sheep Shearing" | "The Sheep shearing" | "The Spanish Barber" | "The Fruitless Precaution" | "The Spanish Barber Or The Fruitless Precaution" | "The Female Chevalier" | "The Suicide" | "Bonduca" | "The Separate Maintenance" | "The Manager in Distress" | "The Manager In Distress" | "The Genius of Nonsense" | "The Young Actor" | "Fatal Curiosity" | "Harlequin Teague" | "The Giants Causeway" | "Harlequin Teague or The Giants Causeway" | "The Election of Managers" | "Tit for Tat" | "Tit For Tat" | "The Blade Bone" | "Ut Pictura Poesis" | "The Enraged Musician")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION