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
 Executed in 1625.74 seconds as of Sat, 24 Aug 2024 21:17:10 UTC: 1162 rows

**/
SELECT 
 page_title as category, 
 page_is_new as is_new, 
 left(page_touched,12) as date_last_edit, 
 page_len as text_size, 
 pp_value as wikidata_item, 
 page_id
FROM page_props
RIGHT JOIN (
SELECT page_id, page_title, page_is_new, page_touched, page_len
FROM `page` 
LEFT JOIN `categorylinks` ON (cl_from = page_id)
WHERE cl_from IS NULL 
AND page_namespace = 14
AND page_is_redirect = 0 
LIMIT 2000
  ) AS pagetmp ON pp_page = pagetmp.page_id
AND pp_propname='wikibase_item'

SQL

Checking query status...