File EDP usati in NS0 in più di una voce

SQL

USE itwiki_p;
SELECT CONCAT("*[[File:", page_title, ']]') FROM page 
WHERE page_namespace = 6
AND page_id IN (
  SELECT cl_from
    FROM categorylinks
	WHERE cl_to IN ("Immagini_non_commerciali", "Autorizzate_per_Wikipedia", "Screenshot_copyrighted_videogiochi",
                    "Screenshot_copyrighted", "Screenshot_copyrighted_video musicali", "Screenshot_copyrighted_televisione",
                    "Screenshot_copyrighted_software", "Screenshot_copyrighted_film", "Immagini_protette_non_libere_-_EDP")
)
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, pagelinks
   WHERE page_namespace=0
   AND page_is_redirect=1
   AND pl_namespace IS NULL)
)
LIMIT 100;
SQL

Checking query status...
