SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Purjurd Husband or The Adventure of Venice" | "The Perjured Husband" | "The Adventures of Venice" | "The Perjured Husband Or The Adventures Of Venice" | "The Beaus Duel or A Soldier for the Ladies" | "The Beaus Duel" | "The Stolen Heiress or the Salamanca Doctor Outplotted" | "The Heiress" | "The Salamanca Doctor Out Plotted" | "The Heiress Or The Salamanca Doctor Out Plotted" | "Loves Contrivance or Le Medecin malgre Lui" | "Loves Contrivance" | "Le Medecin Malgre Luy" | "Loves Contrivance Or Le Medecin Malgre Luy" | "The Gamester" | "The Bassett Table" | "The Basset Table" | "The Platonick Lady" | "The Busie Body" | "The Busy Body" | "The Mans Bewitchd" | "The Devil to do about Her" | "The Mans Bewitchd" | "The Devil To Do About Her" | "The Mans Bewitchd Or The Devil To Do About Her" | "A Bickerstaffs Burying" | "Work for the Upholders" | "A Bickerstaffs Burying" | "A Bickerstaffs Burying Or Work For The Upholders" | "Mar Plot" | "The Second Part of the Busie Body" | "Marplot" | "The Perplexd Lovers" | "The Wonder A Woman Keeps a Secret" | "The Wonder" | "The Cruel Gift" | "The Royal Resentment" | "The Cruel Gift" | "The Cruel Gift Or The Royal Resentment" | "A Bold Stroke for a Wife" | "A Bold Stroke For A Wife" | "The Artifice" | "A Wife Well Managd" | "The Beaux Duel" | "A Soldier for the Ladies" | "The Beaux Duel or A Soldier for the Ladies" | "Love at a Venture" | "The Rake Reclaimd" | "Love at a Venture" | "The Rake Reclaimed" | "Love At A Venture Or The Rake Reclaimd" | "The Pharo Table" | "Love at a Venture")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION