Closed Questions asked by user with the Trusted Privledge

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT 
       u.DisplayName,
       p.id [Post Link], 
       p.CreationDate,
       score, 
       CASE 
         WHEN communityowneddate IS NOT NULL THEN '*' 
         ELSE NULL 
       END  iscommunity ,
       p.ViewCount
       
FROM   posts p 
       INNER JOIN users u 
         ON p.owneruserid = u.id 
WHERE  p.posttypeid = 1 
       AND p.closeddate IS NOT NULL 
       AND u.reputation > 20000 
ORDER BY
      u.DisplayName,
      p.Title

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached