SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Two Gentleman of Verona" | "Two Gentlemen of Verona" | "Two Gentlemen Of Verona" | "The Tempest" | "A Midsummer Nights Dream" | "Pericles Prince of Tyre" | "Pericles" | "Othello" | "The Moor of Venice" | "The Moore Of Venice" | "The Merry Wives of Windsor" | "The Merry Wives Of Windsor" | "Hamlet" | "Hamlet Prince of Denmark" | "Hamlet Prince Of Denmark" | "Twelfth Night" | "Twelfth Night" | "What You Will" | "The Law Against Lovers" | "Romeo and Juliet" | "Romeo And Juliet" | "Henry VIII" | "Henry Viii" | "King Lear" | "Macbeth" | "Sauny the Scot" | "The Taming of a Shrew" | "The Taming of A Shrew" | "Sauny The Scot Or The Taming Of A Shrew" | "The Tempest" | "The Inchanted Island" | "The Tempest Or The Inchanted Island" | "Henry the Fourth Part I" | "Henry the Fourthe Part I" | "I Henry Iv" | "Henry The Eighth" | "King Henry the Eighth" | "The Winters Tale" | "King John" | "Richard the Second" | "The Gentlemen of Verona" | "The Comoedy of Errors" | "Loves Labour Lost" | "The Merchant of Venice" | "The Merchant Of Venice" | "As You Like It" | "The Tameing of ye Shrew" | "Alls Well yt Ends Well" | "Henry ye Fourth Part II" | "Richard ye Third" | "Coriolanus" | "Andronicus" | "Julius Caesar" | "Julius Caesar With The Death of Brutus and Cassiu" | "Anthony and Cleopatra" | "Cymbelyne" | "The Comedy of Errors" | "The Comedy Of Errors" | "Richard III" | "Richard Iii" | "All for Love" | "The World Well Lost" | "All for Love" | "The World well lost" | "All For Love Or The World Well Lost" | "The History of Timon of Athens the Man Hater" | "Timon of Athens" | "The Man Hater" | "The History Of Timon Of Athens The Man hater" | "Titus Andronicus" | "The Rape of Lavinia" | "Titus Andronicus" | "Titus Andronicus Or The Rape Of Lavinia" | "Troilus and Cressida" | "Truth Found Too Late" | "Troilus and Cressida" | "Troilus And Cressida Or Truth Found Too Late" | "The History and Fall of Caius Marius" | "Caius Marius" | "The History And Fall Of Caius Marius" | "The Sicilian Usurper" | "The History of King Richard the Second" | "The History of King Lear" | "The History Of King Lear" | "Henry the Sixth The First Part With The Murder of Humphrey Duke of Glocester" | "The Misery of Civil War" | "The Misery Of Civil war" | "The Ingratitude of a Common Wealth" | "The Fall of Caius Martius Coriolanus" | "The Ingratitude of a Common Wealth" | "The Ingratitude Of A Common wealth Or The Fall Of Caius Martius Coriolanus" | "The Injured Princess" | "The Fatal Wager" | "The Injured Princess Or The Fatal Wager" | "Much Ado About Nothing" | "Cymbeline" | "Cimbeline" | "The Fatal Wager" | "Cimbeline Or The Fatal Wager" | "The Tragical History of King Richard III" | "The Tragical History of King Richard the Third" | "The Tragical History Of King Richard Iii" | "King Henry the Fourth With the Humours of Sir John Falstaff" | "King Henry the Fourth With the Humours of Sir Joh" | "King Henry The Fourth With The Humours Of Sir John Falstaff" | "Measure for Measure" | "Beauty the Best Advocate" | "Measure For Measure Or Beauty The Best Advocate" | "The Jew of Venice" | "The Jew Of Venice" | "The Comical Gallant or The Amours of Sir John Falstaffe" | "The Comical Gallant" | "The Amours of Sir John Fa" | "Love Betrayd" | "The Agreable Disapointment" | "Love Betrayed" | "The Agreeable Disappointment" | "Love Betrayed Or The Agreeable Disappointment" | "The Invader of His Country or The Fatal Resentment" | "The Invader of his Country" | "The Invader Of His Country" | "The Tragedy of King Richard II" | "King Richard the Second" | "King Richard The Second" | "Measure for Measure" | "Measure For Measure" | "The Taming of the Shrew" | "The Taming Of The Shrew" | "Richard II" | "The Universal Passion" | "The Universal Passion" | "Marina" | "Rosalinda" | "The Conspiracy Discoverd" | "French Policy Defeated" | "The Conspiracy Discovered" | "French Policy Defea" | "The Sheepshearing" | "Florizel and Perdita" | "A Winters Tale" | "Catherine and Petruchio" | "Catharine and Petruchio" | "The Twins" | "A Comedy of Errors" | "The Twins Or A Comedy Of Errors" | "The Fairy Tale" | "A Fairy Tale" | "Timon of Athens" | "Timon Of Athens" | "The Sheep Shearing" | "The Sheep shearing" | "Alls Well that Ends Well" | "Alls Well That Ends Well" | "Coriolanus" | "The Roman Matron" | "Coriolanus Or The Roman Matron" | "Much Ado about Nothing" | "Antony and Cleopatra" | "Troilus And Cressida" | "1 Henry IV" | "1 Henry Iv" | "3 Henry IV")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION