Q&A for administrators, end users, developers and designers for Craft CMS
SELECT PostTags.PostId, PostTags.TagId, Tags.Id, Posts.CreationDate FROM PostTags JOIN Posts ON PostTags.PostId = Posts.Id JOIN Tags ON PostTags.TagId = Tags.Id WHERE PostTags.TagId NOT IN ( SELECT DISTINCT PostTags.TagId AS OlderTags FROM PostTags JOIN Posts ON PostTags.PostId = Posts.Id WHERE DATEDIFF(DAY, CreationDate, GETDATE()) > 14)