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'