WITH contribution AS
  ( SELECT reporter AS "user_key",
           'issue_reporter' AS "contribution_type",
           count(*)
   FROM jiraissue
   GROUP BY reporter
   UNION
     ( SELECT assignee AS "user_key",
              'issue_assignee' AS "contribution_type",
              count(*)
      FROM jiraissue
      GROUP BY assignee )
   UNION
     ( SELECT creator AS "user_key",
              'issue_creator' AS "contribution_type",
              count(*)
      FROM jiraissue
      GROUP BY creator )
   UNION
     ( SELECT source_name AS "user_key",
              lower(association_type) AS "contribution_type",
              count(*)
      FROM userassociation
      GROUP BY source_name,
               association_type )
   UNION
     ( SELECT author AS "user_key",
              'attachment_author' AS "contribution_type",
              count(*)
      FROM fileattachment
      GROUP BY author )
   UNION
     ( SELECT author AS "user_key",
              'comment_author' AS "contribution_type",
              count(*)
      FROM jiraaction
      WHERE actiontype = 'comment'
      GROUP BY author )
   UNION
     ( SELECT perm_parameter AS "user_key",
              'permission_in_scheme' AS "contribution_type",
              count(*)
      FROM schemepermissions
      WHERE perm_type='user'
      GROUP BY perm_parameter )
   UNION
     ( SELECT lead AS "user_key",
              'project_lead' AS "contribution_type",
              count(*)
      FROM project
      GROUP BY lead )
   UNION
     ( SELECT author AS "user_key",
              'worklog_author' AS "contribution_type",
              count(*)
      FROM worklog
      GROUP BY author )
   UNION
     ( SELECT author AS "user_key",
              'change_author' AS "contribution_type",
              count(*)
      FROM changegroup
      GROUP BY author )
   UNION
     ( SELECT authorname AS "user_key",
              'filter_author' AS "contribution_type",
              count(*)
      FROM searchrequest
      GROUP BY authorname )
   UNION
     ( SELECT username AS "user_key",
              'filter_owner' AS "contribution_type",
              count(*)
      FROM searchrequest
      GROUP BY username )
   UNION
     ( SELECT username AS "user_key",
              'dashboard_owner' AS "contribution_type",
              count(*)
      FROM portalpage
      GROUP BY username)
   UNION
     ( SELECT cfv.stringvalue AS "user_key",
              'user_customfield_and_rp' AS "contribution_type",
              count(*)
      FROM customfieldvalue cfv
      JOIN customfield cf ON cfv.customfield = cf.id
      WHERE customfieldtypekey ILIKE '%userpicker%'
        OR customfieldtypekey = 'com.atlassian.servicedesk:sd-request-participants'
      GROUP BY cfv.stringvalue )
   UNION
     ( SELECT roletypeparameter AS "user_key",
              'projectroleactor' AS "contribution_type",
              count(*)
      FROM projectroleactor
      WHERE roletype = 'atlassian-user-role-actor'
      GROUP BY roletypeparameter )
   UNION
     ( SELECT author_key AS "user_key",
              'auditlog_author' AS "contribution_type",
              count(*)
      FROM audit_log
      GROUP BY author_key ))
SELECT ('"' || cwdu.lower_user_name || '"') AS lower_user_name,
       ('"' || c.user_key || '"') AS user_key,
       c.contribution_type,
       c.count
FROM cwd_user cwdu
RIGHT JOIN app_user au ON cwdu.lower_user_name = au.lower_user_name
JOIN contribution c ON c.user_key = au.user_key
WHERE cwdu.user_name = '<user-name>';