SQL
AخA
USE itwiki_p;
SELECT CONCAT('# [[Template:', page_title, ']] -> [[', pl_title, ']]')
FROM pagelinks,
page
WHERE page_namespace = 10
AND page_id = pl_from
AND pl_namespace = 0
AND pl_title IN
(SELECT page_title
FROM pagelinks,
page
WHERE page_namespace = 0
AND page_id = pl_from
AND page_is_redirect = 1
AND pl_title IN
(SELECT page_title
FROM page_props,
page
WHERE pp_page = page_id
AND page_namespace = 0
AND pp_propname = 'disambiguation')
UNION SELECT page_title
FROM page_props,
page
WHERE pp_page = page_id
AND page_namespace = 0
AND pp_propname = 'disambiguation')
AND page_title NOT LIKE '%/man'
AND page_title NOT LIKE '%/man/%'
AND page_title NOT REGEXP '[^/]*/(S|s)andbox'
AND page_title NOT REGEXP '[^/]*/(T|t)est'
AND page_title NOT REGEXP '[^/]*/(E|e)sempi'
AND page_title NOT REGEXP '[^/]*/(P|p)rove'
AND page_title NOT LIKE 'Nota_disambigua%'
ORDER BY page_title;
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.