0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

view current version

edited nov 22 19

created nov 22 19 anonymous