userpages - Quarry

SQL

USE enwiki_p;
SELECT CONCAT('#[[User:',log_title,']]') AS page_title, LEFT(log_timestamp, 8) AS date, log_user_text, log_comment
FROM logging
WHERE log_type = 'delete'
AND log_action = 'delete'
and log_namespace = 2 #and log_user_text = "Anthony Bradbury"
and log_timestamp between 20161204195058 and 20161207195058
order by log_timestamp desc
limit 600/**/
/*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...
