Posted by strawberry on 03/31/06 20:55

OK, strange one today -

The following query works perfectly on the command line (122 rows 0.03
sec), but returns 'Projects' as, for instance, '[BLOB - 4 Bytes]' when
issued in phpmyadmin.

This only occurs when I try to reorder the results (as shown in the
penultimate line)

Can anyone tell me how to get this query to work properly in
phpmyadmin?

SELECT client_name, COUNT( * ) AS cnt, GROUP_CONCAT(
projects.project_no
ORDER BY projects.project_no
SEPARATOR ', ' ) AS Projects
FROM projects_contacts
LEFT JOIN clients ON clients.client_id = projects_contacts.client_id
LEFT JOIN projects ON projects.project_id =
projects_contacts.project_id
GROUP BY projects_contacts.client_id
ORDER BY cnt DESC
LIMIT 0 , 300

Cheers

[Back to original message]