Untitled query #80031

SQL

select a.actor_id, a.actor_name, min(r.rev_timestamp), r.rev_page, p.page_title
from actor a
join revision r on a.actor_id=r.rev_actor
join page p on r.rev_page=p.page_id
where a.actor_id in (273, 8923, 65869, 162617, 839189, 1205210) and r.rev_timestamp < 20060000000000 and r.rev_minor_edit=0 and p.page_namespace=0 and p.page_is_redirect=0
group by a.actor_id

/*in (273, 8923, 65869, 162617, 839189, 1205210)*/

​x
 
select a.actor_id, a.actor_name, min(r.rev_timestamp), r.rev_page, p.page_titlefrom actor ajoin revision r on a.actor_id=r.rev_actorjoin page p on r.rev_page=p.page_idwhere a.actor_id in (273, 8923, 65869, 162617, 839189, 1205210) and r.rev_timestamp < 20060000000000 and r.rev_minor_edit=0 and p.page_namespace=0 and p.page_is_redirect=0group by a.actor_id​/*in (273, 8923, 65869, 162617, 839189, 1205210)*/

SQL

Checking query status...