WITH HighRepUsers AS ( SELECT Id , DisplayName UserName F...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH HighRepUsers AS (
  SELECT Id
       , DisplayName UserName
    FROM Users
   WHERE Reputation > 100000
)
SELECT p.Id, p.PostTypeId, p.OwnerUserId, p.Score, h.UserName, p.Title, p.ParentId FROM Posts p INNER JOIN HighRepUsers h ON p.OwnerUserId = h.Id AND p.Score < 0 AND ClosedDate IS NULL AND PostTypeId IN (1, 2) ORDER BY p.Score, h.Id;

Enter Parameters

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