The Think! hat (2017 Winter Bash) is for 6 posts to be edited after leaving a comment. I figured I'd look up to see what posts these were, see if any of my comments were eligible for deletion (as no longer being relevant) to try and get the This is Fine hat.
I'm no good with SEDE (as soon as a database query hits a JOIN I'm lost) and I tried editing a SEDE query that was very similar (one for the Silencium hat).
I got this far:
SELECT a.Id AS [Post Link] FROM Posts AS q INNER JOIN Posts AS a ON a.ParentId = q.Id LEFT OUTER JOIN Comments AS c ON c.PostId = a.Id AND c.CreationDate < a.LastEditDate WHERE a.Score >= 1 AND a.CommentCount > 0 AND a.CreationDate >= '2017-12-13' AND c.UserId = 1663383
I know the following:
- this will only find answers, not questions (or I can change it to find questions and not answers)
- hard coded to my SO user ID (I don't know how to either a. take an input value or b. use the active user's id).
- Only finds 3 of the
comment -> editposts I have on Game Dev (where I have gotten the Think! hat, which is 6 such edits).
- Setting the date to Jan 1 results in several duplicate results (e.g. two or more comments on the same Q/A). This is probably an acceptable flaw.