Uncategorized Categories (with size, last user) - Commons

SQL

/** Special:UncategorizedCategories
   Executed in 1315.26 seconds as of Fri, 13 Sep 2024 11:43:06 UTC : 110 rows
**/
SELECT
  page_title as category_name,
  cat_pages as cat_size,
  if (cat_pages = 0, "-", if (cat_pages = cat_subcats, "S", if(cat_pages = cat_files, "F", "S+F"))) as cat_content,
  page_len as text_size,
  actor_name as last_user,
  left(rev_timestamp, 12) as last_edit,
  length(page_title) as len_name,
  page_is_new as is_new,
  "" as wikidata,
  page_id, 
  DATEDIFF(NOW(),rev_timestamp) as age
FROM
  revision
  JOIN (
        SELECT
          page_id, page_title, page_len, page_is_new
        FROM
          page
        WHERE
          page_namespace = 14
          AND page_is_redirect = 0
          AND NOT EXISTS ( SELECT null FROM categorylinks WHERE page_id = cl_from )
          AND page_id <> 15658   #  Category:CommonsRoot
          AND lcase(page_title) not like "%wiki%"    
  ) AS pagetmp ON rev_page = pagetmp.page_id
  JOIN actor ON rev_actor = actor_id
  JOIN category ON cat_title = pagetmp.page_title
  AND rev_timestamp = (
    SELECT
      MAX(rev_timestamp)
    FROM
      revision AS last
    WHERE
      last.rev_page = pagetmp.page_id
  )

ORDER BY
  page_id DESC
SQL

Checking query status...
