SELECT SQL_CALC_FOUND_ROWS parent.catID,parent.lft,parent.rgt,parent.category_name, COUNT( sellable_products.prodID ) as related_count FROM product_categories AS node, product_categories AS parent, sellable_products WHERE (node.lft BETWEEN parent.lft AND parent.rgt) AND node.catID = sellable_products.catID GROUP BY parent.catID ORDER BY parent.lft