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

/**
 Executed in 1098.01 seconds as of Mon, 26 Aug 2024 06:43:15 UTC: 952 rows, replication lag 18 minutes
 Executed in 713.02 seconds as of Mon, 26 Aug 2024 08:28:02 UTC: 916 rows, replication lag 11 minutes
**/
SELECT 
 concat('Category:', REPLACE(page_title,'_',' '),'') as category_name,
 length(page_title) as len_name,
 left(page_touched,12) as date_last, 
 page_len as text_size,
 page_is_new as is_new, 
 page_id
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_id DESC

SQL

Checking query status...