The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT *
FROM london_stages
WHERE MATCH('(@(perftitleclean,performancetitle) "Caernarvon Castle"/1)')
GROUP BY eventid
ORDER BY weight() desc, eventdate asc
OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount