<pre>SELECT
Count(category.category_guid)
FROM
category.pojo_parent,
category.name_translation_key
FROM
category
WHERE
category.pojo_parent = 'TASK' OR
category.pojo_parent = 'WORK_ITEM'
ORDER BY
category.pojo_parent ASC,
category.name_translation_key ASC
</pre>
[[Category:NoPublic]]