Worst Acceptors


Please login or register to vote for this query.

(click on this box to dismiss)

List of users ranked by worst rate of accepting an answer on their own questions with answers.

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

  u.Id AS [UserId],
  CONCAT('site://u/', u.Id, '|', u.DisplayName) AS [User Display Name],
  COUNT(p.Id) AS [Answered Question Count],
  COUNT(CASE WHEN p.AcceptedAnswerId IS NOT NULL THEN 1 ELSE NULL END) AS [Accepted Answers],
  COUNT(P.AcceptedAnswerId) / (COUNT(*) * 1.) AS [%Accept Rate]
FROM Posts p
JOIN Users u ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 1 -- Question
  AND p.AnswerCount > 0 -- Questions with > 0 answer
GROUP BY p.OwnerUserId, u.DisplayName, u.Id
HAVING COUNT(p.Id) >= ##QCount:int?10##
ORDER BY COUNT(P.AcceptedAnswerId) / (COUNT(*) * 1.), COUNT(p.Id) DESC

-- QCount: Minumum Answered Questions:

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results