Inactive quetsions with score of 1 or higher

0

Please login or register to vote for this query.

(click on this box to dismiss)

This searches for questions that are inactive and have a score of 1 or higher...

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- Inactive quetsions with score of 1 or higher
-- This searches for questions that are inactive and have a score of 1 or higher...

Declare @minScore int = ##MinScore##
declare @ansCount int = ##AnswerCount##

SELECT  
  p.Id AS [Post Link],
  p.LastActivityDate,
  p.Score
  FROM dbo.Posts p

  WHERE p.Score > @minScore AND p.CreationDate <= DATEADD(mm, -2, GETDATE()) AND p.AcceptedAnswerId IS NULL AND p.AnswerCount < 2 
  AND p.ClosedDate IS NULL
  ORDER BY p.LastActivityDate

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results