User List: Most Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT Top ##MaximumNumberOfUsers:int?100##
 U.Id as [User Link], Count(Pt.Id) AS Questions

FROM Users U, Posts P, PostHistory Ph, PostTypes Pt

WHERE
Pt.Id = Ph.PostHistoryTypeId
AND
U.Id = P.OwnerUserId
AND
P.Id = Ph.PostId
AND
Pt.Id = 1

GROUP BY U.Id
HAVING Count(Pt.Id) > ##QuestionsMoreThan:int?900##

ORDER BY Questions DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results