SELECT

    l.log_user,

    CONCAT('[[User:', user_name, '|', user_name, ']]') AS 'Username',

    log_count AS 'Number of curations',

    DATE_FORMAT(log_max, '%Y-%m-%d') AS 'Last curation',

    COALESCE(ug_group, '') AS 'Admin'

FROM

(

    SELECT

        log_user,

        COUNT(*) AS log_count,

        MAX(log_timestamp) AS log_max

    FROM logging_userindex

    WHERE

        log_type='pagetriage-curation'

        AND log_deleted = 0

        AND log_timestamp >= 20161101000000

    GROUP BY log_user

) l

LEFT JOIN `user` ON l.log_user = user_id

LEFT JOIN

(

    SELECT ug_user, ug_group

    FROM user_groups

    WHERE ug_group = 'sysop'

) ug ON l.log_user = ug_user;

​

​