SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Virgin Prophetess or the Fate of Troy" | "The Virgin Prophetess" | "The Fate of Troy" | "The Virgin Prophetess Or The Fate Of Troy" | "Cambyses King of Persia" | "Cambyses King Of Persia" | "The Empress of Morocco" | "The Empress Of Morocco" | "Cambyses" | "Love and Revenge" | "Love And Revenge" | "The Conquest of China by the Tartars" | "The Conquest Of China By The Tartars" | "Ibrahim the Illustrious Bassa" | "Ibrahim The Illustrious Bassa" | "Pastor Fido" | "The Faithful Shepherd" | "Pastor Fido" | "Pastor Fido Or The Faithful Shepherd" | "The Female Prelate Being the History of the Life and Death of Pope Joan" | "The Female Prelate" | "Fatal Love" | "The Fored Inconstancy" | "The Ambitious Slave" | "The Heir of Morocco With the Death of Gayland" | "The Heir of Morocco" | "Distressd Innocence" | "The Princess of Persia" | "Distressd Innocence Or The Princess Of Persia" | "The Triumphs of London Performed on Thursday Octob 29 1691 for the Entertainment of the Right Honourable Sir Thomas Stamp Kt" | "Lord Mayor of the City of London" | "The Fairy Queen" | "The New Athenian Comedy" | "The Triumphs of London" | "The Triumphs Of London" | "The Triumphs of London Performed on Monday October 30 1693" | "The Ambitious Slave" | "A Generous Revenge" | "The Ambitious Slave Or A Generous Revenge" | "The Triumphs of London Prepared for the Entertainments of Sir Thomas Lane Knight" | "The Triumphs of London Performed on Tuesday Octob 29 1695" | "Philaster" | "Love Lies a Bleeding" | "Philaster" | "Philaster Or Love Lies A Bleeding" | "The World in the Moon" | "The World In The Moon" | "Glorys Resurrection Being the Triumphs of London Revivd for the Inauguration of the Right Honourable Sir Francis Child Kt Lord Mayor of London" | "The Triumphs of London For the Inauguration of the Right Honourable Sir Richard Levett Kt Lord Mayor of the City of London" | "The City Ramble" | "A Play House Wedding" | "The City Ramble" | "A Playhouse Wedding" | "The City Ramble Or A Playhouse Wedding")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION