Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
SELECT t.TagName, t2.TagName, count(*) as cnt FROM posttags pt INNER JOIN tags t ON t.id = pt.tagid LEFT OUTER JOIN posttags pt2 ON pt2.postid = pt.postid LEFT outer join tags t2 ON t2.id = pt2.tagid LEFT join Posts on Posts.Id = pt.PostId WHERE t.tagname in ('backend') and t.tagname <> t2.tagname GROUP BY t.TagName, t2.tagName order by count(*) desc