https://stackapps.com/questions/6483/list-recent-tag-wiki-edits
Q&A for science fiction and fantasy enthusiasts
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 , case when coalesce(w.lasteditdate, e.lasteditdate) = coalesce(w.creationdate, e.creationdate) then ' (new)' else '' 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