Registered users who need to be welcomed

Looks for registered users who have edited recently, have >= 50 edits, and no talk page.  Most of these users should probably be welcomed and thanked for their contributions.

To do:
-Use recent changes table instead of rev
-Filter out reverted and user space edits from users' edit count, if this can be done in a performance-minded way
-Look at potentially including IP users (more difficult: will need to only look at counting recent contribs).  Maybe a separate query with a UNION ALL.

SQL

WITH active_actors AS (
	SELECT DISTINCT r.rev_actor
	FROM enwiki_p.revision_userindex r
	WHERE r.rev_deleted = 0
	ORDER BY r.rev_timestamp DESC
    LIMIT 20000
)

SELECT CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', a.actor_name) AS 'User'
FROM active_actors aa
INNER JOIN enwiki_p.actor_revision a ON aa.rev_actor = a.actor_id AND a.actor_user IS NOT NULL
INNER JOIN enwiki_p.user u ON a.actor_user = u.user_id
LEFT JOIN enwiki_p.page p ON p.page_title = REPLACE(a.actor_name, ' ', '_') AND p.page_namespace = 3
WHERE u.user_editcount >= 50
AND p.page_title IS NULL

SQL

Checking query status...