Modificar consulta SQL

[gnzsoloyo]

Bueno, en MySQL no existe el TOP. LIMIT cumple la misma función, es decir: usa LIMIT 10 y listo.

Código MySQL:

SELECT ((sum(ck_rating_up) - sum(ck_rating_down))*2) + (SELECT count(comment_id)AS votos FROM wp_comments WHERE comment_approved = 1)  total, user_id 
FROM wp_comments, wp_ck_karma 
WHERE ck_comment_id = comment_ID 
GROUP BY  user_id
LIMIT 10