SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Artamene" | "Orpheus and Eurydice" | "La Caduta de Giganti The Fall of the Giants" | "La Caduta de Gigantio" | "The Fall of the Giants" | "Ifigenia in Tauride" | "Ifigenia In Tauride" | "Alceste" | "Il Trionfo dell Amor Conjugale")')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION
Searches not only for performances of plays known to be by this author, but also performances of associated titles, including adaptations.
We recommend searching by last name (for example, instead of 'Dorothy Jordan,' search 'Jordan' to return instances where she is listed as 'Mrs Jordan')
Keyword searches event comments, performance titles, performance comments, roles, actors, and author names.