1

Please login or register to vote for this query.

(click on this box to dismiss)

Old low quality questions that are edit fodder

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

-- which posts are older than 6 months
-- and need editing


select top 1000 * from (
  SELECT
    P.Id AS [Post Link], 
    P.CreationDate, 
    P.Score, 
    P.PostTypeID, 
    P.LastEditDate,
    P.LastActivityDate,
    P.ParentId
  FROM Posts P
    INNER JOIN PostTags PT ON P.id = PT.PostId
    INNER JOIN Tags T ON PT.TagId = T.id
  WHERE 
    P.PostTypeId = 1 AND -- question
    T.tagName = 'reactjs' AND
    AnswerCount = 0
) P
 WHERE 
   P.LastEditDate < DATEADD(month, -6, P.LastActivityDate) 
ORDER BY 
  P.Score ASC, 
  P.CreationDate ASC

fork query

edited nov 22 Gabriele.Petrioli40844

created jun 5 11 Marco Ceppi