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 IN (
  SELECT il_to 
  FROM imagelinks
  WHERE il_from_namespace = 0
  GROUP BY il_to
  HAVING COUNT(il_to) > 1
)
/* LIMIT 100; */
SQL

Checking query status...
