USE dewiki_p;

SELECT user_name as Benutzername, count(rev_id) as "Bearbeitungen der letzten zwei Jahre"

FROM categorylinks, page, user, revision_userindex

WHERE 

  cl_to = 'Benutzer:aus_Köln' AND

  cl_from = page_id AND

  page_namespace = 2 AND

  REPLACE(user_name,' ', '_') = page_title AND

  rev_user = user_id AND

  rev_timestamp > NOW() - INTERVAL 2 YEAR

group by user_id

having count(rev_id) > 200 

order by user_name;