SQL
AخA
USE wikidatawiki_p;
SELECT CONCAT("Talk:",page_title) AS link, page_len, rev_user_text,
CONCAT("[https://wikidata.org/wiki/?curid=", page_id, "?action=delete delete]") AS delete_link
FROM page
LEFT JOIN pagelinks
ON pl_from = page_id
JOIN revision
ON rev_id = page_latest
WHERE page_namespace = 1 AND pl_title IS NULL
ORDER BY page_len;
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.