SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Elfrid or The Fair Inconstant" | "Elfrid" | "The Fair Inconstant" | "Elfrid Or The Fair Inconstant" | "The Walking Statue or The Devil in the Wine Cellar" | "The Walking Statue" | "Squire Brainless" | "Trick upon Trick" | "Squire Brainless" | "Squire Brainless Or Trick Upon Trick" | "The Fatal Vision or The Fall of Siam" | "The Fatal Vision" | "The Fall of Siam" | "The Fatal Vision Or The Fall Of Siam" | "Fatal Extravagance" | "The Fatal Extravagance" | "King Henry the Vth" | "The Conquest of France by the English" | "King Henry the Fifth" | "The Conquest of France" | "King Henry The Vth Or The Conquest Of France By The English" | "Athelwold" | "Athelwold" | "Zara" | "Zara" | "Alzira" | "The Americans" | "Alzira Or The Americans" | "Meropé" | "The Insolvent" | "Filial Piety" | "The Insolvent Or Filial Piety" | "The Prodigal")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION