Non-free files used outside articles (arwiki)

SQL

USE arwiki_p;
SELECT concat("[[:ملف:",REPLACE(p.page_title, '_', ' '),"]]"), p2.page_namespace, p2.page_title
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
INNER JOIN (imagelinks i LEFT JOIN redirect r ON i.il_from = r.rd_from) ON p.page_title = i.il_to
INNER JOIN page p2 ON p2.page_id = i.il_from
WHERE c.cl_to IN ("أغلفة_ألعاب_فيديو"
                 ,"أغلفة_دي_في_دي"
                 ,"استخدام_عادل_في..")
AND i.il_from_namespace != 0
and i.il_from_namespace!=2
AND r.rd_from IS NULL

SQL

Checking query status...