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.