Q&A about the site for students and teachers of all martial arts
select * from PostTags pt left join ( select distinct t.Id ,t.TagName from Tags as t left outer join TagSynonyms as ts on t.TagName = ts.TargetTagName or t.TagName = ts.SourceTagName where t.TagName like '%snowflake%' or t.TagName like '%airflow%' or ts.SourceTagName like '%snowflake%' or ts.TargetTagName like '%snowflake%' or ts.SourceTagName like '%airflow%' or ts.TargetTagName like '%airflow%' ) as tags on tags.id = pt.TagId