Untitled query #79489

SQL

select max(rev_timestamp) as last_edit, rev_actor, user_name, user_registration, user_editcount,
case 
when user_registration BETWEEN DATE_SUB(NOW(), INTERVAL (365*5) DAY) AND DATE_SUB(NOW(), INTERVAL (365*5-20) DAY) then '05 years'
when user_registration BETWEEN DATE_SUB(NOW(), INTERVAL (365*10) DAY) AND DATE_SUB(NOW(), INTERVAL (365*10-20) DAY) then '10 years'
when user_registration BETWEEN DATE_SUB(NOW(), INTERVAL (365*15) DAY) AND DATE_SUB(NOW(), INTERVAL (365*15-20) DAY) then '15 years'
when user_registration BETWEEN DATE_SUB(NOW(), INTERVAL (365*20) DAY) AND DATE_SUB(NOW(), INTERVAL (365*20-20) DAY) then '20 years'
when user_registration is null then '99unknown' 
else 'no anniversary'
END as anniversary
from revision 
left join actor on rev_actor = actor_id
left join user on actor_user = user_id
where rev_timestamp > DATE_SUB(NOW(), INTERVAL 365 DAY)
and user_editcount >= 500
group by rev_actor
order by anniversary
limit 1000
SQL

Checking query status...
