Files on ja no file page

SQL

USE jawiki_p;
#SELECT CONCAT("# [[:File:", a.img_name, "]]") AS Wiki, CONCAT("[[:File:", b.img_name, "]]") AS Commons #, b.img_timestamp 
SELECT CONCAT("# [[:File", a.img_name, "]]") AS File
FROM image a 
LEFT JOIN page p ON p.page_title = a.img_name AND p.page_namespace = 6
WHERE p.page_title IS NULL
#INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = "コモンズへの移動により即時削除対象となったファイル" #"Files_uploaded_by_MK_Products_-_NowCommons"#

#INNER JOIN categorylinks c1 ON p.page_id = c1.cl_from
#LEFT JOIN imagelinks i ON p.page_title = i.il_to #AND (i.il_from_namespace = 0) # NS 0 = articles ; so this line is to see if file is used anywhere

#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

#WHERE i.il_from IS NOT NULL  #IS NULL = Not in use ; IS NOT NULL = In use
GROUP BY a.img_name ASC
SQL

Checking query status...
