Untitled query #79661

SQL

SELECT page_title AS "User talk", page_len AS "Bytes" FROM page
               WHERE page_namespace = "3"
               AND page_title NOT LIKE "%/%"
               AND page_len > 400000
               ORDER BY page_len DESC LIMIT 2000;

SELECT
    page.page_title AS "User talk",
    page.page_len AS "Bytes",
    user.user_id,
    MAX(revision.rev_timestamp) AS "Most Recent Edit"
FROM
    page
JOIN
    user ON (page.page_title = CONCAT("User talk:", user.user_name))
JOIN
    revision ON (user.user_id = revision.rev_user)
WHERE
    page.page_namespace = 3
    AND page.page_title NOT LIKE "%/%"
    AND page.page_len > 400000
GROUP BY
    user.user_id
ORDER BY
    page.page_len DESC
LIMIT 2000;
SQL

Checking query status...
