« first day (1153 days earlier)      last day (946 days later) » 

blackgreen
blackgreen
8:37 AM
Hello, I'm trying to write a SEDE query. Can someone help me review it?
 
tripleee
tripleee
probably have patience until @rene arrives (-: but go ahead and ask
 
blackgreen
blackgreen
@tripleee thanks!
 
Ryan M
Ryan M
@blackgreen but also see dontasktoask.com (which is to say: just ask your question)
 
blackgreen
blackgreen
it runs and it gives some results. I would like to double check it for correctness
(and possibly improve it)
the query is supposed to find a user's answers that have been upvoted after N days from posting
 
Ryan M
Ryan M
Nitpick: the N in the title is hardcoded to 3 ;-)
 
blackgreen
blackgreen
8:43 AM
I know, the query is just a first try, I will parametrize it :)
ok done
 
tripleee
tripleee
it's looking decent, but I'm no SQL person
do you want upvoted at any time after N days, or first upvote after N days? it seems to do the former, which to my mind is less useful
if you have answers with more than a few upvotes, they will almost certainly show up
 
blackgreen
blackgreen
now that I think of it, "first upvote after N days" seems more useful
let me explain
 
Ryan M
Ryan M
So one small correctness issue: the times on votes are truncated to the date only. So if I type in 0 and my user ID, I get 148 instead of every answer of mine that's been upvoted (which seems to be 261, based on setting the days to -1).
 
blackgreen
blackgreen
my assumption is that:
1. upvotes that come in within the first 1-3 days are those from tag watchers, which speak for the general correctness of the answer but not necessarily its usefulness to the broader audience
2. it follows that posts that are upvoted after a while are those that are actually useful to other people, because they have been discovered independently
(I'm not looking to validate this assumption, just to explain what kind of question the SEDE query is supposed to solve)
ultimately I want to use this query to know which answers of mine are more worth to maintain
but actually you're welcome to critique the assumption as well
 
tripleee
tripleee
9:14 AM
I would argue that upvotes within the first day are equally likely to be noise coming from the OP or other low-rep users who upvote things they learned something from, regardless of whether they are correct and/or original
 
blackgreen
blackgreen
fair enough
 
 
9 hours later…
rene
rene
6:17 PM
 

« first day (1153 days earlier)      last day (946 days later) »