En FU files to review for PD-1924

SQL

USE enwiki_p;
SELECT CONCAT('*[[:en:File:', Replace(p.page_title, '_', ' '), ']] ([[:en:', Replace(pg.page_title, '_', ' '), ']] - [[:en:Category:', c1.cl_to, ']])')
FROM page p
INNER JOIN imagelinks i ON p.page_title = i.il_to
INNER JOIN page pg ON pg.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' AND c1.cl_to <> '1923_deaths')
           OR (c1.cl_to LIKE '%1923'))
INNER JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "All_non-free_media"
WHERE c1.cl_to not like '%British%'
AND c1.cl_to not like '%Turkey%'
AND c1.cl_to not like '1923_establishments%'
AND c1.cl_to not like '%established_in_1923'
AND c1.cl_to not like '%_set_in_1923'
SQL

Checking query status...
