SELECT DISTINCT res.rev_,
                res.id_,
                res.name_,
                res.parent_task_id_,
                res.description_,
                res.priority_,
                res.create_time_,
                res.owner_,
                res.assignee_,
                res.delegation_,
                res.execution_id_,
                res.proc_inst_id_,
                res.proc_def_id_,
                res.case_execution_id_,
                res.case_inst_id_,
                res.case_def_id_,
                res.task_def_key_,
                res.due_date_,
                res.follow_up_date_,
                res.suspension_state_
FROM   ACT_RU_TASK res
       LEFT JOIN ACT_RE_PROCDEF procdef
              ON res.proc_def_id_ = procdef.id_
WHERE  res.suspension_state_ = 1 AND
       ( CASE
           WHEN res.execution_id_ IS NOT NULL THEN ( Ifnull( ( SELECT CASE
                                                                        WHEN res.id_ IN
                                                                             ( SELECT a.resource_id_
                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                               WHERE  a.type_ = 1 AND
                                                                                      a.user_id_ = 'demo' AND
                                                                                      a.perms_ & 2 = 2 AND
                                                                                      a.resource_type_ = 7 AND
                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                        WHEN res.id_ IN
                                                                             ( SELECT a.resource_id_
                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                               WHERE  a.type_ = 2 AND
                                                                                      a.user_id_ = 'demo' AND
                                                                                      a.perms_ & 2 != 2 AND
                                                                                      a.resource_type_ = 7 AND
                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                        WHEN EXISTS
                                                                             ( SELECT id_
                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                               WHERE  a.type_ = 1 AND
                                                                                      a.user_id_ = 'demo' AND
                                                                                      a.perms_ & 2 = 2 AND
                                                                                      a.resource_type_ = 7 AND
                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                        WHEN EXISTS
                                                                             ( SELECT id_
                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                               WHERE  a.type_ = 2 AND
                                                                                      a.user_id_ = 'demo' AND
                                                                                      a.perms_ & 2 != 2 AND
                                                                                      a.resource_type_ = 7 AND
                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                        ELSE ( SELECT CASE
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'accounting' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'camunda-admin' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'management' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'sales' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'accounting' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'camunda-admin' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'management' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                                        WHEN res.id_ IN
                                                                                             ( SELECT a.resource_id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'sales' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'accounting' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'camunda-admin' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'management' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 1 AND
                                                                                                      a.group_id_ = 'sales' AND
                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'accounting' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'camunda-admin' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'management' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                                        WHEN EXISTS
                                                                                             ( SELECT id_
                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                               WHERE  a.type_ = 2 AND
                                                                                                      a.group_id_ = 'sales' AND
                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                      a.resource_type_ = 7 AND
                                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                                        ELSE ( SELECT CASE
                                                                                                        WHEN res.id_ IN
                                                                                                             ( SELECT a.resource_id_
                                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                                               WHERE  a.type_ = 0 AND
                                                                                                                      a.user_id_ = '*' AND
                                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                                      a.resource_type_ = 7 AND
                                                                                                                      a.resource_id_ = res.id_ ) THEN 1
                                                                                                        WHEN res.id_ IN
                                                                                                             ( SELECT a.resource_id_
                                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                                               WHERE  a.type_ = 0 AND
                                                                                                                      a.user_id_ = '*' AND
                                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                                      a.resource_type_ = 7 AND
                                                                                                                      a.resource_id_ = res.id_ ) THEN 0
                                                                                                        WHEN EXISTS
                                                                                                             ( SELECT id_
                                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                                               WHERE  a.type_ = 0 AND
                                                                                                                      a.user_id_ = '*' AND
                                                                                                                      a.perms_ & 2 = 2 AND
                                                                                                                      a.resource_type_ = 7 AND
                                                                                                                      a.resource_id_ = '*' ) THEN 1
                                                                                                        WHEN EXISTS
                                                                                                             ( SELECT id_
                                                                                                               FROM   ACT_RU_AUTHORIZATION a
                                                                                                               WHERE  a.type_ = 0 AND
                                                                                                                      a.user_id_ = '*' AND
                                                                                                                      a.perms_ & 2 != 2 AND
                                                                                                                      a.resource_type_ = 7 AND
                                                                                                                      a.resource_id_ = '*' ) THEN 0
                                                                                                        ELSE NULL
                                                                                                      end )
                                                                                      end )
                                                                      end ), Ifnull( ( SELECT CASE
                                                                                                WHEN procdef.key_ IN
                                                                                                     ( SELECT a.resource_id_
                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                              a.user_id_ = 'demo' AND
                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                              a.resource_type_ = 6 AND
                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                WHEN procdef.key_ IN
                                                                                                     ( SELECT a.resource_id_
                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                              a.user_id_ = 'demo' AND
                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                              a.resource_type_ = 6 AND
                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                WHEN EXISTS
                                                                                                     ( SELECT id_
                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                              a.user_id_ = 'demo' AND
                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                              a.resource_type_ = 6 AND
                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                WHEN EXISTS
                                                                                                     ( SELECT id_
                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                              a.user_id_ = 'demo' AND
                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                              a.resource_type_ = 6 AND
                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                ELSE ( SELECT CASE
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'accounting' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'camunda-admin' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'management' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'sales' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'accounting' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'camunda-admin' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'management' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                                WHEN procdef.key_ IN
                                                                                                                     ( SELECT a.resource_id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'sales' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'accounting' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'camunda-admin' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'management' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 1 AND
                                                                                                                              a.group_id_ = 'sales' AND
                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'accounting' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'camunda-admin' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'management' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                                WHEN EXISTS
                                                                                                                     ( SELECT id_
                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                       WHERE  a.type_ = 2 AND
                                                                                                                              a.group_id_ = 'sales' AND
                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                                ELSE ( SELECT CASE
                                                                                                                                WHEN procdef.key_ IN
                                                                                                                                     ( SELECT a.resource_id_
                                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                                       WHERE  a.type_ = 0 AND
                                                                                                                                              a.user_id_ = '*' AND
                                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 1
                                                                                                                                WHEN procdef.key_ IN
                                                                                                                                     ( SELECT a.resource_id_
                                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                                       WHERE  a.type_ = 0 AND
                                                                                                                                              a.user_id_ = '*' AND
                                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                                              a.resource_id_ = procdef.key_ ) THEN 0
                                                                                                                                WHEN EXISTS
                                                                                                                                     ( SELECT id_
                                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                                       WHERE  a.type_ = 0 AND
                                                                                                                                              a.user_id_ = '*' AND
                                                                                                                                              a.perms_ & 64 = 64 AND
                                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                                              a.resource_id_ = '*' ) THEN 1
                                                                                                                                WHEN EXISTS
                                                                                                                                     ( SELECT id_
                                                                                                                                       FROM   ACT_RU_AUTHORIZATION a
                                                                                                                                       WHERE  a.type_ = 0 AND
                                                                                                                                              a.user_id_ = '*' AND
                                                                                                                                              a.perms_ & 64 != 64 AND
                                                                                                                                              a.resource_type_ = 6 AND
                                                                                                                                              a.resource_id_ = '*' ) THEN 0
                                                                                                                                ELSE NULL
                                                                                                                              end )
                                                                                                              end )
                                                                                              end ), 0 ) ) )
           WHEN res.case_execution_id_ IS NOT NULL THEN 1
           ELSE ( SELECT CASE
                           WHEN res.id_ IN
                                ( SELECT a.resource_id_
                                  FROM   ACT_RU_AUTHORIZATION a
                                  WHERE  a.type_ = 1 AND
                                         a.user_id_ = 'demo' AND
                                         a.perms_ & 2 = 2 AND
                                         a.resource_type_ = 7 AND
                                         a.resource_id_ = res.id_ ) THEN 1
                           WHEN res.id_ IN
                                ( SELECT a.resource_id_
                                  FROM   ACT_RU_AUTHORIZATION a
                                  WHERE  a.type_ = 2 AND
                                         a.user_id_ = 'demo' AND
                                         a.perms_ & 2 != 2 AND
                                         a.resource_type_ = 7 AND
                                         a.resource_id_ = res.id_ ) THEN 0
                           WHEN EXISTS
                                ( SELECT id_
                                  FROM   ACT_RU_AUTHORIZATION a
                                  WHERE  a.type_ = 1 AND
                                         a.user_id_ = 'demo' AND
                                         a.perms_ & 2 = 2 AND
                                         a.resource_type_ = 7 AND
                                         a.resource_id_ = '*' ) THEN 1
                           WHEN EXISTS
                                ( SELECT id_
                                  FROM   ACT_RU_AUTHORIZATION a
                                  WHERE  a.type_ = 2 AND
                                         a.user_id_ = 'demo' AND
                                         a.perms_ & 2 != 2 AND
                                         a.resource_type_ = 7 AND
                                         a.resource_id_ = '*' ) THEN 0
                           ELSE ( SELECT CASE
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'accounting' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 1
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'camunda-admin' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 1
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'management' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 1
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'sales' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 1
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'accounting' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 0
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'camunda-admin' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 0
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'management' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 0
                                           WHEN res.id_ IN
                                                ( SELECT a.resource_id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'sales' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = res.id_ ) THEN 0
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'accounting' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 1
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'camunda-admin' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 1
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'management' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 1
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 1 AND
                                                         a.group_id_ = 'sales' AND
                                                         a.perms_ & 2 = 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 1
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'accounting' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 0
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'camunda-admin' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 0
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'management' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 0
                                           WHEN EXISTS
                                                ( SELECT id_
                                                  FROM   ACT_RU_AUTHORIZATION a
                                                  WHERE  a.type_ = 2 AND
                                                         a.group_id_ = 'sales' AND
                                                         a.perms_ & 2 != 2 AND
                                                         a.resource_type_ = 7 AND
                                                         a.resource_id_ = '*' ) THEN 0
                                           ELSE ( SELECT CASE
                                                           WHEN res.id_ IN
                                                                ( SELECT a.resource_id_
                                                                  FROM   ACT_RU_AUTHORIZATION a
                                                                  WHERE  a.type_ = 0 AND
                                                                         a.user_id_ = '*' AND
                                                                         a.perms_ & 2 = 2 AND
                                                                         a.resource_type_ = 7 AND
                                                                         a.resource_id_ = res.id_ ) THEN 1
                                                           WHEN res.id_ IN
                                                                ( SELECT a.resource_id_
                                                                  FROM   ACT_RU_AUTHORIZATION a
                                                                  WHERE  a.type_ = 0 AND
                                                                         a.user_id_ = '*' AND
                                                                         a.perms_ & 2 != 2 AND
                                                                         a.resource_type_ = 7 AND
                                                                         a.resource_id_ = res.id_ ) THEN 0
                                                           WHEN EXISTS
                                                                ( SELECT id_
                                                                  FROM   ACT_RU_AUTHORIZATION a
                                                                  WHERE  a.type_ = 0 AND
                                                                         a.user_id_ = '*' AND
                                                                         a.perms_ & 2 = 2 AND
                                                                         a.resource_type_ = 7 AND
                                                                         a.resource_id_ = '*' ) THEN 1
                                                           WHEN EXISTS
                                                                ( SELECT id_
                                                                  FROM   ACT_RU_AUTHORIZATION a
                                                                  WHERE  a.type_ = 0 AND
                                                                         a.user_id_ = '*' AND
                                                                         a.perms_ & 2 != 2 AND
                                                                         a.resource_type_ = 7 AND
                                                                         a.resource_id_ = '*' ) THEN 0
                                                           ELSE 0
                                                         end )
                                         end )
                         end )
         end ) = 1
ORDER  BY res.create_time_ DESC
LIMIT  15 offset 0;