How do I get a link to send to someone, so even non-logged in users can see the results directly:
...without needing to click "Run Query" or anything?
Is there any way to get reputation from only answers? There is a
reputationcolumn, but I want to exclude the reputation collected from questions.
How can I delete the old queries from my profile, which I no longer need?
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.
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)