This query is marked as a draft This query has been published by FShbib.

SQL

AخA
 
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, 12, 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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...