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,"|",user_editcount,"]]") as "broj uređivanja",
       user_groups
from user 
join user_groups ON user_id = ug_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...
