Wikipedia:Elenchi generati offline/Redirect a discussioni

L'elenco contiene i redirect a discussioni dei namespace principale, template, categoria, portale e progetto orfani e non orfani.

Orfani

Query (per toolserver)

SELECT CONCAT('#[[', ns_name, ':', page_title, ']]')
  FROM page AS p1 JOIN toolserver.namespace ON page_namespace = ns_id
  WHERE page_is_redirect = 1 AND page_namespace IN (1, 11, 15, 101, 103)
    AND dbname = 'itwiki_p'
    AND NOT EXISTS( SELECT * 
      FROM pagelinks JOIN page AS p2 ON pl_from = p2.page_id 
      WHERE pl_title = p1.page_title AND pl_namespace= p1.page_namespace 
        AND p2.page_namespace != 4 AND p2.page_title != 'Elenchi_generati_offline/Redirect_a_discussioni')
  ORDER BY ns_id, page_title;