Analyse posts by standard tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Biblical Hermeneutics Meta

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

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 main site
loading Hold tight while we fetch your results