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
[ruby] -[ruby-on-rails]
? – agf Sep 23 '11 at 4:39