USE enwiki_p;

SELECT CONCAT('*[[:en:File:', Replace(p.page_title, '_', ' '), ']] ([[:en:', Replace(pgArticle.page_tile, '_', ' '), ']])')

FROM page p

INNER JOIN imagelinks i ON p.page_title = i.il_to

INNER JOIN page pgArticle ON pgArticle.page_id = i.il_from

INNER JOIN categorylinks c1 ON i.il_from = c1.cl_from AND c1.cl_to LIKE '1923%' AND c1.cl_to <> '1923 births'

INNER JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "All_non-free_media"

​