File fix reports [lvwiki]

SQL

use lvwiki_p;
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;


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;
SQL

Checking query status...
