0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for passionate videogamers on all platforms

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

fork query

edited dec 13

created dec 13 anonymous