0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT TOP 10
       TagUsers.UserLink AS [User Link],
       TagUsers.Score AS Score,
       TagUsers.[Count] AS [Count],
       (TagUsers.Score + TagUsers.[Count]) / 2 AS Total
FROM
(
    SELECT a.OwnerUserId AS UserLink,
           SUM(a.Score) AS Score,
           COUNT(a.Score) AS [Count]
    FROM Posts a, 
         Posts q
         INNER JOIN PostTags qt ON q.Id = qt.PostId
         INNER JOIN Tags t ON t.Id = qt.TagId
    WHERE a.ParentId = q.Id
      AND a.PostTypeId = 2
      AND a.CommunityOwnedDate IS NULL
      AND t.TagName = '##tagName##'
    GROUP BY a.OwnerUserId
) TagUsers
ORDER BY (TagUsers.Score + TagUsers.[Count]) / 2 DESC

view current version

edited oct 10 18

created jan 9 18 anonymous