Analyse posts by standard tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

SELECT top (100)
  q.Id as PostId, 
  q.PostTypeId,
  q.CreationDate as Created, 
  q.Score as Score, 
  q.Body as Description, 
  q.CommentCount as Comments,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/bug%' THEN 'bug' 
    WHEN q.Body LIKE '%/questions/tagged/support%' THEN 'support' 
    WHEN q.Body LIKE '%/questions/tagged/discussion%' THEN 'discussion' 
    WHEN q.Body LIKE '%/questions/tagged/feature-request%' THEN 'feature-request' 
    ELSE 'no tag'
  END as Tag,
  CASE 
    WHEN q.Body LIKE '%/questions/tagged/status-completed%' THEN 'status-completed' 
    WHEN q.Body LIKE '%/questions/tagged/status-declined%' THEN 'status-declined' 
    WHEN q.Body LIKE '%/questions/tagged/status-review%' THEN 'status-review' 
    WHEN q.Body LIKE '%/questions/tagged/status-bydesign%' THEN 'status-bydesign' 
    ELSE 'no status'
  END as Status
FROM Posts q
ORDER BY q.CreationDate

Enter Parameters

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