Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles
SELECT p.Id, v.postid AS [Post Link], p.Score, p.viewCount, p.AnswerCount, p.title, t.tagName, p.creationDate FROM Posts p INNER JOIN votes v on p.Id=v.postid INNER JOIN PostTags pt ON pt.PostId = p.Id INNER JOIN Tags t ON t.Id = pt.TagId WHERE ( t.TagName = 'jax' ) /* and p.AnswerCount = 0 */ and p.creationDate > '2019-01-01' /* and p.Score > 0 */ GROUP BY p.Id, p.title,p.AnswerCount, p.CreationDate, p.Score, p.Tags, t.TagName, v.postid, p.viewcount ORDER BY p.CreationDate DESC