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 talk:", user_name) as url, mid(min(rev_timestamp),5,4) as aygun
, datediff(now(), max(rev_timestamp)) as kacgun
, user_editcount as ec, mid(min(rev_timestamp),1,4) as yil
, ipb_expiry
from revision_userindex join user on user_id = rev_user
left join ipblocks on ipb_user = user_id


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

SQL

Checking query status...