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 EXISTS ( SELECT * 
      FROM page AS p JOIN (pagelinks, categorylinks) ON p.page_id = pl_from AND p.page_id = cl_from
        WHERE p.page_namespace IN (0, 4, 10, 12, 100, 102) AND pl_namespace = 0 AND pl_title = page.page_title AND NOT cat_title = 'Redirect_da_mantenere_orfani')
  ORDER BY page_title
  LIMIT 50
  #GROUP BY oi_name
  #ORDER BY page_title
  #DESC
  ;
SQL

Checking query status...
