Using data explorer, I'd like to explore, out of questions with tag1 but not with tag2, what tags are the most common.
For example, "What tags are associated with non-Rails Ruby questions?". I'm trying to look after the tagging of Ruby questions, but I was wondering which tag I should use for a certain question, and knowing what the most common tags are would help with that.
Edit: A query that lacks the ability to exclude tag2 is https://data.stackexchange.com/stackoverflow/s/1553/tags-that-are-used-together-manual-edition
SELECT TOP 1000 t2.TagName AS [Used Together With], COUNT(pt1.PostId) AS [Post Count] FROM PostTags pt1 JOIN PostTags pt2 ON pt1.PostId = pt2.PostId JOIN Tags t1 ON t1.TagName LIKE ##TagName:string## AND t1.Id = pt1.TagId JOIN Tags t2 ON t2.Id = pt2.TagId WHERE t1.TagName <> t2.TagName GROUP BY t1.TagName, t2.TagName ORDER BY COUNT(pt1.PostId) DESC