Select tag name, tag synonyms, post excerpt and post wiki body of stackoverflow tags.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Data Science

Q&A for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

SELECT DISTINCT t.Id,
  t.TagName,
  string_agg(syn.SourceTagName, ','),
  e.body AS 'Excerpt',
  w.body AS 'WikiBody'
FROM tags t
LEFT JOIN TagSynonyms syn
  ON syn.TargetTagName = t.TagName
LEFT JOIN Posts e
  ON t.ExcerptPostId = e.Id
LEFT JOIN Posts w
  ON t.WikiPostId = w.Id
GROUP BY t.Id, t.tagName, e.body, w.body
ORDER BY t.tagName, t.Id

Enter Parameters

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