Fork of Hewiki fair use unused pictures 1 by יונה בנדלאק
This query is marked as a draft This query has been published by IKhitron.

SQL

x
 
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 not
replace(page_title, "_", " ") = "Amud Anan Search 0.png" and not exists (select * from pagelinks where pl_from = 1282376 and page_title
= pl_title)
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...