Untitled query #67350

SQL

select actor_id, actor_user, actor_name, page_title, page_id, count(*)
from actor, page, revision
where actor_id in (17, 2423, 2838, 3668, 4310, 5909, 7674, 8826, 11702, 16358, 20827, 24295, 25216, 25319, 25379, 30798, 44068, 46571, 59597, 65582, 73448, 85568, 98846, 101364, 102343, 116914, 161961, 172180, 261589, 335488, 399868, 624805, 626918, 628365, 704864, 721999, 787572, 846980, 851973, 888205, 921393, 981233, 1029871, 1121383, 1241008, 1267045, 1321450, 1341087, 1382755, 1395686, 1558511, 1602170, 1614839, 1777581, 1847701, 2092950, 2234176, 2319647, 2631238, 2637202, 2880176, 2910542, 3123449, 3160108, 3337064, 3684388, 3915788, 3956302, 4554980, 4639611, 4818922, 6225514, 6875763, 7068618, 7207880, 7328233, 7434533, 7549960, 7593160, 7638286, 7916256, 8204421, 8301854, 8568812, 9063635, 9164525, 9166362, 9196244, 9203779, 9289403, 9294047, 9339369, 9370749, 36777198, 107788662, 107797438, 107930360, 108459482, 109711118, 109954715, 110171349, 111280087, 111603824, 112002872, 113281329, 114314043, 114729725, 116445830, 116497058, 116500734, 116701296, 117125634, 117542140, 119250205, 119435612, 119949772, 120281049, 120397054, 120492403, 120548135, 120622797, 120654654, 120761909, 120789840, 120806613, 120867036, 120875334, 120892396, 120905440, 120909193, 120910142, 120928566, 120929641, 120932839, 120966017, 120978856, 120987336, 120994196, 121014230, 121034903, 121041155, 121060003, 121065673, 121069906, 121087902, 121088077, 121094030, 121138955, 121150270, 121177069, 121233759, 121275203, 121277854, 121282365, 121301876, 121320138, 121356293, 121399918, 121401805, 121407667, 121431782, 121435727, 121438113, 121445727, 121446271, 121531305, 121537588, 121548869)
and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0 and page_namespace = 0
	and rev_timestamp < 20080917191159
group by actor_id, page_id
having count(*) >= 5
order by count(*) desc
SQL

Checking query status...
