Unconventional Tag Fusion

1

Please login or register to vote for this query.

(click on this box to dismiss)

Puzzling

Q&A for those who create, solve, and study puzzles

select l.TagName leftTag, r.TagName rightTag, count(q.Id) puzzleCount
from Tags l
inner join Tags r on l.TagName < r.TagName
left outer join Posts q
on q.Tags like '%<' + l.TagName + '>%' and q.Tags like '%<' + r.TagName + '>%'
where l.Count > 100 and r.Count > 100
group by l.TagName, r.TagName
having count(q.Id) < 10
order by puzzleCount asc, leftTag asc, rightTag asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results