1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

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##

fork query

edited feb 28

created feb 28 General.Grievance