Most effective Fastest Guns in the West (enlightened percentage times quantity)

4

Please login or register to vote for this query.

(click on this box to dismiss)

Top 500 most effective Fastest Guns in the West Enlightened badges weighted against total Accepted answers with score >= 10 Enlightened requires an Accepted Answer with score >= 10, posted first. The higher their number * higher percentage of all accepted answers makes for a very effective Fastest Gun in the West.

Engineering

Q&A for professionals and students of engineering

SELECT TOP 100
  a.OwnerUserId AS [User Link],
  Count(*) AS [Count]
FROM Votes v, Posts q, Posts a
WHERE v.VoteTypeId = 1
  AND v.PostId = a.Id
  AND q.AcceptedAnswerId = a.Id
  AND q.OwnerUserId != a.OwnerUserId
GROUP BY a.OwnerUserId
HAVING Count(*) >= 10
ORDER BY Count(*) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results