Uncategorized Categories (basic) - Commons

Uncategorized categories on Commonswiki. 

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

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

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)) 
LEFT JOIN page_props AS pp2 ON pp2.pp_page = page_id
WHERE cl_from IS NULL 
AND page_namespace = 14
AND page_is_redirect = 0 
AND page_props.pp_propname='wikibase_item'
LIMIT 10

​x
 
/** Test **/SELECT *FROM `page` LEFT JOIN `categorylinks` ON ((cl_from = page_id)) LEFT JOIN page_props AS pp2 ON pp2.pp_page = page_idWHERE cl_from IS NULL AND page_namespace = 14AND page_is_redirect = 0 AND page_props.pp_propname='wikibase_item'LIMIT 10​

SQL

Checking query status...