Q&A about the site for administrators, end users, developers and designers for Craft CMS
DECLARE @Tag nvarchar(25) = 'geotools'; SELECT Posts.Id AS [Post Link], Posts.Title, Posts.Body FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.Id = PostTags.PostId WHERE Tags.TagName = @Tag AND Posts.PostTypeId = 1 -- Questions ORDER BY Posts.CreationDate DESC