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

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 
  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
WHERE TagTotals.TagName LIKE '%javascript'
GROUP BY TagTotals.TagName
ORDER BY Total DESC;

Enter Parameters

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