SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Olympus in an Uproar" | "The Descent of the Deities" | "Olympus in an Uproar or The Descent of the Deities" | "Friar Bacon" | "Harlequins Adventures in Lilliput Brobdignag c" | "Friar Bacon" | "Harlequins Adventures in Lillipu" | "Friar Bacon or Harlequins Adventures in Lilliput Brobdignag c" | "The Lad of the Hills" | "The Wicklow Gold Mine" | "The Lad Of The Hills Or The Wicklow Gold Mine" | "Tony Lumpkin in Town" | "The Dilettante" | "Tony Lumpkin in Town or The Dilettante" | "The Son in Law" | "The She Gallant" | "The Dead Alive" | "The Agreeable Surprise" | "The Banditti" | "Loves Labyrinth" | "The Banditti Or Loves Labyrinth" | "The Positive Man" | "Harlequin Teague" | "The Giants Causeway" | "Harlequin Teague or The Giants Causeway" | "The Castle of Andalusia" | "The Castle Of Andalusia" | "Lord Mayor’s Day" | "A Flight from Lapland" | "The Maids the Mistress" | "The Maids The Mistress" | "The Shamrock" | "The Anniversary of St Patrick" | "The Young Quaker" | "The Birth Day" | "The Prince of Arragon" | "The Birth Day or The Prince of Arragon" | "Gretna Green" | "GRETNA GREEN" | "The Poor Soldier" | "Harlequin Rambler" | "The Convent in an Uproar" | "Harlequin Rambler or The Convent in an Uproar" | "Peeping Tom" | "Fontainbleau" | "Our Way in France" | "Fontainbleau" | "Fontainbleau Or Our Way In France" | "The Blacksmith of Antwerp" | "A Beggar on Horseback A Dramatic Proverb" | "A Beggar on Horseback" | "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" | "The Siege of Curzola" | "The Siege Of Curzola" | "The Man Milliner" | "Love and War" | "The Farmer" | "Tantara Rara Rogues All" | "The Prisoner at Large" | "A Key to the Lock" | "The Highland Reel" | "Aladdin" | "The Wonderful Lamp" | "The Toy" | "The Pharo Table" | "The Little Hunchback" | "A Frolick in Bagdad" | "The Little Hunchback or A Frolick in Bagdad" | "The Czar" | "The Basket Maker" | "The Fugitive" | "Modern Antiques" | "The Merry Mourners" | "Modern Antiques or The Merry Mourners" | "Wild Oats" | "The Strolling Gentleman" | "Sprigs of Laurel" | "The London Hermit" | "Rambles in Doresetshire" | "The World in a Village" | "The World In A Village" | "Lifes Vagaries" | "The Irish Mimick" | "Blunders at Brighton" | "The Irish Mimick or Blunders at Brighton" | "The Lie of the Day" | "A Party at Hampton Court" | "The Lie Of The Day Or A Party At Hampton Court" | "The Doldrum" | "1803" | "The Doldrum or 1803" | "The Magick Banner" | "Two Wives in a House" | "The Magick Banner or Two Wives in a House" | "The Wicklow Mountains" | "The Rival Soldiers" | "Britains Brave Tars" | "All for St Pauls" | "Britains Brave Tars" | "Shes Eloped" | "The Eleventh of June" | "The Daggerwoods at Dunstaple" | "A Nosegay of Weeds" | "Old Servants in New Places" | "A Nosegay of Weeds" | "A Nosegay of Weeds or Old Servants in New Places" | "Srings of Laurel" | "The Banditti" | "The Shamrock" | "The Lad of the Hills" | "The Lad Of The Hills")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION