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 Crisis" | "Or, Love And Fear" | "The Flitch Of Bacon" | "The Cobler Of Castlebury" | "The Device" | "Or, The Deaf Doctor" | "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 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 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" | "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