SELECT DISTINCT res.*
FROM   ACT_HI_PROCINST res
       LEFT JOIN ( SELECT DISTINCT self.proc_def_key_ AS KEY_
                   FROM   ( SELECT DISTINCT dkey.proc_def_key_
                            FROM   ACT_HI_PROCINST dkey ) self
                   WHERE  ( SELECT CASE
                                     WHEN self.proc_def_key_ IN
                                          ( SELECT a.resource_id_
                                            FROM   ACT_RU_AUTHORIZATION a
                                            WHERE  a.type_ = 1 AND
                                                   a.user_id_ = 'jakob.freund@camunda.com' AND
                                                   a.perms_ & 4096 = 4096 AND
                                                   a.resource_type_ = 6 AND
                                                   a.resource_id_ = self.proc_def_key_ ) THEN 1
                                     WHEN EXISTS
                                          ( SELECT id_
                                            FROM   ACT_RU_AUTHORIZATION a
                                            WHERE  a.type_ = 1 AND
                                                   a.user_id_ = 'jakob.freund@camunda.com' AND
                                                   a.perms_ & 4096 = 4096 AND
                                                   a.resource_type_ = 6 AND
                                                   a.resource_id_ = '*' ) THEN 1
                                     ELSE ( SELECT CASE
                                                     WHEN self.proc_def_key_ IN
                                                          ( SELECT a.resource_id_
                                                            FROM   ACT_RU_AUTHORIZATION a
                                                            WHERE  a.type_ = 1 AND
                                                                   a.group_id_ IN ( 'management', 'sales' ) AND
                                                                   a.perms_ & 4096 = 4096 AND
                                                                   a.resource_type_ = 6 AND
                                                                   a.resource_id_ = self.proc_def_key_ ) THEN 1
                                                     WHEN EXISTS
                                                          ( SELECT id_
                                                            FROM   ACT_RU_AUTHORIZATION a
                                                            WHERE  a.type_ = 1 AND
                                                                   a.group_id_ IN ( 'management', 'sales'  ) AND
                                                                   a.perms_ & 4096 = 4096 AND
                                                                   a.resource_type_ = 6 AND
                                                                   a.resource_id_ = '*' ) THEN 1
                                                     ELSE ( SELECT CASE
                                                                     WHEN self.proc_def_key_ IN
                                                                          ( SELECT a.resource_id_
                                                                            FROM   ACT_RU_AUTHORIZATION a
                                                                            WHERE  a.type_ = 0 AND
                                                                                   a.user_id_ = '*' AND
                                                                                   a.perms_ & 4096 = 4096 AND
                                                                                   a.resource_type_ = 6 AND
                                                                                   a.resource_id_ = self.proc_def_key_ ) THEN 1
                                                                     WHEN EXISTS
                                                                          ( SELECT id_
                                                                            FROM   ACT_RU_AUTHORIZATION a
                                                                            WHERE  a.type_ = 0 AND
                                                                                   a.user_id_ = '*' AND
                                                                                   a.perms_ & 4096 = 4096 AND
                                                                                   a.resource_type_ = 6 AND
                                                                                   a.resource_id_ = '*' ) THEN 1
                                                                     ELSE NULL
                                                                   end )
                                                   end )
                                   end )
                          = 1 ) auth
              ON auth.key_ = res.proc_def_key_
WHERE  proc_def_id_ = <proc_def_id> AND
       ( ( res.proc_def_key_ IS NOT NULL AND
           auth.key_ IS NOT NULL )  OR
         res.proc_def_key_ IS NULL )
ORDER  BY start_time_ DESC
LIMIT  50 offset 0