Fork of Editors on Wikipedia:Missing_Wikipedians with recent edits by Ahecht
This query is marked as a draft This query has been published by Ahecht.

SQL

AخA
 
  select replace(lt_title,"_"," ") as username,user_editcount as edit_count,DATE_FORMAT(min(rev_timestamp), '%Y-%m-%d') as first_edit,DATE_FORMAT(max(rev_timestamp), '%Y-%m-%d') as last_edit from pagelinks
  join linktarget on lt_id=pl_target_id
  join user on user_name=replace(lt_title,"_"," ") 
  join actor_user on actor_user=user_id
  join revision_userindex on rev_actor=actor_id
  where pl_from=305368 and lt_namespace=2 
  group by lt_title
  having max(rev_timestamp) > DATE_SUB(CURDATE(), INTERVAL 12 MONTH);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...