How to select multiple counts from multiple tables

[eluser]markup2go[/eluser]
I figured it out, I think. Please correct me if I'm doing something wrong.

Code:

$this->db->select('product_sections.*, COUNT(DISTINCT(c.id)) as totalCats, COUNT(DISTINCT(s.id)) as totalSubcats, COUNT(DISTINCT(p.id)) as totalProducts', FALSE);
$this->db->join('product_categories as c', 'product_sections.id = c.section_id', 'left');    
$this->db->join('product_subcategories as s', 's.category_id = c.id', 'left');    
$this->db->join('products as p', 'p.subcategory_id = s.id', 'left');        
$this->db->group_by('product_sections.id');
$this->db->order_by('product_sections.name', 'asc');

And it produces this query:
SELECT product_sections.*, COUNT(DISTINCT(c.id)) as totalCats, COUNT(DISTINCT(s.id)) as totalSubcats, COUNT(DISTINCT(p.id)) as totalProducts
FROM (product_sections)
LEFT JOIN product_categories as c ON product_sections.id = c.section_id
LEFT JOIN product_subcategories as s ON s.category_id = c.id
LEFT JOIN products as p ON p.subcategory_id = s.id
GROUP BY product_sections.id
ORDER BY product_sections.name asc