List recent tag wiki edits


Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results