File fix reports [lvwiki]

SQL

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-.*";
SQL

Checking query status...
