Illuminator without time restriction


Please login or register to vote for this query.

(click on this box to dismiss)

Derived from . What would the count be if the question edit didn't have to be made around the time of the answer?

Stack Overflow

Q&A for professional and enthusiast programmers

select q.*, a.*
  from Posts q 
  join Posts a on a.ParentId = q.Id
 where q.PostTypeId = 1 and 
       q.ClosedDate is null and
       a.PostTypeId = 2 and 
       a.Score >= 1 and 
       a.OwnerUserId = ##UserId## and
       -- exclude self answered
       IsNull(q.OwnerUserId, -1) <> a.OwnerUserId and 
       exists(select 1 
                from PostHistory ph 
               where ph.PostHistoryTypeId in (4,5) 
                 and ph.PostId = a.ParentId 
                 and ph.UserId = a.OwnerUserId)

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results