Untitled query #69958

SQL

select r.rev_page, r.rev_actor, r.rev_id, r.rev_timestamp
from revision r
join (select page_id, page_title, min(rev_timestamp) created, count(rev_id) No_revs, count(distinct(rev_actor)) No_editors
from page
join revision on rev_page=page_id
where page_random > 0.057543833 and page_namespace = 0 and page_is_redirect = 0 and page_len > 5000 and rev_minor_edit = 0
group by page_id
having created > 20100101000000 and created < 20160101000000 and No_editors > 10
order by page_random
limit 100) t1 on t1.page_id = r.rev_page

​x
 
select r.rev_page, r.rev_actor, r.rev_id, r.rev_timestampfrom revision rjoin (select page_id, page_title, min(rev_timestamp) created, count(rev_id) No_revs, count(distinct(rev_actor)) No_editorsfrom pagejoin revision on rev_page=page_idwhere page_random > 0.057543833 and page_namespace = 0 and page_is_redirect = 0 and page_len > 5000 and rev_minor_edit = 0group by page_idhaving created > 20100101000000 and created < 20160101000000 and No_editors > 10order by page_randomlimit 100) t1 on t1.page_id = r.rev_page​

SQL

Checking query status...