0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

-- Bad question, good answer
SELECT u.displayname
                       , COUNT(*)    
FROM users u, posts p_answ, posts p_ques
WHERE u.id = p_answ.owneruserid
AND p_answ.posttypeid = 2  -- answers only
AND (p_answ.score - p_ques.score)>= ##minimumDifference?4##
AND p_answ.parentid = p_ques.id
AND p_ques.id NOT IN 
(1337 -- jokes
,726  -- quotes
,423  -- cartoons
,5115 -- statisticians
)
AND p_ques.score <= ##maximumScore?5##
--ORDER BY p_ques.score, P_ANSW.SCORE DESC
GROUP BY (u.displayname)

fork query

edited sep 25 23 anonymous

created nov 15 13 David Marx