1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT a.Id AS [Post Link], a.Score, a.CreationDate,
  CASE WHEN a.Score < 1            THEN 'Score too low'
       WHEN e.CreationDate IS NULL THEN 'No edit within 12 hours'
                                   ELSE 'Question closed'
  END AS 'Why no Illuminator'
  FROM Posts AS q
  INNER JOIN Posts AS a
    ON a.ParentId = q.Id
   AND a.CreationDate < q.ClosedDate
  OUTER APPLY (
    SELECT TOP 1 CreationDate
      FROM PostHistory AS h
      WHERE h.PostId = q.Id
        AND h.PostHistoryTypeId IN (4, 5) -- Edit Title, Edit Body
        AND h.CreationDate BETWEEN DATEADD(HOUR, -12, a.CreationDate)
                          AND DATEADD(HOUR, 12, a.CreationDate)
        AND h.UserId = a.OwnerUserId
  ) e
  WHERE a.OwnerUserId = ##UserId:int##
  ORDER BY a.CreationDate DESC

fork query

edited aug 18 Glorfindel

created aug 17 anonymous