sono arrivato ad una soluzione molto simile
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
ugualmente corretta?