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 >= '2020-01-01' AND CreationDate <= '2021-01-01'-- Limit to posts from September 2024 onwards AND Tags LIKE '%react%' AND Tags LIKE '%javascript%' ORDER BY Score DESC;