SELECT 
"CATEGORY_ID",
"CATEGORY_NAME",
"DESCRIPTION",
"PARENT_ID",
(SELECT count(*) FROM nf_posts WHERE
 category_id IN (
        SELECT category_id FROM NF_CATEGORY 
        START WITH category_id = cat.category_id
        CONNECT BY parent_id = PRIOR category_id
 ) 
 AND parent_id is null) topics,
 (SELECT count(*) FROM nf_posts WHERE
 category_id IN (
        SELECT category_id FROM NF_CATEGORY 
        START WITH category_id = cat.category_id
        CONNECT BY parent_id = PRIOR category_id
 ) 
 AND parent_id is not null) replies from   "NF_CATEGORY" cat
where Parent_ID = :P4_Category_ID
and nf_user_can_str(:APP_USER, category_id, 'view') = 'T'