Untitled query #86022

SQL

/** Special:UncategorizedCategories

**/
SELECT 
 page_title as category, 
 cat_pages as cat_size, 
 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 
FROM
  revision
  JOIN actor ON rev_actor = actor_id
  JOIN (
    SELECT
      page_id,
      page_title,
      page_len, page_is_new, 
  	  cat_pages, 
      if (cat_pages = 0, "-", if (cat_pages = cat_subcats, "S", if(cat_pages = cat_files, "F", "S+F"))) as cat_content
    FROM
      category
      RIGHT JOIN page ON cat_title = page_title
      LEFT JOIN categorylinks ON page_id = cl_from
    WHERE
      cl_from IS NULL
      AND page_namespace = 14
      AND page_is_redirect = 0
    LIMIT 2000
  ) AS pagetmp ON rev_page = pagetmp.page_id
  AND rev_timestamp = (
    SELECT
      MAX(rev_timestamp)
    FROM
      revision AS last
    WHERE
      last.rev_page = pagetmp.page_id
  )

HAVING (page_title <> "CommonsRoot")
ORDER BY page_id DESC
SQL

Checking query status...
