Jawiki No-author files in cat

Fork of Jawiki NowCommons files by upload date in cat by MGA73

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

SQL

USE jawiki_p;
SELECT CONCAT("# [[File:", page_title, "]]") as File, img_timestamp, actor_name
FROM templatelinks
JOIN page ON tl_from = page_id
JOIN image ON img_name = page_title AND page_namespace = 6
JOIN actor_image ON img_actor = actor_id
JOIN categorylinks
 ON cl_from = page_id
AND cl_type = "file"
AND cl_to = "機械的に読み取れる作者がないファイル" #Files_uploaded_by_Ribbon_-_NowCommons" #"Wikipedia_license_migration_candidates" # ENTER THE CATEGORY HERE
###WHERE 
###	tl_title = "NowCommons"
###    AND tl_namespace = 10
#ORDER BY img_timestamp DESC
GROUP BY page_title ASC

SQL

Checking query status...