SELECT res.id_,
       res.start_time_,
       res.end_time_,
       act.id_   AS ACT_INST_ID_,
       act.act_id_,
       proc_.id_ AS PROC_DEF_ID_,
       proc_.key_,
       proc_.name_
FROM   ACT_HI_PROCINST res
       INNER JOIN ACT_HI_ACTINST act
               ON act.call_proc_inst_id_ = res.id_
       INNER JOIN ACT_RE_PROCDEF proc_
               ON res.proc_def_id_ = proc_.id_
       LEFT JOIN ( SELECT DISTINCT self.proc_def_key_ AS KEY_
                   FROM   ACT_HI_PROCINST 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 ( 'marketing', '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 ( 'marketing', '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_ = act.proc_def_key_
WHERE  act.proc_inst_id_ = 'cf7c46bd-ef02-11e6-9044-0aa2e56f42b1' AND
       ( ( act.proc_def_key_ IS NOT NULL AND
           auth.key_ IS NOT NULL )  OR
         act.proc_def_key_ IS NULL )
ORDER  BY res.id_ ASC