userpages - Quarry

SQL

USE enwiki_p;
SELECT CONCAT('# [[User:',ar_title,']]') AS page_title, GROUP_CONCAT(cl_to SEPARATOR ';')
   FROM archive #join page on page_id=ar_page_id
   join categorylinks on ar_page_id=cl_from and ar_namespace = 2
   where cl_to like "Wikipedia_sockpuppets%" #or cl_to like "Suspected_Wikipedia%"
   group by ar_title
   limit 50
/*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)
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...
