in your subquery `(select pid as ppid from process...
# general
t
in your subquery
(select pid as ppid from process_events) as prnt