Untitled query #75001

SQL

SELECT CONCAT("https://uk.wikipedia.org/wiki/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 = "Файли:PD-old-70" #"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...
