0

Please login or register to vote for this query.

(click on this box to dismiss)

This is a list of all answers for a user that count for the Explainer, Refiner and Illuminator badges, sorted by newest answer first.

Q&A about the site for enthusiasts and power users of the Android operating system

select a.Id as [Post Link], a.Score, a.CreationDate
  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 = 0 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 
                 and abs(datediff(hh, ph.CreationDate, a.CreationDate)) < 12)
order by a.CreationDate desc

fork query

edited jul 21 21 toolic

created oct 1 14 Martijn Pieters