SELECT TOP 1000 TagTotals.TagName, Sum(TagTotals.Count) A...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

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