Q&A for ebook publishers and readers
SELECT TargetTagName AS MainTag , TagName as TagName , Tags.Id as TagId FROM Tags LEFT JOIN TagSynonyms ON SourceTagName=TagName