Voci orfane per dimensioni (senza page_len)

SQL

USE itwiki_p;
SELECT DISTINCT CONCAT('[[', page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411)
AND page_title NOT 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))
ORDER BY page_len DESC;

SQL

Checking query status...