1

Please login or register to vote for this query.

(click on this box to dismiss)

The query is not ready yet.

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT * FROM (
  SELECT TagName AS Name, Count
  FROM Tags

  UNION

  SELECT TagSynonyms.SourceTagName AS Name, Tags.Count
  FROM TagSynonyms, Tags
  WHERE Tags.TagName = TagSynonyms.TargetTagName
) AllTag
ORDER BY Count DESC

view current version

edited mar 31 17

created mar 31 17 peterh