Fork of Untitled query #12313 by IKhitron
This query is marked as a draft This query has been published by IKhitron.

SQL

​x
 
use hewiki_p;
select * from page
where page_title = "Channel_10_logo.jpg";
select * from page
where page_title = "לוגו_תאגיד_מדרשת_שדה_בוקר.png";
select * from page
where page_title = "Untitled.jpg";
select * from page
where page_title = "בדיקה.jpg";
select * from image
where img_name = "Untitled.jpg";
select * from image
where img_name = "בדיקה.jpg";
select * from image
where img_name = "לוגו_תאגיד_מדרשת_שדה_בוקר.png";
select * from page
where page_title = "MapRSLCcentro_storico.png";
select * from image
where img_name = "MapRSLCcentro_storico.png";
select * from image
where not exists
(select * from page
 where page_title = img_name
 and page_namespace = 6);
select * from page
where page_namespace = 6
and not page_is_redirect
and not exists
(select * from image
 where page_title = img_name) 
and not exists
(select * from commonswiki_p.image
 where page_title = img_name) 
​
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
All SQL code is licensed under CC0 License.

Checking query status...