Q&A for users and developers of the Cardano cryptocurrency ecosystem
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