SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Soldiers Festival" | "The Soldiers Festival" | "The Night before the B" | "The Follies of a Day" | "The Follies Of A Day" | "Friar Bacon" | "Harlequins Adventures in Lilliput Brobdignag c" | "Friar Bacon" | "Harlequins Adventures in Lillipu" | "Friar Bacon or Harlequins Adventures in Lilliput Brobdignag c" | "The Magic Cavern" | "Virtues Triumph" | "The Prophet" | "The Lad of the Hills" | "The Wicklow Gold Mine" | "The Lad Of The Hills Or The Wicklow Gold Mine" | "The Crisis" | "Love and Fear" | "The Crisis or Love and Fear" | "The Flitch of Bacon" | "The Cobler of Castlebury" | "The Device" | "The Deaf Doctor" | "The Device or The Deaf Doctor" | "The Deaf Lover" | "The Siege of Gibraltar" | "The Siege Of Gibraltar" | "The Divorce" | "Lord Mayor’s Day" | "A Flight from Lapland" | "The Shamrock" | "The Anniversary of St Patrick" | "The Poor Soldier" | "The Magic Picture" | "Harlequin Junior" | "The Magic Cestus" | "Harlequin Junior" | "Harlequin Rambler" | "The Convent in an Uproar" | "Harlequin Rambler or The Convent in an Uproar" | "Robin Hood" | "Sherwood Forest" | "Robin Hood" | "Robin Hood Or Sherwood Forest" | "The Noble Peasant" | "Fontainbleau" | "Our Way in France" | "Fontainbleau" | "Fontainbleau Or Our Way In France" | "The Follies of a Day" | "The Marriage of Figaro" | "The Follies Of A Day Or The Marriage Of Figaro" | "The Campaign" | "Love in the East Indies" | "The Campaign Or Love In The East Indies" | "The Choleric Fathers" | "Omai" | "A Trip round the World" | "Omai or A Trip round the World" | "Love in a Camp" | "Patrick in Prussia" | "Love in a Camp or Patrick in Prussia" | "Small Talk" | "The Westminster Boy" | "Small Talk or The Westminster Boy" | "Richard Coeur de Lion" | "Richard Coeur De Lion" | "The Enchanted Castle" | "Lingo’s Opinions on Men and Manners (A Comical Whimsical Operatical Farcical Rhapsody" | "Lingo’s Opinions on Men and Manners" | "Nina" | "The Farmer" | "Marian" | "The Highland Reel" | "Aladdin" | "The Wonderful Lamp" | "The Czar" | "The Crusade" | "The Fugitive" | "The Picture of Paris" | "The Woodman" | "Oscar and Malvina" | "The Hall of Fingal" | "Oscar and Malvina or The Hall of Fingal" | "The Midnight Wanderers" | "Sprigs of Laurel" | "The Travellers in Switzerland" | "The Travellers In Switzerland" | "Netley Abbey" | "NETLEY ABBEY" | "Arrived at Portsmouth" | "Hercules and Omphale" | "Mago and Dago" | "Harlequin the Hero" | "Mago and Dago or Harlequin the Hero" | "The Mysteries of the Castle" | "The Mysteries Of The Castle" | "The Irish Mimick" | "Blunders at Brighton" | "The Irish Mimick or Blunders at Brighton" | "Lock and Key" | "The Point at Herqui" | "British Bravery Triumphant" | "The Point at Herqui or British Bravery Triumphant" | "The Wicklow Mountains" | "Abroad and at Home" | "Abroad And At Home" | "Italian Villagers" | "The Rival Soldiers" | "The Village Fete" | "Srings of Laurel")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION