Files hiding Commons files (lvwiki)

SQL

USE lvwiki_p;
SELECT CONCAT('* [[:Attēls:',e.img_name,']]') as "LV WIKI", CONCAT('— [[:c:File:',e.img_name,']]') as "Commons" FROM image e
INNER JOIN commonswiki_p.image c ON c.img_name = e.img_name AND c.img_sha1 != e.img_sha1
INNER JOIN
  (page p LEFT JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to = 'Wikipedia_files_that_shadow_a_file_on_Wikimedia_Commons')
ON p.page_title = e.img_name AND p.page_namespace = 6
WHERE cl.cl_from IS NULL
/*
USE lvwiki_p;
SELECT e.img_name FROM image e
INNER JOIN commonswiki_p.image c ON c.img_name = e.img_name AND c.img_sha1 != e.img_sha1
INNER JOIN
  (page p LEFT JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to = 'Wikipedia_files_that_shadow_a_file_on_Wikimedia_Commons')
ON p.page_title = e.img_name AND p.page_namespace = 6
WHERE cl.cl_from IS NULL

USE lvwiki_p;
SELECT e.img_name FROM image e
INNER JOIN commonswiki_p.image c ON c.img_name = e.img_name AND c.img_sha1 != e.img_sha1
INNER JOIN
  (page p LEFT JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to = 'Wikipedia_files_that_shadow_a_file_on_Wikimedia_Commons')
ON p.page_title = e.img_name AND p.page_namespace = 6
WHERE cl.cl_from IS NULL
*/
SQL

Checking query status...
