SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Siege of Memphis" | "The Ambitious Queen" | "The Siege Of Memphis Or The Ambitious Queen" | "Madam Fickle" | "The Witty False One" | "Madam Fickle" | "Madam Fickle Or The Witty False One" | "The Fool Turnd Critick" | "A Fond Husband" | "The Plotting Sisters" | "A Fond Husband" | "A Fond Husband Or The Plotting Sisters" | "Trick for Trick" | "The Debauchd Hypocrite" | "Trick For Trick Or The Debauchd Hypocrite" | "Squire Oldsapp" | "The Night Adventurers" | "Squire Oldsapp Or The Night adventurers" | "The Virtuous Wife" | "Good Luck at Last" | "The Virtuous Wife" | "The Virtuous Wife Or Good Luck At Last" | "Sir Barnaby Whigg" | "No Wit Like a Womans" | "Sir Barnaby Whigg Or No Wit Like A Womans" | "The Royalist" | "The Injured Princess" | "The Fatal Wager" | "The Injured Princess Or The Fatal Wager" | "A Commonwealth of Women" | "A Commonwealth Of Women" | "A Fools Preferment" | "The Three Dukes of Dunstable" | "A Fools Preferment Or The Three Dukes Of Dunstable" | "Mr Hainess Second Recantation A Prologue Intended to be spoken by him dressd in a Turkish habit" | "Love for Money" | "The Boarding School" | "Love for Money" | "Love For Money Or The Boarding School" | "Bussy DAmbois" | "The Husbands Revenge" | "Bussy dAmbois" | "Bussy Dambois Or The Husbands Revenge" | "The Marriage Hater Matched" | "The Marriage hater Matched" | "The Marriage Hater Matchd" | "The Richmond Heiress" | "A Woman Once in the Right" | "The Richmond Heiress" | "The Richmond Heiress Or A Woman Once In The Right" | "The Comical History of Don Quixote Part I" | "Don Quixote Part I" | "The Comical History Of Don Quixote Part I" | "The Comical History of Don Quixote Part II" | "Don Quixote Part II" | "The Comical History Of Don Quixote Part Ii" | "A Wife for Any Man" | "The Comical History of Don Quixote The Third Part With the Marriage of Mary the Buxome" | "Cinthia and Endimion" | "The Loves of the Deities" | "Cinthia and Endimion" | "Cinthia And Endimion Or The Loves Of The Deities" | "The Intrigues at Versailles" | "A Jilt in all Humours" | "The Intrigues At Versailles Or A Jilt In All Humours" | "The Campaigners" | "The Pleasant Adventures at Brussels" | "The Campaigners Or The Pleasant Adventures At Brussels" | "The Famous History of the Rise and Fall of Massaniello" | "The Famous History Of The Rise And Fall Of Massaniello" | "The Comical History of Don Quixote" | "Don Quixote" | "The Comical History Of Don Quixote" | "The Bath or The Western Lass" | "The Bath" | "The Western Lass" | "The Bath Or The Western Lass" | "Wonders in the Sun or The Kingdom of the Birds" | "The Wonders in the Sun" | "The Kingdom of the Bir" | "The Wonders In The Sun" | "The Modern Prophets or New Wit For a Husband" | "The Modern Prophets" | "New Wit For a Husband" | "The Modern Prophets Or New Wit For A Husband" | "Barataria" | "Sancho Turnd Governor" | "Barataria" | "Sancho turned Governour" | "Barataria or Sancho Turnd Governor")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION