Wikipedia:Database reports/Long pages - enwiki

Fork of Wikipedia:Database reports/Long pages - enwiki by Edgars2007

This query is marked as a draft This query has been published by Praxidicae.

SQL

SELECT
	concat('{{Dbr link|1={{ns:',page_namespace,'}}:',page_title,'}}') as "Page",
    concat('{{#time:H:i, F j, Y|',rev_timestamp,'}}') as "Last edit",
    concat('{{formatnum:',page_len,'}}') as "Past length",
    concat('{{PAGESIZE:{{ns:',page_namespace,'}}:',page_title,'}}') as "Current length"
FROM page
JOIN revision
ON rev_page = page_id
WHERE page_len > 175000
AND page_title NOT LIKE "%/%"
AND page_namespace != 3
AND page_namespace mod 2 != 0
AND rev_timestamp = (SELECT
                       MAX(rev_timestamp)
                     FROM revision
                     WHERE rev_page = page_id)
ORDER BY page_len, page_namespace ASC;

SQL

Checking query status...