SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Pericles, Prince Of Tyre" | "Pericles" | "Othello" | "Othello, Moor Of Venice" | "The Moore Of Venice" | "The Merry Wives Of Windsor" | "Hamlet" | "Hamlet, Prince Of Denmark" | "Hamlet Prince Of Denmark" | "Twelfth Night" | "Or, What You Will" | "Twelfth Night Or What You Will" | "Romeo And Juliet" | "A Midsummer Night\'s Dream" | "King Lear" | "Henry V" | "King Henry V" | "King Henry The Fifth" | "Henry The Fourth, Part I" | "1 Henry IV" | "I Henry IV" | "The Winters Tale" | "King John" | "Richard II" | "Richard The Second" | "The Two Gentlemen Of Verona" | "The Gentlemen Of Verona" | "Loves Labour Lost" | "The Merchant Of Venice" | "As You Like It" | "Alls Well Yt Ends Well" | "All\'s Well That Ends Well" | "Henry Ye Fourth, Part II" | "2 Henry IV" | "Henry Iv Part Ii" | "Coriolanus" | "Andronicus" | "Julius Caesar" | "Julius Caesar: With The Death Of Brutus And Cassiu" | "Anthony And Cleopatra" | "Antony And Cleopatra" | "The Comedy Of Errors" | "The Comoedy Of Errors" | "Richard III" | "Richard The Third" | "Henry VIII" | "Henry The Eighth" | "Much Ado About Nothing" | "Cymbeline" | "Cimbeline" | "Cimbeline Or The Fatal Wager" | "Measure For Measure" | "The Taming Of The Shrew" | "The Tameing Of Ye Shrew" | "The Tempest" | "Titus Andronicus" | "Troilus And Cressida" | "Macbeth" | "Timon Of Athens")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION