Unused fair use files (arwiki)

SQL

use arwiki_p;
select concat('# [[:ملف:', replace(page_title, "_", " "), ']]') as Suspicious_file_title
from page as p1
join image 
on exists (select *
           from categorylinks as cl1
           where cl_from = page_id
           and (cl_to = "جميع_الملفات_غير_الحرة"
or exists (select *
           from page as p2
           where p2.page_namespace = 14
           and p2.page_title = cl1.cl_to 
and exists (select *
            from categorylinks as cl2
            where cl2.cl_from = p2.page_id
            and (cl2.cl_to = "جميع_الملفات_غير_الحرة"
or exists (select *
           from page as p3
           where p3.page_namespace = 14
           and p3.page_title = cl2.cl_to
and exists (select *
            from categorylinks as cl3
            where cl3.cl_from = p3.page_id
            and (cl3.cl_to ="جميع_الملفات_غير_الحرة"))))))))
and page_namespace = 6
and not exists (select *
                from imagelinks
                where il_to = page_title
                and il_from_namespace in (0, 1, 2, 3, 4, 5, 11, 100, 118))
                and img_name = page_title
                and datediff(now(), img_timestamp) > 7
and page_id not IN (SELECT tl_from FROM templatelinks where tl_title = 'صورة_استعمال_عادل_يتيمة')  #Remove # to find untagged files
SQL

Checking query status...
