0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast 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

fork query

edited feb 10 12

created feb 10 12 conradfrix