ckb: registered users who need to be welcomed

SQL

WITH active_actors AS (
	SELECT DISTINCT r.rev_actor
	FROM ckbwiki_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 ckbwiki_p.actor_revision a ON aa.rev_actor = a.actor_id AND a.actor_user IS NOT NULL
INNER JOIN ckbwiki_p.user u ON a.actor_user = u.user_id
LEFT JOIN ckbwiki_p.page p ON p.page_title = REPLACE(a.actor_name, ' ', '_') AND p.page_namespace = 3
WHERE u.user_editcount >= 20
AND p.page_title IS NULL

SQL

Checking query status...