USE commonswiki_p;

SELECT

 CONCAT("* [[:File:", img_name, "]]") AS file,

 img_timestamp AS img_creation

 # ^^Timestamp of when upload took place. Not necessarily the same timestamp as logging.log_timestamp. 

FROM image

JOIN page

 ON page_namespace = 6

AND page_title = img_name

JOIN categorylinks

 ON cl_from = page_id

AND cl_type = "file"

AND cl_to = "Tests" # ENTER THE CATEGORY HERE

;