Highest Scoring Solo Question Askers

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

SELECT  *
  FROM  Users u
    INNER JOIN  (
                SELECT  u.Id
                  FROM  Users u
                    INNER JOIN (
                                SELECT  p.OwnerUserId
                                  FROM  Posts p
                                  GROUP BY p.OwnerUserId
                                  HAVING COUNT(*) = 1
                               ) a ON a.OwnerUserId = u.Id
                  WHERE Reputation > 10000
                ) a ON a.Id = u.Id
    INNER JOIN Posts p ON p.OwnerUserId = u.Id AND p.PostTypeId = 1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results