WP duplicates for commons files

SQL

use enwiki_p;
select CONCAT('[[File:',i1.img_name,']]'), CONCAT('/',i1.img_user_text), i2.img_name, i2.img_user_text
/*,
CONCAT('/',img_width), CONCAT('/',img_height), CONCAT('/',img_size), 
CONCAT('/',img_timestamp), CONCAT('/',img_sha1)*/
from image i1
   join page on i1.img_name = page_title and page_namespace = 6
join commonswiki_p.image i2 on i1.img_sha1 = i2.img_sha1
where i1.img_name <> i2.img_name
and page_id not in
(select distinct cl_from from categorylinks
where cl_to in ("Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept",
                "Wikipedia_files_not_suitable_for_Commons")
or cl_to like "Copy_to_Wikimedia_Commons%")
/*
from image
where img_name not in (select img_name from commonswiki_p.image) and 
img_sha1 in (select img_sha1 from commonswiki_p.image)*/
SQL

Checking query status...
