redirect orfani su it.wiki

SQL

USE itwiki_p;
SELECT CONCAT('# [[', page_title, ']] - [[', rd_title, ']] ([[Speciale:PuntanoQui/', page_title, ']])')
  FROM page JOIN redirect ON page_id=rd_from
  WHERE page_namespace=0 AND rd_namespace = 0 AND page_title LIKE "Al%" AND NOT [[Categoria:Redirect da mantenere orfani]]
    AND NOT EXISTS ( SELECT * 
      FROM page AS p JOIN pagelinks ON p.page_id = pl_from 
        WHERE p.page_namespace IN (0, 4, 10, 12, 100, 102) AND pl_namespace = 0 AND pl_title = page.page_title)
  ORDER BY page_title
  LIMIT 50
  #GROUP BY oi_name
  #ORDER BY page_title
  #DESC
  ;
SQL

Checking query status...
