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
**/
SELECT 
 concat('[[:Category:', REPLACE(page_title,'_',' '),']]') as category_name,
 left(page_touched,12) as date_last, 
 page_len as text_size,
 page_is_new as is_new, 
 page_id,
 Lcase( CONCAT(REGEXP_REPLACE( page_title,"[-\_\.'\(\),]+"," "),"")) as words
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 50
/** ORDER by page_id DESC **/

SQL

Checking query status...