7

Please login or register to vote for this query.

(click on this box to dismiss)

So I know what needs to be done Like the original query, but displays all top 40 tags, and been extended to include tag popularity numbers/ranks so you can see how close tags are to breaking 200 barrier (if they are short).

Q&A for cartographers, geographers and GIS professionals

-- Generalist Progression
-- So I know what needs to be done

declare @temp table (
    Id int identity(1,1),
    TagName char(128),
    TagRank int,
    TagPopularity int,
    Score int);

with tags40 as (
   select top 40
       ROW_NUMBER() OVER (ORDER BY Count(*) DESC) as rank,
       count(*) as popularity,
       tagid
   from posttags
   group by tagid
   order by count(*) desc
),

answers as (
  select score, id, parentId from posts  -- find responses of questions
  where communityowneddate is null   -- which are non-comm-wiki
  and posttypeid = 2                 -- answers
  and owneruserid = ##UserId:int##       -- by you
)

insert @temp(TagName, TagRank, TagPopularity, Score) 
select t.TagName, f.rank, f.popularity, sum(a.score) as Score 
from answers a
inner join posttags pt on pt.postid = a.parentId -- find tags of your answers
right join tags40 f on f.tagid = pt.tagid        -- which are one of the top 40s
inner join tags t on f.tagid = t.id
group by t.tagname, f.rank, f.popularity
order by score desc

select *, case when score >= 15 then '' else '!' end from @temp

fork query

edited feb 11 14 rolfl

created may 23 10 anonymous