query mysql: ordinare il group

[nicola75ss]

Vedi se così va bene.

SELECT id, username, value, COUNT( value ) AS nr, if(username='gino',1,2) as ordine
FROM naw
GROUP BY value ORDER BY ordine,value asc