|
|
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
Navigation:
[Reply to this message]
|