Q&A for designers and implementers of computer programming languages
SELECT q.Id, q.Title, 'site://q/' + CAST(q.Id AS varchar) as [url], q.Tags, q.CreationDate, q.LastActivityDate FROM Posts q INNER JOIN PostTags pt ON q.Id=pt.PostId INNER JOIN Tags t ON t.id = pt.TagId WHERE t.TagName=##tagName:string?geometry## ORDER BY q.CreationDate DESC