User talks by length (edited in the last 90 days)

SQL

SELECT DISTINCT page_title,ROUND(page_len/1024,2) AS 'page length in kB',
	CONCAT('https://en.wikipedia.org/wiki/User_talk:',page_title),
    actor_name AS username
FROM page
	INNER JOIN actor ON actor_name=page_title
    INNER JOIN recentchanges ON rc_actor # All pages whose users have not edited within the last 30 days are excluded (hopefully).
WHERE page_namespace=3 # Change to 3 for user talks
    # AND page_title NOT LIKE "%/%" # Avoid subpages, not necessary given inner join not matching on subpages. But excludes primary subs.
    # AND EXISTS (SELECT DISTINCT rc_actor FROM recentchanges WHERE rc_actor=user_id) try by joining directly for performance reasons.
ORDER BY page_len DESC
LIMIT 100

SQL

Checking query status...