I was about to say I thought you might be mistaken because you can always use some variant of "group concat" to get sets of fields to show in comma seperated form...

But then I realized even with that, I couldn't get the output under discussion without subqueries. And I don't consider that a win for me.