Pagine non più orfane (calciatori)

SQL

USE itwiki_p;
SELECT DISTINCT CONCAT('[[', page_title, ']]')
FROM page, pagelinks
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Bio'))
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))
LIMIT 3406;

SQL

Checking query status...