0

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 SharePoint enthusiasts

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


select * from (
  SELECT TOP 1000
    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.ParentId = PT.PostId
    INNER JOIN Tags T ON PT.TagId = T.id
  WHERE 
    t.tagName like 'react%'
) 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