0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 29

created nov 29 anonymous