Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
IKhitron
.
Toggle Highlighting
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 img_name = page_title and datediff(now(), img_timestamp) > 7 and not replace(page_title, "_", " ") in ("Asa-jer.jpg", "Yosef Perlmutter speaking at Takam meeting.jpg", "Rotor Wolgograd 2013.svg", "Yosef Perlmutter speaking at Takam meeting in Kibbutz Hulda.jpg", "ישיבת מזכירות התק״ם.jpg", "Eshet Tours.svg", "נא לגעת.jpg", "Irjabar.jpg", "HeathenChemistryOasisalbumcover.jpg", "Oasis Be Here Now album cover.jpg", "Oasis Dont Believe the Truth.jpg", "StandingontheShoulderofGiantsOasisalbumcover.jpg", "Ziknei Tzfat I.jpg", "254px-ObelisktheTormentorJMP-EN-ScR-LE.png", "Exploited.jpg", "Roger daltrey solo cover.jpg", "RudessListen.jpg", "RudessListen.jpg", "RudessRhythmofTime.jpg")
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...