Jawiki GFDL files by upload date in cat

Fork of Jawiki GFDL files by upload date by AntiCompositeNumber

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 = "草花写真館画像" #"Wikipedia_license_migration_candidates" # ENTER THE CATEGORY HERE
#WHERE 
#	tl_title = "GFDL"
#    AND tl_namespace = 10
#ORDER BY img_timestamp DESC
GROUP BY page_title ASC

SQL

Checking query status...