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' OR TagTotals.TagName LIKE 'node.js'
OR TagTotals.TagName LIKE 'curl' OR TagTotals.TagName LIKE 'php' 
OR TagTotals.TagName LIKE 'c#' OR TagTotals.TagName LIKE 'java' 
OR TagTotals.TagName LIKE 'python' OR TagTotals.TagName LIKE '%ruby%'
OR TagTotals.TagName LIKE 'go' OR TagTotals.TagName LIKE 'swift' OR TagTotals.TagName LIKE 'kotlin'
GROUP BY TagTotals.TagName 
ORDER BY Total DESC;

Enter Parameters

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