Untitled query #80062

SQL

select r.rev_actor, u.user_name, min(r.rev_timestamp), count(distinct(p.page_id)), count(r.rev_id)
from revision r
join page p on r.rev_page = p.page_id
join actor a on r.rev_actor = a.actor_id
join user u on a.actor_user = u.user_id
where u.user_name like "%script%"
	  and r.rev_minor_edit = 0 and p.page_namespace = 0 and p.page_is_redirect = 0
      and r.rev_timestamp < 20060000000000
group by r.rev_actor

AخA
 
select r.rev_actor, u.user_name, min(r.rev_timestamp), count(distinct(p.page_id)), count(r.rev_id)from revision rjoin page p on r.rev_page = p.page_idjoin actor a on r.rev_actor = a.actor_idjoin user u on a.actor_user = u.user_idwhere u.user_name like "%script%"      and r.rev_minor_edit = 0 and p.page_namespace = 0 and p.page_is_redirect = 0      and r.rev_timestamp < 20060000000000group by r.rev_actor

SQL

Checking query status...