1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

----bronze badge: a total score of 100 in at least 20 non-community wiki answers to achieve this badge.
----silver badge: a total score of 400 in at least 80 non-community wiki answers to achieve this badge.
----gold badge: a total score of 1000 in at least 200 non-community wiki answers to achieve this badge.

; with scorestags_cte AS
(SELECT
  pt.TagId AS TagId,
  p.OwnerUserId AS uid,
  p.OwnerDisplayname AS udn,
  SUM (p.SCORE) as sco,
  COUNT (p.Id) as num
FROM Posts p INNER JOIN Posts q
  ON q.Id = p.ParentId
  INNER JOIN PostTags pt ON q.Id=pt.PostId
WHERE (p.CommunityOwnedDate IS NULL)
---only non-CW
GROUP BY pt.TagId, p.OwnerUserId, p.OwnerDisplayname
)

SELECT
  t.tagname,
  s.uid As [User Link], s.udn,
  s.sco AS [Score],
  s.num AS [Count]
FROM scorestags_cte s INNER JOIN Tags t on s.TagId=t.Id
WHERE (s.sco>=##minsco?100##) AND (s.num<##mincount?20##)
  AND (t.tagname=##tagname:string?set-theory##)
---only for one specific tag  
ORDER BY s.sco DESC

fork query

created may 1 Martin20528