Most active users by edits on plwiki in last 12 months

SQL

USE plwiki_p;
SELECT CONCAT("#"), user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS Wikipedysta,
COUNT(rev_id) AS Liczba_edycji_w_ostatnim_półroczu, user_editcount AS Liczba_edycji_w_całym_okresie_edytowania
/*, ug_group OR $wgGroupPermissions*/
/*FROM user, revision /*user_groups
WHERE user_groups.ug_user = user.user_id*/
FROM user INNER JOIN revision
ON (revision.rev_user = user.user_id)
/*AND revision.rev_user = user.user_id*/
/*AND rev_timestamp < 20150101000000
AND rev_timestamp > 20140701000000*/
AND rev_timestamp > 20150926000000
AND rev_timestamp < 20150926235959
/*AND ug_group != "bot"
AND user_editcount > 190*/
GROUP BY user_name
ORDER BY user_editcount DESC
LIMIT 600

SQL

Checking query status...