Closed low score low view closed more than 3 months - possibly delete

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT
[p].[Title],
'http://programmers.stackexchange.com/questions/' + CONVERT(NVARCHAR, p.Id) + '/' [Link],
[p].[Score],
[p].[ViewCount]
FROM [Posts] [p] (NOLOCK)
JOIN [PostTypes] [pt] (NOLOCK) ON [pt].[Id] = [p].[PostTypeId]
WHERE
  [pt].[Name] = 'Question' AND
  [p].[ClosedDate] IS NOT NULL AND
  [p].[ClosedDate] < DATEADD(MONTH, -##ClosedMonthsAgo##, GETDATE()) AND
  [p].[ViewCount] < ##MaxViewCount:int##
ORDER BY [p].[ClosedDate] ASC

Enter Parameters

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