Количество записей в категории. Нужна помощь

SELECT cat_id, COUNT(id) AS summ FROM you_table GROUP BY cat_id;

 
SELECT i.*, COUNT(s.id) AS summ FROM cms_con_articles_cats i
INNER JOIN cms_con_articles as s ON i.id = s.category_id
GROUP BY s.category_id
 

 
SELECT cc.id,
              cc.title,
              COUNT(cm.id) AS comments
FROM cms_content cc
LEFT JOIN cms_comments cm ON cm.target_id = cc.id AND cm.target = 'article'
GROUP BY cc.id
ORDER BY cc.title
 

 
joinLeft('con_{ctype}_cats_bind', 'c', 'c.category_id = i.id');
select('COUNT(item_id)', 'count');
groupBy('id');
 

if($cat_id && $cat_id != 1){
	$model->table_prefix = '';
	$cat = $model->getItemById('board_cats', $cat_id);
	$model->filterCategory('board', $cat, true);
}
$items = $model->getCount('board');