sub {

my $cat = $_[0];
my $all_ids = $DB->table('Category')->children($cat);
push @$all_ids, $cat;

my $db_obj = $DB->table('Category');
$db_obj->select_options ('ORDER BY Full_Name DESC');

my $cond = GT::SQL::Condition->new('CategoryID', 'IN', $all_ids);
my $sth = $db_obj->select ( $cond) || die $GT::SQL::error;

my @cats;
while (my $hit = $sth->fetchrow_hashref) {

$hit->{URL} = $CFG->{build_root_url} . '/' . $DB->table('Category')->as_url( $hit->{Full_Name} ) . '/' . $CFG->{build_index};
push @cats, $hit;
}

return { cat_loop => \@cats }

}

<%get_cats_from_this_cat($category_id)%>
<%if cat_loop.length%>
<%loop cat_loop%>
<%include subcategory.html%>
<%endloop%>
<%endif%>