2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

-- Copy Editor progress (including tags and about me)
-- Source of info:
-- http://meta.stackoverflow.com/questions/67397/list-of-all-badges-with-full-descriptions

declare @UserId int = ##UserId##

select
( -- No of valid tag edits
    select
        count(distinct t.TagName)
    from
        Tags t
    join
        Posts p on p.Id = WikiPostId or p.Id = ExcerptPostId
    where
        p.LastEditorUserId = @UserId
)
    
+

( -- No of valid post edits
    select 
        count(distinct ph.PostId)
    from   
        PostHistory ph
    join   
        Posts p on p.Id = ph.PostId and p.OwnerUserId <> @UserId
    where  
        ph.UserId = @UserId
        and    
        ph.PostHistoryTypeId between 4 and 5 -- edit title, body
)

+

(
    select
        count(distinct u.AboutMe)
    from
        Users u
    where
        u.Id = @UserId
    and
        u.AboutMe != ''
)

fork query

edited nov 28 12

created nov 28 12 Benny Skogberg