parents_field = db.zf_topic.id.count()
siblings_field = db.zf_topic.id.count()
hits_field = db.zf_topic.hits.sum()
join = [db.zf_forum.on(db.zf_forum_category.id == db.zf_forum.cat_id),
        db.zf_topic.on((db.zf_forum.id == db.zf_topic.forum_id)  &  (db.zf_topic.disabled_flag == 0))]
groupby = db.zf_forum.id | db.zf_forum.forum_title | db.zf_forum.forum_desc | db.zf_forum.moderation_flag | db.zf_forum.anonymous_viewaccess | db.zf_forum.add_postings_access_roles | db.zf_forum_category.id | db.zf_forum_category.cat_name | db.zf_forum_category.cat_desc | db.zf_forum_category.cat_visible_to | db.zf_forum_category.cat_sort | db.zf_forum.reply_postings_access_roles | db.zf_forum.forum_sort
orderby = db.zf_forum_category.cat_sort | db.zf_forum.forum_sort
rows = db().select(
        db.zf_forum_category.id, db.zf_forum_category.cat_name, db.zf_forum_category.cat_desc, db.zf_forum_category.cat_visible_to, db.zf_forum_category.cat_sort,
        db.zf_forum.id, db.zf_forum.forum_title, db.zf_forum.forum_desc, db.zf_forum.moderation_flag, db.zf_forum.anonymous_viewaccess, db.zf_forum.add_postings_access_roles, db.zf_forum.reply_postings_access_roles, db.zf_forum.forum_sort,
        parents_field, siblings_field, hits_field,
        left=join,
        groupby=groupby,
        orderby=orderby
    )

for row in rows:
            cat_id = row.zf_forum_category.id
            cat_name = row.zf_forum_category.cat_name
            cat_desc = row.zf_forum_category.cat_desc
            cat_visible_to_str = row.zf_forum_category.cat_visible_to
            cat_sort = row.zf_forum_category.cat_sort
            forum_id = row.zf_forum.id
            forum_title = row.zf_forum.forum_title
            forum_desc = row.zf_forum.forum_desc
            moderation_flag = row.zf_forum.moderation_flag
            anonymous_viewaccess = row.zf_forum.anonymous_viewaccess
            add_postings_access_roles = row.zf_forum.add_postings_access_roles
            reply_postings_access_roles = row.zf_forum.reply_postings_access_roles
            forum_sort = row.zf_forum.forum_sort
            parents = row._extra[parents_field]
            siblings = row._extra[siblings_field]
            hits = row._extra[hits_field]