userpages - Quarry

SQL

USE enwiki_p;
select CONCAT('#[[Wikipedia:',page_title,']]') AS page_in_WP_NS, CONCAT('// [[User:',pl2.pl_title']]') as user_page
from page
join pagelinks pl2 on pl2.pl_from = page_id and page_namespace = 4
       AND page_is_redirect = 0 and pl2.pl_namespace = 2 and pl2.pl_from_namespace = 4
join pagelinks pl1 on pl1.pl_title = pl2.pl_title and pl1.pl_from = 36717948 and pl1.pl_namespace = 2
#where pl_title in (select pl_title FROM enwiki_p.pagelinks pl1 where pl1.pl_from = 43401631)
ORDER BY page_title
/*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...
