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.