Commons categories with only Wikidata Infobox categories

Created by Matěj Suchánek, requested here: https://meta.wikimedia.org/wiki/Research_talk:Quarry#c-Prototyperspective-20240924234200-Query_request

Output published at: https://commons.wikimedia.org/wiki/Commons:Report_UncategorizedCategories_with_only_infobox_categories

SQL

SELECT page_title FROM page AS P1
LEFT JOIN categorylinks ON cl_from = page_id AND cl_to NOT LIKE 'Uses\_of\_Wikidata\_Infobox%'
WHERE page_namespace = 14 AND page_is_redirect = 0 AND cl_to IS NULL
AND EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id)

AخA
 
SELECT page_title FROM page AS P1LEFT JOIN categorylinks ON cl_from = page_id AND cl_to NOT LIKE 'Uses\_of\_Wikidata\_Infobox%'WHERE page_namespace = 14 AND page_is_redirect = 0 AND cl_to IS NULLAND EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id)

SQL

Checking query status...