User Manager Certification Step 2

SELECT DISTINCT us.isreassigned,
                CASE
                  WHEN us.isreassigned = 0 THEN Concat(cm.campaign_name, ' - ',
                                                u.username, ' ('
                                                , u.displayname, ')')
                  WHEN us.isreassigned = 1 THEN Concat(cm.campaign_name, ' - ',
                                                ru.username,
                                                ' (', ru.displayname, ')',
                                                '-Reassigned-',
                                                us.updatedate)
                  ELSE Concat(cm.campaign_name, ' - ', u.username, ' (',
                       u.displayname, ')')
                end              AS 'Certification',
                CASE
                  WHEN us.isreassigned = 1 THEN ru.username
                  ELSE u.username
                end              AS 'Certifier',
                CASE
                  WHEN c.progress = 100 THEN 'Fully Executed'
                  ELSE 'In Progress'
                end              AS 'Certification Status',
                ca.name          AS 'Account Name',
                cu.displayname   AS 'User Display Name',
                cu.username      AS 'Usename',
                CASE
                  WHEN ca.status = 1 THEN 'Active'
                  WHEN ca.status = 2 THEN 'Inactive'
                  ELSE ca.status
                end              AS 'Account Status',
                e.endpointname   AS 'Endpoint Name',
                CASE
                  WHEN cev.displayname IS NOT NULL THEN cev.displayname
                  ELSE cev.entitlement_value
                end              AS 'Entitlement Value',
                cev.description  AS 'Entitlement Description',
                cae1.comments    AS 'User Comments',
                us.audittrail    AS 'Step 1 History',
                cae1.audit_trail AS 'Step 2 History',
                CASE
                  WHEN ( us.certified = 1
                          OR us.certified IS NULL ) THEN 'No Response'
                  WHEN us.certified = 2 THEN 'Certified'
                  WHEN us.certified = 3 THEN 'Does not work for me'
                  WHEN us.certified = 4 THEN 'Terminated'
                end              AS 'Step 1 Certifier Action',
                CASE
                  WHEN ( cae1.certified = 1
                          OR us.certified IS NULL ) THEN 'No Response'
                  WHEN cae1.certified = 2 THEN 'Certified'
                  WHEN cae1.certified = 3 THEN 'Revoked'
                  WHEN cae1.certified = 4 THEN 'Terminated'
                  WHEN cae1.certified = 5 THEN 'Conditionally Certified'
                end              AS 'Step 2 Certifier Action'
FROM   certification c
       JOIN campaign cm
         ON c.status IN ( 0, 1, 2, 3,
                          8, 10 )
            AND c.campaignkey = cm.id
            AND cm.campaign_type = 2
       JOIN certification_user_status us
         ON c.certkey = us.certkey
       JOIN certification_user cu
         ON cu.cert_userkey = us.cert_userkey
       JOIN users u
         ON u.userkey = cu.manager
       LEFT JOIN users ru
              ON ru.userkey = us.updateuser
       LEFT JOIN certification_account ca
              ON ca.userkey = cu.userkey
                 AND Find_in_set (ca.endpointkey, cm.endpointids)
       JOIN certification_account_entitlement1_status cae1
         ON cae1.certkey = c.certkey
            AND cae1.cert_accountkey = ca.cert_accountkey
       JOIN endpoints e
         ON ca.endpointkey = e.endpointkey
            AND Find_in_set (e.endpointkey, cm.endpointids)
       JOIN certification_entitlement_value cev
         ON cae1.cert_entitlement_valuekey = cev.cert_entitlement_valuekey
WHERE  cm.id IN ( 352 )
ORDER  BY 4
LIMIT  250000;