Low rep users with a lot of questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT
  sub.NumQuestions,
  sub.Uid as [User Link],
  sub.Reputation
FROM (
  select
    count(u.id) as NumQuestions,
    p.OwnerUserId as Uid,
    u.Reputation, u.DisplayName
  from Posts p left join
       Users u
       on u.Id = p.OwnerUserId 
  where 
    p.PostTypeId = 1
    AND u.Reputation < ##RepThreshold?50##
  group by p.OwnerUserId, u.Reputation, u.DisplayName 
) sub
WHERE
  NumQuestions > ##NumQuestionsThreshold?20##

Enter Parameters

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