sono arrivato ad una soluzione molto simile
ugualmente corretta?codice:SELECT c.user_id,c.value, MAX( p.points ) AS max_ptsFROM fields_values AS c INNER JOIN points AS p ON p.userid = c.user_id WHERE c.field_id =16 GROUP BY c.value ORDER BY p.points DESC