Number of questions that a given user has answered and edited as per the specifications of the Explainer, Refiner, and Illuminator badges.
Q&A for people looking to bypass life's everyday problems with simple tricks
with answer_edits as ( select UserId, PostId from Posts q join PostHistory on PostId = q.Id join Posts a on a.ParentId = q.Id and q.OwnerUserId <> a.OwnerUserId and UserId = a.OwnerUserId where PostHistoryTypeId in (4, 5, 6) -- Edit title, body, or tags and q.PostTypeId = 1 and a.PostTypeId = 2 group by UserId, PostId ) select PostId as [Post Link] from answer_edits where UserId = ##UserId##