To get the Illuminator badge, you need to: Edit and answer 500 questions (both actions within 12 hours, answer score > 0).
How can I list the questions that I already edited and answered?
For example:
This shows me just the number, but I want to list these 9 posts.
This query, based on the old one by Martijn Pieters shows all answers which count towards a person's Illuminator badge. (The old query included answers with 0 score as well; those don't count, but might be upvoted in the future – that's probably why they are included. You might be interested in improving those answers so that they attract upvotes.)
For reference, here is the complete query:
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 >= 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
and abs(datediff(hh, ph.CreationDate, a.CreationDate)) < 12)
order by a.CreationDate desc
It comes with the usual disclaimer that SEDE data is updated only once a week, on Sunday morning.
You can find this using the Stack Exchange Data Explorer.
In fact, someone already created a query for all the answers that qualify:
@Glorfindel correctly observed that this query also counts answers with score 0. Of course, this can easily be solved by changing a.Score >= 0 to a.Score > 0.
For this particular case, listing all answers or listing all questions is almost the same. In fact, listing "all answers" is slightly better since you might just have two answers to the same question.
You can use that query, or modify it to list only the relevant questions.
