Files on ja in use or on commons

Fork of Files on ja also on Commons with filenames by usercat by MGA73

This query is marked as a draft This query has been published by MGA73.

SQL

USE jawiki_p;
SELECT CONCAT("# [[:File:", a.img_name, "]]") AS Wiki, CONCAT("[[:File:", b.img_name, "]]") AS Commons, b.img_timestamp 
FROM image a 
INNER JOIN page p ON p.page_title = a.img_name AND p.page_namespace = 6
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = "Locator_maps_of_municipalities_in_Japan_based_on_maps_by_Lincun" #"Files_uploaded_by_みんと_-_NowCommons"
#join commonswiki_p.image b on b.img_name != a.img_name and b.img_sha1 = a.img_sha1 #Dif name only
join commonswiki_p.image b on b.img_sha1 = a.img_sha1                             #All files
#WHERE b.img_timestamp > 20200600000000
GROUP BY a.img_name ASC

SQL

Checking query status...