Voci senza interlink create nel 2006 (2° trimestre)

SQL

USE itwiki_p;
SELECT DISTINCT page_title
FROM page, revision
WHERE page_id = rev_page
AND rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0
AND rev_timestamp BETWEEN 20060401000000 AND 20060701000000
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_id NOT IN
(SELECT ll_from
FROM langlinks)
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Cortometraggi%'
OR cl_to LIKE 'Dipinti%'
OR cl_to LIKE 'Film%'
OR cl_to LIKE 'Frasi%'
OR cl_to LIKE 'Prenomi%'
OR cl_to LIKE 'Vini%'
OR cl_to LIKE '%Groenlandia'
OR cl_to LIKE '%italiani'
OR cl_to LIKE '%italiani%')
AND page_id NOT IN 
	(SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Esogeologia', 'Minerale'))
ORDER BY rev_timestamp;
SQL

Checking query status...
