New accounts with archives

SQL

SELECT CONCAT ("User:", SUBSTRING_INDEX(pl_title, "/", 1)) as "user", user_registration
FROM pagelinks, templatelinks, linktarget, `user`
WHERE pl_from_namespace=3 AND pl_namespace=3 AND pl_title LIKE "%/Archive_1"
AND tl_from=pl_from
AND lt_id=tl_target_id AND lt_namespace=10 AND lt_title="Archives"
AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace=3 AND page_title=pl_title)
AND user_name = SUBSTRING_INDEX(pl_title, "/", 1) AND user_registration >= '20220101'
ORDER BY user_registration
/*ORDER BY pl_title*/
SQL

Checking query status...
