Voci con tag O "non orfane"

SQL

SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title IN (
	SELECT pl_title
	FROM pagelinks
	WHERE pl_from_namespace = 0
	AND pl_namespace = 0
	AND pl_title = page_title
    AND pl_from NOT IN (SELECT cl_from
    FROM categorylinks, pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411)
    AND pl_from NOT IN (SELECT cl_from
    FROM categorylinks
    WHERE cl_to LIKE 'Prenomi%')
    AND pl_from NOT IN (SELECT cl_from
    FROM categorylinks
    WHERE cl_to LIKE 'Cognomi%')
    AND pl_from NOT IN (SELECT page_id
                        FROM page
                        WHERE page_is_redirect = 1)
   AND pl_from NOT IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('U'))
  AND pl_from NOT IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Nota_disambigua'))
)
AND page_id IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('O'))
ORDER BY page_len DESC;
SQL

Checking query status...
