SQL
AخA
SELECT CONCAT('Talk:', page_title)
FROM page
JOIN linktarget ON lt_namespace = 10 AND lt_title = 'WikiProject_banner_shell'
LEFT JOIN templatelinks ON tl_from = page_id AND tl_target_id = lt_id
WHERE page_namespace = 1
AND page_is_redirect = 0
AND page_title NOT LIKE '%/Archive%'
AND page_title NOT LIKE '%/archive%'
AND tl_from IS NULL
LIMIT 10000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.