Help with a complicated MySQL query

[eluser]megabyte[/eluser]
Solved.

[eluser]Eric Cope[/eluser]
care to post the original problem along with the solution in case others stumble the same way you did?