use commonswiki_p;

SELECT CONCAT("https://commons.wikimedia.org/wiki/File:", img_name ) 'link', img_timestamp 'upload date'

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 = "User_page_images"

LEFT JOIN globalimagelinks

ON gil_to = img_name

LEFT join imagelinks

ON il_to = img_name

WHERE gil_to IS NULL and il_to is NULL ;