Untitled query #70343

SQL

select page_id, page_title, min(rev_timestamp) created, count(rev_id) No_revs, count(distinct(rev_actor)) No_actors
from page
join revision on rev_page=page_id
where page_random > 0.057543833 and page_namespace = 0 and page_is_redirect = 0 and rev_minor_edit = 0 and page_len > 5000
	and rev_actor not in (215006043, 20775, 589, 184, 177, 4294, 4219, 307, 159274, 4307, 68199, 224, 43381, 540, 12299, 10632, 24735, 874, 32630, 11817, 4240, 189698000, 4311, 29477, 43012, 304, 1020, 265, 1175, 210, 1038, 51202, 162, 24307, 43687, 32993, 14478, 11832, 42242, 1100, 4780, 166912, 4270, 183, 412, 37836, 508, 2423, 210976, 32, 531028, 3218, 4933716, 42284, 243155, 115174, 22115, 163325, 42363, 24512, 2755, 42254, 83571, 42532, 35206, 55088, 2958, 1103607, 79718, 42365, 45319, 42558, 37466, 1097563, 202196804, 14033, 2711, 4188, 37492, 24550, 210705909, 962, 4253, 11860, 215027931, 8646, 204122, 166078, 36084, 404756, 517706, 7521956, 86082, 127644, 1901, 29612637, 45280, 333758, 371277, 24447)
group by page_id
having created > 20100101000000 and created < 20160101000000 and No_actors >= 10
order by page_random
limit 100
SQL

Checking query status...
