This query is marked as a draft This query has been published by Enhancing999.

SQL

x
 
/** Special:UncategorizedCategories
   Executed in 1315.26 seconds as of Fri, 13 Sep 2024 11:43:06 UTC : 110 rows
   Executed in 1875.23 seconds as of Sat, 16 Nov 2024 21:02:20 UTC : 875 rows
**/
SELECT
  REPLACE(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_title not like "%Wiki%" AND page_title not like "%wiki%"    
          AND page_id <> 15658   #  Category:CommonsRoot
  ) 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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...