List recent tag wiki edits

Question

I would like to list tags where the tag wiki or tag wiki excerpt was recently edited or created. How can I do this?

It is not a problem if I get a few false positives by tags modified in other ways, such as merged or renamed, because those events are very rare and can be filtered afterwards.

The api documented at http://api.stackexchange.com/docs/tags (as of v2.2) can list all tags. It, however, doesn't seem to offer a way to sort by latest modification of the tag (as opposed to latest activity of questions with that tag). http://api.stackexchange.com/docs/wikis-by-tags can query the tag wiki contents and excerpt and the last edit time of these, which I can run on any candidates listed to verify that the tag wiki was indeed edited.

Answer 1

While this isn't possible with the API, it is possible with SEDE, if you allow for up to 7 days of lag.

Here is the SEDE Query that lists Tag wiki and excerpts in descending edit date order:

select t.id
     , t.tagname 
     , concat('site://tags/'
     , tagname
     , '/info'
     , '|'
     , case 
       when w.lasteditdate > e.lasteditdate 
       then ' Wiki'
       when w.lasteditdate = e.lasteditdate 
       then ' both'
       else ' Excerpt'
       end
     ) [Edited]
     , w.lasteditdate [Wiki Edit]
     , e.lasteditdate [Excerpt Edit] 
from tags t
left outer join posts w on w.id = t.wikipostid
left outer join posts e on e.id = t.excerptpostid
where w.id is not null 
or    e.id is not null
order by coalesce(w.lasteditdate,  e.lasteditdate) desc

When run today, this is what your result might look like:

Keep in mind SEDE is update once a week, on Sunday morning 03:00 UTC. If you're new to SEDE give the awesome tutorial a try and say "Hi" in chat.