[Solved] Complicated MySQL Query (Sets)

[eluser]mddd[/eluser]
Nice. And funny to see that both our solutions are in there. So we both had a pretty good idea
It says in the page that the 'multiple join' solution is more efficient because 'group by / count' takes a temporary table.
Good to know, I think! So we've both learned from this!