Voci senza uscita non segnalate

SQL

USE itwiki_p;
SELECT CONCAT('[[', page_title, ']]')
FROM page, revision
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id = rev_page
AND rev_parent_id = 0
AND rev_timestamp < 20200401000000
AND page_id NOT IN
(SELECT pl_from
FROM pagelinks
WHERE pl_namespace = 0
AND 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...
