Don't touch my junk.


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for researchers, developers, and users of Tor

SELECT IsNull(Main.TagName, Alias.TagName) AS MainName
         , IsNull(Main.Id,      Alias.Id     ) AS MainId
         , Alias.TagName as AliasName
         , Alias.Id as AliasId
        FROM Tags as Alias
        LEFT JOIN TagSynonyms 
                ON SourceTagName=Alias.TagName
        LEFT JOIN Tags as Main
                ON TargetTagName=Main.TagName

Enter Parameters

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