shutterstock

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT TOP 1000
  TagTotals.TagName,
  Sum(TagTotals.Count) AS Total

FROM(
  SELECT
    TagSynonyms.TargetTagName as TagName,
    Tags.Count
  FROM
    Tags
      INNER JOIN
    TagSynonyms ON (
      Tags.TagName = TagSynonyms.SourceTagName
    )

  UNION ALL

  SELECT
    Tags.TagName,
    Tags.Count
  FROM
    Tags
      LEFT JOIN
    TagSynonyms ON (
      Tags.TagName = TagSynonyms.SourceTagName
    )
  WHERE
    TagSynonyms.SourceTagName IS NULL
  ) as TagTotals

GROUP BY TagTotals.TagName
ORDER BY Total DESC;

Enter Parameters

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