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