USE eswiki_p;

​

SET @N = 250;

SET @today =   mid(replace(now(),"-",""),5,4);

​

select user_name, concat("es.wikipedia.org/wiki/User talk:", user_name) as url

, datediff(now(), max(rev_timestamp)) as fecha

, user_editcount as ediciones, ipb_expiry

from revision_userindex join user on user_id = rev_user

left join ipblocks on ipb_user = user_id

​

where rev_user > 0 and user_editcount > 100 

​

group by rev_user having mod(fecha,@N) = 0 

order by user_editcount desc, rev_user;