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;
DESCRIBE revision;

SELECT 
    p.page_title AS "User talk", 
    p.page_len AS "Bytes", 
    u.user_id,
    MAX(r.rev_timestamp) AS "Most Recent Edit"
FROM 
    page AS p
JOIN 
    user AS u ON u.user_name = REPLACE(p.page_title, 'User talk:', '')
JOIN 
    actor AS a ON u.user_id = a.actor_user
JOIN 
    revision AS r ON a.actor_id = r.rev_actor
WHERE 
    p.page_namespace = 3
    AND p.page_title NOT LIKE '%/%'
    AND p.page_len > 400000
GROUP BY 
    p.page_title, p.page_len, u.user_id
ORDER BY 
    p.page_len DESC 
LIMIT 2000;
SQL

Checking query status...
