Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT TOP 5 Id AS [Post Link], Title, CreationDate, Score, ViewCount, Tags FROM Posts WHERE PostTypeId = 1 -- Only questions AND CreationDate >= '2024-09-01' -- Limit to posts from September 2024 onwards AND Tags LIKE '%<react>%' ORDER BY Score DESC;