Editors on Wikipedia:Missing_Wikipedians with recent edits

SQL

select * from (
  select replace(lt_title,"_"," ") as username,user_editcount as edit_count,date(min(rev_timestamp)) as first_edit,date(max(rev_timestamp)) 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, user_editcount
) as subquery where (last_edit > DATE_SUB(CURDATE(), INTERVAL 6 MONTH))

SQL

Checking query status...