Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems
DECLARE @TagId int = ( SELECT t.Id FROM Tags t WHERE t.TagName = ##TagName:string## ) SELECT CONCAT('site://q/', p.Id, '|', p.Title) AS [Post], p.CreationDate, p.Tags FROM PostTags pt JOIN Posts p ON p.Id = pt.PostId WHERE pt.TagId = @TagId GROUP BY pt.TagId, p.Id, p.Title, p.CreationDate, p.Tags HAVING COUNT(pt.TagId) = 1 ORDER BY p.CreationDate DESC