Most active users by edits on plwiki in last 12 months

SQL

USE plwiki_p;
SELECT CONCAT("#") AS Lp, user_id AS Identyfikator_użytkownika, CONCAT("[[User:",user_name,"|",user_name,"]]") AS Nazwa_użytkownika,
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
	#FROM user LEFT 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 user_id = 471642*/
/*AND ug_group != "bot"
AND user_editcount > 190*/
GROUP BY user_name
ORDER BY user_editcount DESC
LIMIT 600;
SQL

Checking query status...
