SELECT pp.MentionsSOBlog , SUM(case when v.votetyp...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about Stack Overflow, Server Fault and Super User

        SELECT  pp.MentionsSOBlog
        ,       SUM(case when v.votetypeid = 2 then 10
                         when v.votetypeid = 3 then -2
                         else null 
                    end) / COUNT(distinct pp.id) AS RepGain
        FROM    tags t
        JOIN    posttags pt
        ON      pt.tagid = t.id
        JOIN    (
                select  *
                ,       case when body like '%blog.stackoverflow.com%' then 1 
                             else 0 
                        end as MentionsSOBlog
                from    posts
                ) pp
        ON      pp.id = pt.postid
        JOIN    posts pa
        ON      pa.parentid = pp.id
        JOIN    votes v
        ON      v.postid = pa.id
        WHERE   t.tagname = 'discussion'
        GROUP BY 
                pp.MentionsSOBlog

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached