SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Arthur and Emmeline" | "The School for Scandal Scandalizd" | "The School for Scandal Scandalized" | "The School For Scandal Scandalizd" | "The Maid of Honour" | "The Maid Of Honour" | "The Projects" | "The Pannel" | "Coriolanus" | "The Roman Matron" | "Coriolanus" | "Coriolanus Or The Roman Matron" | "The Farm House" | "The Tempest" | "The Enchanted Island" | "The False Friend" | "Trick Upon Trick" | "Trick Upon Trick" | "The Vintner Out witted" | "Love In Many Masks" | "King Lear" | "Macbeth" | "Lodoiska" | "LODOISKA" | "Alls Well that Ends Well" | "Measure for Measure" | "Venice Preservd" | "Venice Preserved" | "Alexander the Great" | "The Plain Dealer" | "The Roman Actor" | "Celadon and Florimel" | "The Happy Counterplot" | "Celadon and Florimel or The Happy Counterplot" | "Much Ado about Nothing")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION