optimizar consulta

[masterpuppet]

Me refiero a algo así:

Código SQL:

SELECT t1.id, COUNT(t1.id) AS total
FROM tabla t1
LEFT JOIN tabla t2 ON(t1.id = t2.parent)
GROUP BY t1.id
ORDER BY total DESC
 

Nota: parent seria tu idPrev