SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Prisoner" | "Ozmyn and Daraxa" | "The Mariners" | "Caernarvon Castle" | "The Birth of the Prince of Wales" | "Caernarvon Castle or The Birth of the Prince of Wales" | "The Adopted Child" | "The Poor Sailor" | "Little Ben and Little Bob" | "The Poor Sailor or Little Ben and Little Bob" | "The Smugglers" | "The Fairy Festival" | "The Irish Tar" | "Which is the Girl" | "The Irish Tar or Which is the Girl" | "Britains Brave Tars" | "All for St Pauls" | "Britains Brave Tars" | "A Devil of a Lover" | "Reformed in Time" | "A Day at Rome" | "The Mouth of the Nile" | "Albert and Adelaide" | "The Victim of Constancy" | "Albert and Adelaide or The Victim of Constancy" | "The Magic Oak" | "Harlequin Woodcutter" | "The Magic Oak or Harlequin Woodcutter" | "The Old Cloathsman" | "The Old Clothesman" | "The Castle of Sorrento" | "The Red Cross Knights" | "True Friends" | "St Davids Day" | "The Hermione" | "Valours Triumph" | "The Hermione" | "The Hermione or Valours Triumph")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION