Voci senza uscita non segnalate

SQL

USE itwiki_p;
SELECT CONCAT('[[', page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
/*AND page_len > 10000
AND page_len < 1000*/
AND page_title NOT IN (
  SELECT DISTINCT lt_title FROM linktarget
  WHERE lt_namespace = 0
  AND lt_id IN (
    SELECT pl_target_id
	FROM pagelinks
	WHERE pl_from_namespace = 0
  )
)
AND page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
AND page_id NOT IN
(SELECT pr_page
 FROM page_restrictions)
AND page_id NOT IN 
(SELECT cl_from
    FROM categorylinks
    WHERE cl_to = 'Voci_senza_uscita')
ORDER BY page_title;
/*LIMIT 1;*/
SQL

Checking query status...
