Hewiki fair use unused pictures 1

SQL

use hewiki_p;
select #img_timestamp, 
replace(page_title, "_", " ") as Suspicious_file_title from categorylinks as cl1 join page as p1 join image
on (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 cl_from = page_id
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, 100)
)
and img_name = page_title
and datediff(now(), img_timestamp) > 7
#and not replace(page_title, "_", " ") in ("2015 UEFA European Under-21 Championship.png", "תיאטרון הפרינג' באר שבע.jpg", "סמל המכללה.jpg",
#"רבי סיני מזימגראד.JPG", "NewEnoshLogo.JPG", "ג'נטלמן.jpg", "Zootopia D23-610x258.jpg", "ציון הצדיוק מיבנאל.jpg")
SQL

Checking query status...
