SELECT TOP 100 q.Id AS [Post Link], q.Title, q.Score AS V...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tor

Q&A for researchers, developers, and users of Tor

SELECT TOP 100
    q.Id AS [Post Link],
    q.Title,
    q.Score AS Votes,
    q.ViewCount AS Views,
    q.AnswerCount AS Answers,
    q.CreationDate,
    u.DisplayName AS [User Link]
FROM 
    Posts q
INNER JOIN 
    Users u ON q.OwnerUserId = u.Id
INNER JOIN 
    PostTags pt ON q.Id = pt.PostId
INNER JOIN 
    Tags t ON pt.TagId = t.Id
WHERE 
    q.PostTypeId = 1  -- 1 for Questions
    AND t.TagName IN ('javascript', 'js')
GROUP BY
    q.Id, q.Title, q.Score, q.ViewCount, q.AnswerCount, q.CreationDate, u.DisplayName
ORDER BY 
    q.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results