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
Cryptic
.
i.e., file pages on commons categorized in [[Category:Featured pictures on Wikipedia, English]] and [[Category:Self-published work]] but not in [[Category:Quality images]]. For [[WP:RAQ#The enwiki self-made work and FP, but it not the QI of commonswiki]] circa 23 July 2022.
Toggle Highlighting
SQL
SELECT page_title FROM page JOIN categorylinks AS fp ON fp.cl_from = page_id AND fp.cl_to = 'Featured_pictures_on_Wikipedia,_English' JOIN categorylinks AS sp ON sp.cl_from = page_id AND sp.cl_to = 'Self-published_work' LEFT JOIN categorylinks AS qi ON qi.cl_from = page_id AND qi.cl_to = 'Quality_images' WHERE page_namespace = 6 AND qi.cl_from IS NULL;
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...