Tag synonyms where both tags are non-existent

1

Please login or register to vote for this query.

(click on this box to dismiss)

Economics

Q&A for those who study, teach, research and apply economics and econometrics

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results