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