Listo lo solucione, si ah alguien le sirve
Código SQL:
Ver originalSELECT dle_post.id, dle_post.title, dle_post.DATE, id_post, COUNT(id_post) AS total
FROM dle_post, dle_thanks
WHERE dle_post.id = dle_thanks.id_post
GROUP BY id_post
ORDER BY total DESC LIMIT 0,30
