SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Lionel and Clarissa" | "Lionel And Clarissa" | "The Padlock" | "The Cobler" | "The Cobler" | "A Wife in Ten Thousand" | "The Two Misers" | "The Metamorphoses" | "The Romp" | "The Jubilee" | "The Institution of the Garter" | "Arthurs Round Table Restored" | "The Institution of the Garter or Arthurs Round Table Restored" | "Lionel and Clarissa" | "The School for Fathers" | "Lionel And Clarissa Or The School For Fathers" | "The Sultan" | "A Peep into the Seraglio" | "The Sultan or A Peep into the Seraglio" | "The Shepherds Artifice" | "The Captive" | "The Ephesian Matron" | "The Ephesian Matron" | "The Widow�s Tears" | "He Would if He Could" | "An Old Fool Worse than Any" | "He Would if He Could or An Old Fool Worse than Any" | "The Wedding Ring" | "The Deserter" | "The Deserter" | "The Humours of the Navy" | "A Christmas Tale" | "The Waterman" | "The First of August" | "The Waterman" | "The Waterman or The First of August" | "The Quaker" | "The Seraglio" | "Poor Vulcan" | "The Gipsies" | "The Wives Revenged" | "Rose and Colin" | "Rose And Colin" | "Annette and Lubin" | "Annette And Lubin" | "The Medley" | "Harlequin At All" | "The Medley or Harlequin At All" | "The Touchstone" | "Harlequin Traveller" | "The Touchstone" | "The Touchstone or Harlequin Traveller" | "The Chelsea Pensioner" | "Plymouth in an Uproar" | "Plymouth In An Uproar" | "The Mirror" | "Harlequin Every where" | "The Mirror or Harlequin Every where" | "The Shepherdess of the Alps" | "The Shepherdess Of The Alps" | "The Islanders" | "Harlequin Free Mason" | "The Marriage Act" | "Jupiter and Alcmena" | "None Are So Blind as Those Who Wont See" | "None are so Blind as Those Who Wont See" | "Liberty Hall" | "The Test of Good Fellowship" | "Liberty Hall or The Test of Good Fellowship" | "Harvest Home" | "A Divertisement" | "A Cure for a Coxcomb" | "The Beau Bedevild" | "A Cure for a Coxcomb" | "The Beau Bedeviled" | "A Cure for a Coxcomb or The Beau Bedevild" | "A Loyal Effusion" | "A LOYAL EFFUSION" | "Hannah Hewit" | "The Female Crusoe" | "Hannah Hewit Or The Female Crusoe")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION