SELECT TOP 10000 TagTotals.TagName, Sum(TagTotals.Count) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT TOP 10000
  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