Users with sufficient score and number of answers for a tag badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

----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##)
ORDER BY s.sco DESC

Enter Parameters

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