Untitled query #79959

SQL

select a.actor_id, r.rev_actor, a.actor_user, u.user_id, u.user_name, r.rev_page, max(r.rev_timestamp)
from actor a
join user u on a.actor_user=u.user_id
join revision r on a.actor_id=r.rev_actor
join page p on r.rev_page=p.page_id
where a.actor_id=1839479 and r.rev_timestamp < 20060000000000 and r.rev_minor_edit=0 
	and p.page_namespace = 0 and p.page_is_redirect = 0 
    and p.page_id < 3500000
group by r.rev_page
order by r.rev_page

AخA
 
select a.actor_id, r.rev_actor, a.actor_user, u.user_id, u.user_name, r.rev_page, max(r.rev_timestamp)from actor ajoin user u on a.actor_user=u.user_idjoin revision r on a.actor_id=r.rev_actorjoin page p on r.rev_page=p.page_idwhere a.actor_id=1839479 and r.rev_timestamp < 20060000000000 and r.rev_minor_edit=0     and p.page_namespace = 0 and p.page_is_redirect = 0     and p.page_id < 3500000group by r.rev_pageorder by r.rev_page

SQL

Checking query status...