0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

SELECT
    Posts.Id AS [Post Link], 
    Posts.Title, 
    Posts.Score, 
    Posts.CreationDate, 
    Users.DisplayName AS [Author]
FROM Posts
JOIN PostTags ON Posts.Id = PostTags.PostId
JOIN Tags ON PostTags.TagId = Tags.Id
LEFT JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE 
    (Tags.TagName LIKE 'go' OR Tags.TagName LIKE 'golang')
    AND Tags.TagName LIKE 'cryptography'
    AND Posts.PostTypeId = 1 -- Questions only
    AND Posts.CreationDate >= '2018-01-01' -- Only posts created after January 1, 2019
ORDER BY Posts.Score DESC;

view current version

edited dec 13

created dec 13 anonymous