Find tags to fix

2

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT
  t.Count,
  t.TagName,
  'http://anime.stackexchange.com/edit-tag-wiki/' + CAST(t.Id AS varchar) AS [Wiki URL],
  e.Body AS [ExcerptBody],
  CASE 
    WHEN LEN(w.Body) > 0 
    THEN 'Yes' 
    ELSE '' END 
    AS [Wiki?],
  CASE 
    WHEN e.LastActivityDate > w.LastActivityDate 
    THEN e.LastActivityDate
    ELSE w.LastActivityDate END
    AS [LastActivityDate]
FROM 
  Tags t
  LEFT OUTER JOIN Posts e
    ON t.ExcerptPostId = e.Id
  LEFT OUTER JOIN Posts w
    ON t.WikiPostId = w.Id
WHERE 
  t.Count >= 6
  --AND t.TagName NOT LIKE '[0-9a-p]%'
ORDER BY 
  t.Count ASC,
  t.TagName ASC
  
-- still need to hit all tags w/ more than 4 questions
-- errata here:       http://meta.anime.stackexchange.com/questions/943/
-- list of tags here: http://meta.anime.stackexchange.com/questions/941/
-- look at: 
  --

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results