SELECT A.* FROM ( SELECT e.*, m.name AS PARENT_NAME, m.cmdline as PARENT_CMDLINE,m.path as PARENT_PATH FROM processes e JOIN processes m ON m.pid = e.parent ) A LEFT JOIN docker_containers B ON A.pid_namespace = B.pid_namespace WHERE B.pid_namespace IS NULL