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" | "The Female Dramatist" | "Two to One" | "Two To One" | "Turk and No Turk" | "Turk And No Turk" | "Inkle and Yarico" | "Inkle And Yarico" | "Ways and Means" | "A Trip to Dover" | "Ways and Means" | "Ways And Means Or A Trip To Dover" | "The Family Party" | "The Battle of Hexham" | "Days of Old" | "The Battle of Hexam" | "The Battle Of Hexham Or Days Of Old" | "The Surrender of Calais" | "Poor Old Haymarket" | "Two Sides of the Gutter" | "The Mountaineers" | "New Hay at the Old Market" | "The Iron Chest" | "Sylvester Daggerwood" | "My Nightgown and Slippers" | "The Heir at Law" | "Blue Beard" | "Female Curiosity" | "Blue Beard or Female Curiosity" | "Blue Devils" | "Feudal Times" | "The Banquet Gallery" | "Feudal Times or The Banquet Gallery" | "The Castle of Sorrento" | "The Review" | "The Wags of Windsor" | "The Review or The Wags of Windsor")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION