You are welcome.

I know this topic is solved, but is there a way to drill this down even further and make the article count for a specific category inside K2?

Sure you need to add the catid check in your query.
eg:Where 5 is your category's id.

Where in the code do I insert that?

<?php
$db = JFactory::getDbo();
$db->setQuery("SELECT COUNT(*) FROM #__k2_categories WHERE published = 1 AND trash = 0");
$result = $db->loadResult();
?>

Where in the above code?

I think I've got it worked out!

Nice to hear that.

Hello,

This post was really helpfull but i need something extra for my case.

I want to display the total count of items of specific subcategories.


I now have the following category structure:

Parent Category A (0 Items)
- Child Category A (4 items)
- Child Category B (1 item)
- Child Category C (2 items)

Parent Category B (20 items)

Parent Category C (10 items)


So the goal is to display that the "Parent Category A" has 7 items

I found the solution to my previous post.

<?php
$db = JFactory::getDbo();
$db->setQuery("SELECT COUNT(*) FROM #__k2_items i, #__k2_categories c WHERE i.catid = c.id AND i.published = 1 AND i.trash = 0 AND c.parent = xx");
$result = $db->loadResult();
?>

xx -> parent category id

Hello, again!
This code counting piblished and dont trashed items. But if item published in future, code counting too. How exclude from counting pending items?
Thanks!

Hello,

Did you insert WHERE published = 1 in the query as well?