0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

SELECT 
  t.tagname AS [TagName],
  t.count AS TagCount
FROM tags t
LEFT JOIN Posts e
  ON t.ExcerptPostId = e.Id
LEFT JOIN tagsynonyms ts
  ON ts.sourcetagname = t.tagname
WHERE e.id IS NULL
  AND ts.id IS NULL
GROUP BY
  t.tagname,
  t.count
ORDER BY t.count DESC

view current version

edited jun 12 19

created jun 12 19 anonymous