SQL
x
#unreviewed new pages that exist as draft
SELECT pageA.page_title, log_type, log_action, log_comment, log_user_text
FROM page AS pageD JOIN page AS pageA JOIN pagetriage_page ON pageA.page_id = ptrp_page_id
JOIN revision AS revisionA ON revisionA.rev_page = pageA.page_id
JOIN revision AS revisionD ON revisionD.rev_page = pageD.page_id
JOIN logging ON pageD.page_id = log_page
WHERE revisionA.rev_user = revisionD.rev_user
AND revisionA.rev_parent_id = 0
AND revisionD.rev_parent_id = 0
AND pageA.page_namespace = 0
AND pageD.page_namespace = 118
AND pageA.page_title = pageD.page_title
AND pageA.page_is_redirect = 0
AND pageD.page_is_redirect = 0
AND ptrp_reviewed = 0
#AND pageA.page_is_new = 1
AND log_action = 'move';
# ptrp_created > (NOW() - INTERVAL 30 DAY);
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.