SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "The Little French Lawyer" | "The Beggars Bush" | "Philaster" | "The Loyal Subject" | "The Mad Lover" | "The Maid in the Mill" | "The Maid In The Mill" | "Rule a Wife and Have a Wife" | "Rule A Wife And Have A Wife" | "The Spanish Curate" | "The Tamer Tamed" | "The Womans Prize" | "A Wife for a Month" | "The Wild Goose Chase" | "Wit Without Money" | "Love Lies A Bleeding" | "The Mayds Tragedy" | "The Scornful Lady" | "The Elder Brother" | "The Chances" | "The Humorous Lieutenant" | "Rollo Duke of Normandy" | "The Bloody Brother" | "Rollo Duke Of Normandy" | "The Little Thief" | "The Night Walker or The Merry Beggars" | "Fathers Own Son" | "Monsieur Thomas" | "The Knight of the Burning Pestle" | "The Knight Of The Burning Pestle" | "The Faithful Shepherdess" | "The Maids Tragedy" | "A King and No King" | "A Kinge and No Kinge" | "A Kinge And No Kinge" | "The Night Walker" | "The Little Thief" | "The Night Walkers" | "The Little Thief" | "The Night Walker Or The Little Thief" | "Loves Pilgrimage" | "The Custom of the Country" | "The Custom Of The Country" | "The Storm" | "The Sea Voyage" | "The Wild Goose Chace" | "Love Despised" | "Cupids Revenge" | "The Island Princess" | "The Generous Portuguese" | "The Island Princess" | "The Island Princess Or The Generous Portuguese" | "Women Pleased" | "The Coxcomb" | "Bonduca" | "Custome of ye Country" | "The Captaine" | "The Double Marriage" | "The French Lawyer" | "The False One" | "The Fayre Mayd of ye Inn" | "The Knights of Malta" | "The Lawes of Candye" | "Loves Progresse" | "The Lovers Progress" | "The Wandering Lovers" | "Loues Cure" | "The Martial Maid" | "Loues Pilgramage" | "The Noble Gentlemen" | "The Nice Valour" | "The Passionate Madman" | "The Prophetesse" | "The Pilgrim" | "The Queene of Corinth" | "Valentinian" | "Thiery and Theodorat" | "A Womans Prize" | "The Restoration" | "Right Will Take Place" | "The Restoration Or Right Will Take Place" | "A Commonwealth of Women" | "A Commonwealth Of Women" | "The Spanish Priest" | "A Fools Preferment" | "The Three Dukes of Dunstable" | "A Fools Preferment Or The Three Dukes Of Dunstable" | "The Prophetess" | "The History of Dioclesian" | "The Prophetess" | "The Prophetess Or The History Of Dioclesian" | "Bonduca" | "The British Worthy" | "Bonduca Or The British Worthy" | "Philaster" | "Love Lies a Bleeding" | "Philaster Or Love Lies A Bleeding" | "The Unhappy Kindness" | "A Fruitless Revenge" | "The Unhappy Kindness Or A Fruitless Revenge" | "The Inconstant or The Way to Win Him" | "The Inconstant" | "The Way to Win Him" | "The Inconstant Or The Way To Win Him" | "The Maid of the Mill" | "The Country Revels" | "The Maid of the Mill or The Country Revels" | "The Tamer Tamd" | "The Royal Merchant" | "The Capricious Lady" | "The Knight of Malta" | "The Humorous Dane" | "The Triumph of Honour" | "The Triumph Of Honour" | "The Maid of Honour" | "The Maid Of Honour" | "Women Pleasd" | "King and No King" | "King And No King" | "The Greek Slave" | "The School for Cowards" | "The Greek Slave Or The School For Cowards" | "Four Plays in One")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION