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.