Untitled query #12107

SQL

SELECT
    /*CONCAT('[[User:',*/ recent_user_text /*, '|]]')*/ AS 'Username',
--    DATE_FORMAT(rev_min, '%Y-%m-%d') AS 'First edit',
--    user_editcount AS 'Edit count',
--    DATE_FORMAT(rev_max, '%Y-%m-%d') AS 'Last edit',
    recent_count AS 'Number of patrols (in time range)',
    /*DATE_FORMAT(*/ log_min /*, '%Y-%m-%d')*/ AS 'First patrol (ever)',
    /*DATE_FORMAT(*/ log_max /*, '%Y-%m-%d')*/ AS 'Last patrol'
FROM
(
    SELECT log_user_text AS recent_user_text, COUNT(*) AS recent_count
    FROM logging_userindex
    WHERE log_type='pagetriage-curation'
    GROUP BY log_user_text
) log_recent
LEFT JOIN
(
    SELECT
        log_user_text,
        MIN(log_timestamp) AS log_min,
        MAX(log_timestamp) AS log_max
    FROM logging_userindex
    WHERE log_type='pagetriage-curation'
    GROUP BY log_user_text
) loxg_minmax ON recent_user_text = log_user_text
/*
LEFT JOIN
(
    SELECT
        rev_user_text,
        MIN(rev_timestamp) AS rev_min,
        MAX(rev_timestamp) AS rev_max
    FROM revision_userindex
    GROUP BY rev_user_text
) rev_minmax ON recent_user_text = rev_user_text
*/
-- LEFT JOIN `user` ON recent_user = user_id
;
SQL

Checking query status...
