Количество записей - SOBI2

protected function category( $category ) 

$cat[ 'id' ] = $category->get( 'id' );
$cat[ 'nid' ] = $category->get( 'nid' );

$cat['cat_entries_total'] = SPFactory::db()->select( 'COUNT(id)', 'spdb_relations', array( 'pid' => $category->get( 'id' ), 'oType' => 'entry' ) )->loadResult();

<p class="thumbcat">
   <a href="{url}">
	<xsl:value-of select="name" />
   </a>
</p>

<span>(<xsl:value-of select="cat_entries_total" />)</span>

protected function category( $category )
	{
		$cat = array();
		if ( is_numeric( $category ) ) {
			$cat = $this->cachedCategory( $category );
		}
		if ( !( is_array( $cat ) ) || !( count( $cat ) ) ) {
			if ( is_numeric( $category ) ) {
				$category = SPFactory::Category( $category );
			}
			$cat['cat_entries_total'] = SPFactory::db()->select( 'COUNT(id)', 'spdb_relations', array( 'pid' => $category->get( 'id' ), 'oType' => 'entry' ) )->loadResult();
			$cat[ 'id' ] = $category->get( 'id' );
			$cat[ 'nid' ] = $category->get( 'nid' );
			$cat[ 'name' ] = array(
					'_complex' => 1,
					'_data' => $category->get( 'name' ),
					'_attributes' => array( 'lang' => Sobi::Lang( false ) )
			);

SELECT COUNT(`id`) FROM `#_sobipro_relations` WHERE `oType`='entry' AND `pid`=номер_любой_категории

<xsl:if test="position() &lt; ( $subcatsNumber + 1 )">
						<a href="{@url}">
							<small><xsl:value-of select="." /></small>
                                                        <xsl:value-of select="name" /><span>(<xsl:value-of select="cat_entries_total" />)</span>
						</a>

if ( Sobi::Cfg( 'list.subcats', true ) ) {
				/* @todo we have to change this method in this way that it can be sorted and limited */
				$subcats = $category->getChilds( 'category', false, 1, true, Sobi::Cfg( 'list.subcats_ordering', 'name' ) );
				$sc = array();
				if ( count( $subcats ) ) {
					foreach ( $subcats as $id => $name ) {
						$sc[ ] = array(
								'_complex' => 1,
								'_data' => SPLang::clean( $name[ 'name' ] ),
								'_attributes' => array( 'lang' => Sobi::Lang( false ), 'id' => $id, 'url' => Sobi::Url( array( 'title' => Sobi::Cfg( 'sef.alias', true )? $name[ 'alias' ] : $name[ 'name' ], 'sid' => $id, ) ) )
						);
					}
				}
				$cat[ 'subcategories' ] = $sc;
			}
			SPFactory::cache()->addObj( $cat, 'category_struct', $category->get( 'id' ) );
			unset( $category );