Вывод количество материалов в профиле пользователя

 /*********Главное меню**********/
    $sql_result = $db->query("select ct.id,
    (select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND (DATE_FORMAT(date, '%Y%m%d')=CURDATE()) AND approve = '1') as new_,
    (select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND approve = '1') as allnews_
    from ". PREFIX ."_category ct"
    );
    $count_news_of_category = '';
    while($row = $db->get_row($sql_result))
    {
    if( $row['new_'] == '0') {$news_now = '';} else {$news_now = '+'.$row['new_'].'';};
    $t = ''.$news_now.'';
    $tpl->set('{newcount_categ_'.$row['id'].'}', $t);
    $tpl->set('{allcount_categ_'.$row['id'].'}', $row['allnews_']);
    $count_news_of_category .= $row['id'].'#'.$t.'|';
    }
     
    /************************************/