users, bots by edit count

SQL

SET @row_number = 0;
select (@row_number:=@row_number + 1) as "#",
       CONCAT("[[User:", user_name,"|", IF(ipb_expiry LIKE "infinity", "<s>", ""), user_name, IF(ipb_expiry LIKE "infinity", "</s>", ""), "]]") as "suradnik", 
       CONCAT("[[Special:Contributions/",user_name,"|{{n|",user_editcount,"}}]]") as "broj uređivanja"
from user
left join ipblocks on ipb_user = user_id
#where LOWER(user_name) not like "%bot%" COLLATE utf8_general_ci 
order by user_editcount desc limit 200
;

-- select * from ipblocks limit 5;
SQL

Checking query status...
