USE elwiki_p;

SELECT DISTINCT CONCAT('| [[:{{ns:', i.il_from_namespace, '}}:',  p.page_title, ']] ||[[:Αρχείο:', i_p.page_title, ']]') 

FROM page p

INNER JOIN imagelinks i ON i.il_from = p.page_id 

                        AND i.il_from_namespace <> 0

INNER JOIN page i_p ON i.il_to = i_p.page_title AND 1 <> p.page_is_redirect

INNER JOIN categorylinks c2 ON i_p.page_id = c2.cl_from AND c2.cl_to = "Αρχεία_εύλογης_χρήσης"

INNER JOIN revision r ON p.page_latest = r.rev_id

LIMIT 5000