SOBI2 фильтр количества элементов категории - SOBI2

function countItemsInCat($catid, $catname) {
		$config = &orgConfig::getInstance ();
		$database = &$config->getDb ();
		$items = 0;
		$subCats = 0;
		
		$cache = & $config->sobiCache;
		$counter = $cache->getObj ( 0, 0, $catid, 0, true, true );
		if (is_array ( $counter )) {
			$items = $counter ['items'];
			$subCats = $counter ['cats'];
		}
		if ($items < 0) {
			$items = 0;
		}
		if ($subCats < 1) {
			$subCatsStr = "-";
		} else {
			$subCatsStr = "{$subCats}";
		}
		if ($items < 1) {
			$itemsStr = "-";
		} else {
			$itemsStr = "{$items}";
		}
		
		$string = "<span class=\"orgCountSeparator\">&nbsp;</span>";
		if ($config->key ( "frontpage", "catlist_count_entries", true )) {
			$string .= "<span class=\"orgEditlinktipItems\">" . sobiHTML::toolTip ( addslashes ( _org_ITEMS_IN_THIS_CAT . $items ), addslashes ( _org_ITEMS_IN_CAT . $catname ), '', '', $itemsStr, '#', 0 ). "</span>";

$itemsStr = @mysql_result(mysql_query("
			SELECT COUNT(*)
			   itemid
			FROM jos_org_fields_data 
			INNER 
				JOIN jos_org_cat_items_relations 
				ON jos_org_fields_data.itemid = jos_org_cat_items_relations.itemid 
			WHERE catid = '{$catid}' 
			AND data_txt = '{$_COOKIE["location"]}'
			"),0);

$itemsStr = @mysql_result(mysql_query("
			SELECT COUNT(*)
			   itemid
			FROM jos_org_fields_data 
			INNER 
				JOIN jos_org_cat_items_relations 
				ON jos_org_fields_data.itemid = jos_org_cat_items_relations.itemid
			INNER 
				JOIN jos_org_item 
				ON jos_org_fields_data.itemid = jos_org_item.itemid  
			WHERE catid = '{$catid}' 
			AND data_txt = '{$_COOKIE["location"]}'
			AND published = '1'
			"),0);

			$itemsStrCount = @mysql_result(mysql_query("
			SELECT COUNT(*)
				id,
				jos_org_fields_data.fieldid AS fieldid,
				jos_org_fields_data.data_txt AS data_txt,
				jos_org_item.itemid AS itemid,
				jos_org_cat_items_relations.catid AS catid,
				jos_org_cats_relations.parentid AS parentid,
				jos_org_item.published AS published
			FROM jos_org_fields_data 
			INNER 
				JOIN jos_org_cat_items_relations 
				ON jos_org_fields_data.itemid = jos_org_cat_items_relations.itemid
			INNER 
				JOIN jos_org_item
				ON jos_org_fields_data.itemid = jos_org_item.itemid
			INNER
				JOIN jos_org_cats_relations 
				ON jos_org_cat_items_relations.catid = jos_org_cats_relations.catid 
			WHERE (jos_org_cat_items_relations.catid = '{$catid}' or parentid = '{$catid}')
			AND data_txt = '{$_COOKIE["location"]}'
			AND published = '1'
			"),0);
			   IF($itemsStrCount < 1) {
					$itemsStr = "-";
				} else {
					$itemsStr = $itemsStrCount;
				}