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 and user_editcount < 10000
group by lt_title
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.