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

SQL

AخA
 
use hewiki_p; select distinct img_timestamp, replace(page_title, "_", " ") as Suspicious_file_title from page as p1 join image where exists
(select * from templatelinks where tl_from = page_id and exists (select * from page as p3 where p3.page_namespace = 10 and p3.page_title =
tl_title and exists (select * from categorylinks where p3.page_id = cl_from and cl_to = "תבניות_תמונות_שימוש_הוגן"
                    and not p3.page_title = "תמונות_שהועלו_שלא_בהתאם_להנחיות"
                    )) and tl_namespace = 10)
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"
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...