SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Thomas and Sally" | "The Sailors Return" | "Thomas and Sally" | "Thomas And Sally" | "Comus" | "LOlimpiade" | "Lolimpiade" | "Harlequin Restord" | "Taste a la Mode" | "Harlequin Restord" | "Harlequin Restord or Taste a la Mode" | "Harlequin Restord" | "The Country Revels" | "Harlequin Restord or The Country Revels" | "Harlequin Restord or The Country Revels" | "May Day" | "The Little Gipsy" | "May Day" | "The Little Gipsey" | "May Day or The Little Gipsy" | "Arthur and Emmeline" | "The Opera of Operas" | "Tom Thumb the Great" | "Love and Glory" | "Love and Glory" | "The Fall of Phaeton With Harlequin a Captive" | "The Fall of Phaeton With Harlequin a Captive" | "An Hospital for Fools" | "The Temple of Dulness" | "with the Humours of Sg Capochio and Sga Dorinna" | "The Picture" | "Cuckold in Conceit" | "The Picture" | "The Sick Lady’s Cure" | "The Picture or Cuckold in Conceit" | "Alfred the Great King of England" | "Alfred The Great King Of England" | "King Pepins Campaign" | "Harlequin Incendiary" | "Colombine Cameron" | "Harlequin Incendiary or Colombine Cameron" | "The She Gallant" | "Once a Lover and always a Lover" | "The She Gallant Or Once A Lover And Always A Lover" | "The Triumph of Peace" | "Henry and Emma" | "The Nut Brown Maid" | "Henry and Emma or The Nut Brown Maid" | "Don Savario" | "Don Saverio" | "The Sheepshearing" | "Florizel and Perdita" | "Eliza" | "Britannia" | "The Sultan" | "Artaxerxes" | "Beauty and Virtue" | "Virtue and Beauty Reconciled" | "The Guardian Outwitted" | "The Country Madcap in London" | "King Arthur" | "The British Worthy" | "The Fairy Prince with the Installation of the Knights of the Garter" | "Squire Badger" | "The Sot" | "Squire Badger" | "The Cooper" | "Elfrida" | "The Rose" | "The Rose" | "The Female Contest" | "Alzuma" | "Achilles in Petticoats" | "Phoebe at Court" | "Phoebe At Court" | "Caractacus")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION