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 COUNT(a.Id) 

FROM Posts a

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

Enter Parameters

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