Low rep users with a lot of questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT
  sub.NumQuestions,
  sub.Uid as [User Link],
  sub.Reputation,
  sub.CreationDate
FROM (
  select
    count(u.id) as NumQuestions,
    p.OwnerUserId as Uid,
    u.Reputation,
    u.CreationDate
  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.CreationDate 
) sub
WHERE
  NumQuestions > ##NumQuestionsThreshold?20##

Enter Parameters

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