sto uscendo di testa cercando di capire dov'è l'errore di sintassi (riga 7: ON p.userid = c.user_id )
codice:SELECT pts.userid, pts.points, com.value FROM (SELECT c.value, MAX(p.points) AS max_pts FROM k6l0c_community_fields_values AS c WHERE c.value=16 INNER JOIN k6l0c_alpha_userpoints AS p ON p.userid = c.user_id INNER JOIN k6l0c_user_usergroup_map AS grp ON c.user_id = grp.user_id WHERE grp.group_id = 2 GROUP BY c.value ) AS sub INNER JOIN k6l0c_community_fields_values AS com ON com.value = sub.value INNER JOIN k6l0c_alpha_userpoints AS pts ON pts.points = sub.max_pts AND pts.userid = com.id INNER JOIN k6l0c_users AS usr ON usr.id = pts.userid WHERE com.value!='' AND pts.points >0 ORDER BY pts.points DESC


Rispondi quotando