From: Krzysztof Naworyta on
Juzer Krzysztof Naworyta <k.naworyta(a)> napisa�

| I have not tested this and I don't know which query will be faster for
| relatively large tables (mine with subquery or yours with join and group
| by)
| And which pivot-query based on those two querys will be faster?

I've tested it and can say that your grouping query with join is very much