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
group by user_page
ORDER BY page_in_WP_NS asc
/*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...
