SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Virgin Prophetess Or The Fate Of Troy" | "The Virgin Prophetess" | "Cambyses, King Of Persia" | "The Empress Of Morocco" | "Cambyses" | "Love And Revenge" | "The Conquest Of China By The Tartars" | "Ibrahim The Illustrious Bassa" | "Ibrahim, The Illustrious Bassa" | "Pastor Fido" | "Or, The Faithful Shepherd" | "Pastor Fido" | "The Female Prelate: Being The History Of The Life And Death Of Pope Joan" | "The Female Prelate" | "Fatal Love" | "Or, The Fore\'d Inconstancy" | "The Ambitious Slave" | "The Heir Of Morocco: With The Death Of Gayland" | "The Heir Of Morocco" | "Distress\'d 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: Performed On Monday October 30, 1693" | "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" | "Or, Love Lies A Bleeding" | "Philaster" | "The World In The Moon" | "Glory\'s Resurrection: Being The Triumphs Of London Reviv\'d 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" | "Or, A Play-House Wedding" | "The City Ramble")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION