Special:UncategorizedCategories for Commonswiki (with Wikidata)

Fork of Uncategorized Categories (basic) - Commons by Enhancing999

This query is marked as a draft This query has been published by Fl.schmitt.

Uncategorized categories on Commonswiki. Report includes:
* Wikidata item (if present)
A Wikidata item should generally not be present, but for some reason is (109 of 1162 categories on 2024-08-24).

More detail is available through the following query:
https://quarry.wmcloud.org/query/85733

Compare with
https://commons.wikimedia.org/wiki/Special:UncategorizedCategories

See
https://commons.wikimedia.org/wiki/Commons:Bots/Work_requests#Generate_a_daily_database_report_equivalent_of_Special:UncategorizedCategories

SQL

/** Test **/
SELECT *
FROM `page` 
LEFT JOIN `categorylinks` ON ((cl_from = page_id)) 
WHERE cl_from IS NULL 
AND page_namespace = 14
AND page_is_redirect = 0  
ORDER BY page_title
LIMIT 5000

SQL

Checking query status...