SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Frenchified Lady Never in Paris" | "The Prince of Agra" | "The Prince Of Agra" | "The Wild Gallant" | "The Indian Queen" | "The Rival Ladies" | "The Indian Emperour" | "the Conquest of Mexico by the Spaniards" | "The Indian Emperor" | "The Conquest of Mexico by" | "The Indian Emperour Or The Conquest Of Mexico By The Spaniards" | "Secret Love" | "The Maiden Queen" | "The Mayden Queene" | "Secret Love Or The Maiden Queen" | "Feignd Innocence" | "Sir Martin Marall" | "The Feignd Innocence" | "Sir Martin Marall" | "Feignd Innocence Or Sir Martin Marall" | "The Indian Emperour" | "The Conquest of Granada by the Spaniards" | "The Indian Emperor" | "The Conquest of Granada by" | "The Indian Emperour Or The Conquest Of Granada By The Spaniards" | "The Tempest" | "The Tempest" | "The Inchanted Island" | "The Tempest Or The Inchanted Island" | "An Evenings Love" | "The Mock Astrologer" | "An Evenings Love" | "Tyrannic Love" | "The Royal Martyr" | "Tyrannic Love Or The Royal Martyr" | "The Conquest of Granada by the Spaniards Part II" | "The Conquest of Granada Part I" | "The Conquest Of Granada Part I" | "Marriage A La Mode" | "The Assignation" | "Love in a Nunnery" | "The Assignation" | "The Assignation Or Love In A Nunnery" | "Amboyna" | "The State of Innocence" | "The Tempest" | "The Enchanted Island" | "The Tempest Or The Enchanted Island" | "Aureng Zebe" | "The Great Mogul" | "Aureng Zebe" | "The Conquest of Granada by the Spaniards" | "The Conquest Of Granada By The Spaniards" | "Tyrannic Love" | "Tyrannick Love" | "All for Love" | "The World Well Lost" | "All for Love" | "The World well lost" | "All For Love Or The World Well Lost" | "The Kind Keeper" | "Mr Limberham" | "The Kind Keeper" | "The Kind Keeper Or Mr Limberham" | "Oedipus" | "Troilus and Cressida" | "Truth Found Too Late" | "Troilus and Cressida" | "Troilus And Cressida Or Truth Found Too Late" | "The Spanish Fryar" | "The Double Discovery" | "The Spanish Fryar" | "The Spanish Fryar Or The Double Discovery" | "Oedipus King of Thebes" | "Oedipus King Of Thebes" | "The Duke of Guise" | "The Duke Of Guise" | "Albion and Alabanius" | "A Song for St Cecilias Day" | "A Song For St Cecilias Day" | "Don Sebastian" | "Amphitryon" | "The Two Sosias" | "Amphitryon" | "Amphitryon Or The Two Sosias" | "King Arthur" | "The British Worthy" | "King Arthur" | "King Arthur Or The British Worthy" | "Cleomenes The Spartan Heroe" | "Cleomenes" | "Love Triumphant" | "Nature will Prevail" | "Love Triumphant Or Nature Will Prevail" | "Don Sebastian King of Portual" | "Marriage à la Mode" | "Alexanders Feast" | "The Power of Musique" | "Alexanders Feast Or The Power Of Musique" | "The Captive" | "Alessandro e Timoteo" | "Alessandro E Timoteo" | "Aureng zebe" | "Alexanders Feast" | "The Husband His Own Cuckold")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION