SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Pigmy Revels" | "Harlequin Foundling" | "The Pigmy Revels or Harlequin Foundling" | "The Norwood Gypsies" | "The Medley" | "Harlequin At All" | "The Medley or Harlequin At All" | "Harlequin Free Mason" | "The Choice of Harlequin" | "The Indian Chief" | "The Choice of Harlequin or The Indian Chief")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION