group by bug

Issue Summary

The SQL query does not Support "group by".

I try to get the Terms of a Node and try to use this SQL query:
SELECT *, GROUP_CONCAT(td.name) as term FROM {node} n INNER JOIN {users} u ON u.uid = n.uid INNER JOIN {term_node} t ON t.nid = n.nid INNER JOIN {term_data} td on t.tid = td.tid WHERE n.status=1 group by n.nid

But this query dose not Work.

Jens