The following SQL query will generate a list of all published process:
SELECT id,process_name FROM process_container p where EXISTS (
FROM published_process e
WHERE e.originalProcessId = p.id
) and p.parent_category_id is not null
This document was generated from the following discussion: Nolio Official KB: How do I query The database for all published Processes?