[MySql] Nested Sets (categorie immediatamente subordinate e numero oggetti in esse)

[|\/|atrix]

Salve,
sono un paio di giorni che sto provando ad unire queste due query (la prima mostra le categorie immediatamente subordinate ad un'altra e la seconda mostra il numero di oggetti in una categoria),
per ottenere la lista delle categorie immediatamente subordinate a "PORTABLE ELECTRONICS" con in più il numero degli oggetti in esse...

SELECT node.name, (COUNT(parent.name) - (sub_tree.depth + 1)) AS depth
FROM nested_category AS node,
    nested_category AS parent,
    nested_category AS sub_parent,
    (
        SELECT node.name, (COUNT(parent.name) - 1) AS depth
        FROM nested_category AS node,
        nested_category AS parent
        WHERE node.lft BETWEEN parent.lft AND parent.rgt
        AND node.name = 'PORTABLE ELECTRONICS'
        GROUP BY node.name
        ORDER BY node.lft
    )AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
    AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
    AND sub_parent.name = sub_tree.name
GROUP BY node.name
HAVING depth <= 1
ORDER BY node.lft; 

SELECT parent.name, COUNT(product.name)
FROM nested_category AS node ,
nested_category AS parent,
product
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.category_id = product.category_id
GROUP BY parent.name
ORDER BY node.lft; 

Ma evidentemente non ci riesco!
Potreste darmi una mano? Le ho provate tutte...

[|\/|atrix]

Nessuna idea?

[|\/|atrix]

up!