How to get correct Number of Comments (with 4 connected tables: Art./Cat./Users/Comm.)

[eluser]sigork[/eluser]
[quote author="sigork" date="1248032105"]Is there any obvious problem/error in my code, or how to debug this code?

Thanks![/quote]

I think I found the problem:

Code:

$this->db->select('com_articleid, COUNT(*) AS `comments_count`');

should be replaced with:

Code:

$this->db->select('com_articleid, COUNT(com_articleid) AS `comments_count`');

But I don't understand why that is important.