This query is marked as a draft This query has been published by Cryptic.

SQL

AخA
 
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' AND log_timestamp >= 20150327000000
    GROUP BY log_user
) 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
) log_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
) rev_minmax ON recent_user_text = rev_user_text
*/
-- LEFT JOIN `user` ON recent_user = user_id
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...