Return to Answer

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click the button Run Query. The query results are shown immediately.
   If the query isn't cached, there is no option to run the query with just following a link. In this case the button Run Query need to be clicked. Anonymous users also need to solve the reCaptcha before they run a non-cached query.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click the button Run Query. The query results are shown immediately.
   If the query isn't cached, there is no option to run the query with just following a link. In this case the button Run Query need to be clicked. Anonymous users also need to solve the reCaptcha before they run a non-cached query.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click run query.
   If the query isn't cached, there is no option to run the query with just following a link. Anonymous users also need to solve the reCaptcha before they run a non-cached query.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click the button Run Query. The query results are shown immediately.
   If the query isn't cached, there is no option to run the query with just following a link. In this case the button Run Query need to be clicked. Anonymous users also need to solve the reCaptcha before they run a non-cached query.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click run query. There is no option to have a query be run with only a link. Anonymous users need to solve the reCaptcha as well to prevent abuse.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here

1. Query Results with the same parameters are cached for a week. In those cases you don't need to click run query.
   If the query isn't cached, there is no option to run the query with just following a link. Anonymous users also need to solve the reCaptcha before they run a non-cached query.

2. You need to query the votes tables (votetypes 1 (accept), 2 (up-mod), 3 (down-mod) and 9 (bounty) are of interest.

This query will probably do it:

    select sum(case v.votetypeid
            when 1 then 15 -- accepted
            when 2 then 10 -- up vote
            when 3 then -2 -- down vote
            when 9 then v.bountyamount -- bounty earned
            else 0
            end
            ) [answer rep]
    from posts p 
    inner join votes v on v.postid = p.id
    where posttypeid = 2 -- Answers
    and p.owneruserid = ##user?int:2377343##
    and p.communityowneddate is null -- only non community wiki answers
    and v.votetypeid in (1,2,3,9) 

3. That is not possible at the moment but there have been feature requests that ask for the same feature to be added, for example here and here