Untitled query #47151

SQL

SELECT CONCAT("# [[:File:", hiwiki_p.img_name, "]]") AS Wiki, 
CONCAT("[[:File:", commonswiki_p.img_name, "]]") AS Commons, 
commonswiki_p.img_timestamp, 
hiwiki_p.log_timestamp, 
hiwiki_p.log_type
FROM hiwiki_p.image a 
INNER JOIN hiwiki_p.page ON hiwiki_p.page_title = hiwiki_p.img_name AND hiwiki_p.page_namespace = 6
INNER JOIN hiwiki_p.categorylinks ON hiwiki_p.cl_from = hiwiki_p.page_id # AND c.cl_to = "コモンズへの移動により即時削除対象となったファイル"
#JOIN commonswiki_p.image b on b.img_name != hiwiki_p.img_name and b.img_sha1 = hiwiki_p.img_sha1 #Dif name only
join commonswiki_p.image on commonswiki_p.img_sha1 = hiwiki_p.img_sha1                             #All files
#WHERE b.img_timestamp > 20200600000000
# JOIN commonswiki_p.logging d on d.log_title = b.img_name
LEFT JOIN hiwiki_p.logging on hiwiki_p.log_title = hiwiki_p.img_name
#log_timestamp FROM logging WHERE log_type = "upload"
#LEFT JOIN commonswiki_p.page y ON b.img_name = y.page_title
#LEFT JOIN commonswiki_p.logging d ON y.page_title = d.log_title
#WHERE d.log_type = "upload"
GROUP BY hiwiki_p.img_name ASC;
SQL

Checking query status...
