Wikipedia:Elenchi generati offline/Redirect a potenziali disambigue

Redirect che puntano a voci contenenti i template {{Nota disambigua}} e {{Bio}}.

Query modifica

SELECT CONCAT('# [[', page_title, ']]')
FROM page, pagelinks
WHERE page_namespace = 0
AND page_is_redirect = 1
AND page_id = pl_from
AND pl_namespace = 0
AND pl_title IN
(SELECT page_title
FROM page, templatelinks
WHERE page_id = tl_from
AND tl_namespace = 10
AND page_namespace = 0
AND tl_title = 'Nota_disambigua')
AND pl_title IN
(SELECT page_title
FROM page, templatelinks
WHERE page_id = tl_from
AND tl_namespace = 10
AND page_namespace = 0
AND tl_title = 'Bio')
ORDER BY page_title

Wikipedia:Elenchi generati offline/Redirect a potenziali disambigue

Query modifica

Elenco modifica