1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Bitcoin crypto-currency enthusiasts

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

fork query

edited mar 25

created mar 25 PeterJames