old users whose first edit anniversary is today or at a specified date

SQL

USE trwiki_p;


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

select user_name, concat("tr.wikipedia.org/wiki/User:", user_name) as url, mid(min(rev_timestamp),5,4) as aygun
, user_editcount as ec, mid(min(rev_timestamp),1,4) as yil
from revision_userindex join user on user_id = rev_user
-- left join recentchanges_userindex


where rev_timestamp < 20160000000000 and rev_user >0 and user_editcount > 100 
-- and rc_id is null
group by rev_user having aygun = @today 
order by user_editcount desc, rev_user
-- */
;

SQL

Checking query status...