USE enwiki_p;

SELECT p.page_id, p.page_len, CONCAT("File:",p.page_title) as page_title FROM page p 

INNER JOIN templatelinks tAttrib ON tAttrib.tl_from = p.page_id AND tAttrib.tl_title in ('Attribution')

LEFT JOIN templatelinks t ON t.tl_from = p.page_id

                          AND t.tl_namespace = 10

                          AND t.tl_title IN ('Self', 'Own')

WHERE t.tl_from IS NULL

AND p.page_namespace = 6

​