optimizar consulta

[masterpuppet]

Si es por el LEFT JOIN, my bad sry, algo asi deberia tirar bien:

Código SQL:

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

Prueba y me comentas.

Saludos.