SQL
AخA
SELECT
page_title,
page_len,
cat_pages,
rev_timestamp
,rev_actor
/* ,rev_user_text */
FROM revision
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);
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.