0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

-- Enter Query Title
-- Enter Query Description

SELECT TOP 10 
  p.Title
  , 'http://stackoverflow.com/questions/' + CAST(p.Id AS VARCHAR(10)) AS URL
  , p.Tags
  ,LEFT(p.Body, 200)
  , p.CreationDate --p.LastActivityDate
FROM 
  dbo.Posts p 
    INNER JOIN dbo.Users u 
      ON p.OwnerUserId = u.Id
WHERE 
  p.Tags LIKE '%asp.net-mvc%'
  AND p.CreationDate <= DATEADD(yy, -1, GETDATE())
  AND p.AcceptedAnswerId IS NULL 
  AND p.AnswerCount </*=*/ 1 
  AND p.CommentCount <= 1
  AND p.ClosedDate IS NULL
  AND u.Reputation >= 100
ORDER BY p.CreationDate

view current version

edited may 13 14

created may 13 14 Jamie.Gaines