SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Tragedy of Nero Emperour of Rome" | "The Tragedy of Nero" | "The Tragedy Of Nero Emperour Of Rome" | "Sophonisba" | "Hannibals Overthrow" | "Sophonisba" | "Sophonisba Or Hannibals Overthrow" | "Gloriana" | "the Court of Augustus Caesar" | "Gloriana Or The Court Of Augustus Caesar" | "The Rival Queens" | "The Death of Alexander the Great" | "The Rival Queens" | "The Rival Queens Or The Death Of Alexander The Great" | "Mithridates King of Pontus" | "Mithridates" | "Mithridates King Of Pontus" | "Oedipus" | "Caesar Borgia Son of Pope Alexander the Sixth" | "Caesar Borgia" | "Caesar Borgia Son Of Pope Alexander The Sixth" | "The Princess of Cleve" | "The Princess Of Cleve" | "Theodosius" | "The Force of Love" | "Theodosius" | "Theodosius Or The Force Of Love" | "Lucius Junius Brutus Father of His Country" | "Lucius Junius Brutus" | "Lucius Junius Brutus Father Of His Country" | "Oedipus King of Thebes" | "Oedipus King Of Thebes" | "The Duke of Guise" | "The Duke Of Guise" | "Constantine the Great" | "Constantine The Great" | "The Massacre of Paris" | "The Massacre Of Paris" | "The Duke of Guise" | "The Massacre of Paris" | "The Duke Of Guise Or The Massacre Of Paris" | "Alexander" | "The Patriot or The Italian Conspiracy" | "The Patriot" | "The Italian Conspiracy" | "The Patriot Or The Italian Conspiracy" | "Junius Brutus" | "Junius Brutus" | "Alexander the Great")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION