Equivalent of https://petscan.wmflabs.org/?psid=22495882 - Quarry

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.

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
ORDER BY page_id ASC;

AخA
 
SELECT page_titleFROM pageJOIN 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 NULLORDER BY page_id ASC;

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...