File in EDP usati fuori da ns 0

Fork of File in EDP usati in > 1 voci by Ruthven

This query is marked as a draft This query has been published by Ruthven.

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_from_namespace
)

SQL

Checking query status...