userpages - Quarry

SQL

USE enwiki_p;
SELECT CONCAT('# [[User:', page_title, ']]') AS page_title, page_len, user_editcount
FROM page, revision, user
WHERE page.page_id = revision.rev_page
and page_len > 3000
and revision.rev_user = user.user_id
AND page_namespace = 2 and page_title not like "%/%"
AND rev_parent_id = 0
and user_editcount < 51
#and page_id in (select el_from from externallinks)
and rev_user in (select ipb_user from ipblocks)
page_id not in
(select distinct cl_from from categorylinks
where cl_to like "Wikipedia_sockpuppets%")
ORDER BY page_len desc
/*24079
USE enwiki_p;
SELECT CONCAT('# [[User:', page_title, ']]') AS page_title, page_len, user_editcount
FROM page, revision, user
WHERE page.page_id = revision.rev_page
and page_len > 1000
and revision.rev_user = user.user_id
AND page_namespace = 2
AND rev_parent_id = 0
and user_editcount < 51
ORDER BY page_len desc
*/
SQL

Checking query status...
