Pagine non più orfane (calciatori)

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 page_id
    FROM page JOIN redirect ON page_id=rd_from
    WHERE page_namespace=0 AND rd_namespace = 0 
    AND NOT EXISTS (
      SELECT pl_title
      FROM pagelinks
      WHERE 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...
