This query is marked as a draft This query has been published by Dr Zimbu.

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.

Checking query status...