How close am I to Explainer/ Refiner/ Illuminator

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Users.Id as [User Link]

FROM Posts
JOIN Users
  ON Posts.OwnerUserId = Users.Id

WHERE Posts.PostTypeId = 2 
  AND Posts.OwnerUserId = Users.Id
  AND Posts.Score > 0
  AND EXISTS (
    SELECT Id FROM PostHistory 
    WHERE PostHistory.PostId = Posts.ParentId 
      AND PostHistory.UserId = Users.Id
      AND PostHistory.CreationDate < DATEADD(hour, 12, Posts.CreationDate)
      AND PostHistory.CreationDate > DATEADD(hour, -12, Posts.CreationDate)
      )

Enter Parameters

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