use lvwiki_p;

#http://tools.wmflabs.org/lists/itwiki/File/File_duplicati

SELECT CONCAT( "# [[:File:", img1.img_name, "]] identica a [[:File:", img2.img_name, "]]" )

FROM image AS img1

JOIN image AS img2 ON img1.img_sha1 = img2.img_sha1

AND img1.img_name <> img2.img_name

WHERE img1.img_sha1 <> ''

#AND img1.img_name NOT REGEXP 'Stub_.*'

#AND img2.img_name NOT REGEXP 'Stub_.*'

GROUP BY img1.img_sha1

ORDER BY img1.img_name;

​

#http://tools.wmflabs.org/lists/itwiki/File/File_senza_pagina_di_descrizione

SELECT CONCAT("# [[:File:", img_name, "]]")

FROM image

WHERE img_name NOT IN (

    SELECT page_title

    FROM page

    WHERE page_namespace LIKE 6)

  ORDER BY img_name;

#http://tools.wmflabs.org/lists/itwiki/File/File_su_Commons_con_pagina_locale

  SELECT CONCAT('# [[:File:', page_title, ']]')

FROM page

WHERE page_namespace = 6

AND page_is_redirect = 0

AND page_title NOT IN

(SELECT img_name

FROM image)

ORDER BY page_title;

​

#http://tools.wmflabs.org/lists/itwiki/File/Immagini/Immagini_orfane

SELECT CONCAT('# [[:File:', page_title, ']]')

FROM page

WHERE page_namespace = 6

AND page_is_redirect = 0

AND page_title NOT IN

(SELECT il_to

FROM imagelinks)

AND page_title IN

(SELECT img_name

FROM image)

ORDER BY page_title;

​

#http://tools.wmflabs.org/lists/itwiki/File/Immagini/Immagini_potenzialmente_ridimensionate

SELECT CONCAT ("* [[:File:", img_name, "]]")

  FROM image 

  WHERE img_name REGEXP "^[0-9]{1,4}px-.*";

​