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

SQL

USE trwiki_p;

SET @bugun =  mid(replace(now(),"-",""),5,4) /*
"0627";
select @bugun;
-- */
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 user_id >0 
where rev_timestamp < 20150000000000 and rev_user >0 and user_editcount > 100 
-- and rc_id is null
group by rev_user having aygun = @bugun 
order by user_editcount desc, rev_user
-- */
;

SQL

Checking query status...