#sonic to simplify

SELECT A.UM_GROUP AS INDX, A.UM_USER, B.UM_GROUP AS ROLE
  FROM UM_GROUP_UM_USER AS A
  LEFT JOIN UM_GROUP_UM_USER AS B
  ON A.UM_USER = B.UM_USER
  WHERE A.UM_GROUP = %s AND B.UM_GROUP = %s

SELECT * FROM UM_GROUP WHERE name LIKE '%DEP%'

SELECT ID AS OPERATOR_ID FROM UM_GROUP WHERE NAME = 'RUSPOST-OPERATOR'


SELECT A.UM_GROUP AS POSTAMT_INDEX, A.UM_USER, B.UM_GROUP AS RUSPOST_OPERATOR_GROUP_ID
    FROM UM_GROUP_UM_USER A
    LEFT JOIN UM_GROUP_UM_USER B
    ON A.UM_USER = B.UM_USER    WHERE A.UM_GROUP = 671389
        AND B.UM_GROUP = 61495

#bob 145935
#max 145952

SELECT COUNT(*) AS ACTIVE_TASK_NUM
    FROM (SELECT RT_PROCDESC, RT_SUBDESC, UM_USER_EDITOR
        FROM RT_SUBINST
        WHERE DROPPED = 0 AND
            AVAILABLETRANSITIONS = 1
            AND UM_USER_EDITOR = 145935) A
        JOIN (SELECT ID, JPASS_ID, NAME
            FROM RT_SUBDESC
            WHERE JPASS_ID = 'InternalSubjectDescription_xRtowSvvEea91xRuMXueEA') B
        ON A.RT_SUBDESC = B.ID


SELECT COUNT(*) AS ACTIVE_TASK_NUM
    FROM (SELECT RT_SUBDESC
            FROM ((SELECT RT_SUBDESC, CURRENT_STATE_RT_STDESC
                    FROM RT_SUBINST
                    WHERE UM_USER_EDITOR = 354) A      /*all subjects for concrete user*/
            JOIN (SELECT ID
                    FROM RT_STDESC
                    WHERE END_STATE = 0) B                /*all active states*/
            ON A.CURRENT_STATE_RT_STDESC = B.ID)) C       /*active states for concrete user' subject*/
    JOIN (SELECT ID, JPASS_ID, NAME
            FROM RT_SUBDESC
            WHERE JPASS_ID = 'InternalSubjectDescription_xRtowSvvEea91xRuMXueEA') D /*concrete subjects*/
    ON C.RT_SUBDESC = D.ID                                /*active states for concrete user's concrete subject*/
//simplify

SELECT RT_SUBDESC
    FROM ((SELECT RT_SUBDESC, CURRENT_STATE_RT_STDESC
            FROM RT_SUBINST
            WHERE UM_USER_EDITOR = 145935) A      /*get all subjects for concrete user*/
    JOIN (SELECT ID
            FROM RT_STDESC
            WHERE END_STATE = 0) B                /*get all active states for subject*/
    ON A.CURRENT_STATE_RT_STDESC = B.ID)