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
Jarekt
.
Toggle Highlighting
SQL
SELECT concat("File:",file.page_title) as filename , concat("Creator:",creator.page_title) as creatorname FROM page as file JOIN categorylinks AS c1 ON c1.cl_from = file.page_id AND c1.cl_to = 'Photographs_of_paintings_by_User:Sailko' JOIN categorylinks AS c2 ON c2.cl_from = file.page_id AND c2.cl_to = 'Paintings_without_Wikidata_item' JOIN categorylinks AS c3 ON c3.cl_from = file.page_id JOIN categorylinks AS c4 ON c4.cl_to = c3.cl_to join page as creator on c4.cl_from = creator.page_id and creator.page_namespace = 100 WHERE file.page_namespace = 6 AND NOT EXISTS ( SELECT * FROM templatelinks WHERE creator.page_id = tl_from AND tl_title ='Creator' AND tl_namespace = 10 ) limit 10000
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...