0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited may 31 19

created may 31 19 rene