1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT 
ts.SourceTagName AS [TagName],
ts.TargetTagName AS [TagName],
t2.Count,
* 
FROM TagSynonyms ts LEFT OUTER JOIN Tags t ON t.TagName=ts.TargetTagName
INNER JOIN Tags t2 ON t2.TagName=ts.SourceTagName
WHERE t.Id IS NULL

fork query

created jul 1 Martin20528