SQL
AخA
SELECT page_title, rev_timestamp, page_latest, page_len, actor_name, user_editcount
FROM pagetriage_page
JOIN page on page_id = ptrp_page_id
JOIN revision ON page_id = rev_page AND rev_parent_id = 0
JOIN actor ON rev_actor = actor_id
LEFT JOIN user ON user_id = actor_user
WHERE page_namespace = 0
AND page_is_redirect = 0
AND ptrp_reviewed = 0
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.