SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Soldier\'s Festival" | "The Soldier\'s Festival" | "or, The Night before the B" | "The Follies of a Day" | "Friar Bacon" | "or, Harlequin\'s Adventures in Lilliput, Brobdignag, &c" | "Friar Bacon" | "or, Harlequin\'s Adventures in Lillipu" | "The Magic Cavern" | "Virtue\'s Triumph" | "The Prophet" | "The Lad of the Hills" | "or, The Wicklow Gold Mine" | "The Lad Of The Hills" | "The Crisis" | "or, Love and Fear" | "The Flitch of Bacon" | "The Cobler of Castlebury" | "The Device" | "or, The Deaf Doctor" | "The Device" | "The Deaf Lover" | "The Siege of Gibraltar" | "The Divorce" | "Lord Mayor’s Day" | "or, A Flight from Lapland" | "The Shamrock" | "or, The Anniversary of St. Patrick" | "The Shamrock" | "The Poor Soldier" | "The Magic Picture" | "Harlequin Junior" | "or, The Magic Cestus" | "Harlequin Junior" | "Harlequin Rambler" | "or, The Convent in an Uproar" | "Robin Hood" | "or, Sherwood Forest" | "Robin Hood" | "The Noble Peasant" | "Fontainbleau" | "or, Our Way in France" | "Fontainbleau" | "The Follies of a Day" | "or, The Marriage of Figaro" | "The Campaign" | "or, Love in the East Indies" | "The Campaign" | "The Choleric Fathers" | "Omai" | "or, A Trip round the World" | "Love in a Camp" | "or, Patrick in Prussia" | "Small Talk" | "or, The Westminster Boy" | "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" | "or, The Wonderful Lamp" | "The Czar" | "The Crusade" | "The Fugitive" | "The Picture of Paris" | "The Woodman" | "Oscar and Malvina" | "or, The Hall of Fingal" | "The Midnight Wanderers" | "Sprigs of Laurel" | "Harlequin and Faustus" | "or, The Devil will have His Own" | "The Travellers in Switzerland" | "Netley Abbey" | "Arrived at Portsmouth" | "Hercules and Omphale" | "Mago and Dago" | "or, Harlequin the Hero" | "The Mysteries of the Castle" | "The Irish Mimick" | "or, Blunders at Brighton" | "Lock and Key" | "The Point at Herqui" | "or, British Bravery Triumphant" | "The Wicklow Mountains" | "Abroad and at Home" | "Italian Villagers" | "The Village Fete" | "Srings of Laurel")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION