Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization
SELECT COUNT(*) [Limited Score], p.score [Answer Score], p2.score [Question Score], p.id [Post Link], p.owneruserid [User Link] FROM votes v, posts p, posts p2 WHERE v.voteTypeId = 2 -- only look at upvotes AND v.postid = p.id AND p.parentid = p2.id AND v.creationDate - p2.creationDate < ##DaysThreshhold:int?14## --only count votes within two weeks of post AND p.parentid NOT IN (1337 -- jokes ,726 -- quotes ,423 -- cartoons ,5115 -- statisticians ,23779 -- paradoxes ) GROUP BY p.id, p.owneruserid, p.score, p2.score HAVING COUNT(*) > ##ScoreThreshhold:int?8## -- "immediate" score threshhold ORDER BY COUNT(*) desc