Editors on Wikipedia:Missing_Wikipedians with recent edits

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

  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);

SQL

Checking query status...