Fork of
Uncategorized categories (zhwiki_p)
by Tjmj
This query is marked as a draft
This query has been published
by Enhancing999.
SQL
AخA
SELECT
page_title,
page_len,
cat_pages,
rev_timestamp,
actor_name
FROM
revision
JOIN actor ON rev_actor = actor_id
JOIN (
SELECT
page_id,
page_title,
page_len,
cat_pages
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
) 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
)
ORDER BY cat_pages DESC, page_title;
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.