Ver originalSELECT c.categoria , COUNT(*) productos FROM tbl_categorias c LEFT JOIN tbl_productos p ON c.id = p.id_categoria ORDER BY c.categoriaGROUP BY c.categoria;