SQL
x
SELECT pageA.page_title
FROM page AS pageD, page AS pageA JOIN pagetriage_page ON pageA.page_id = ptrp_page_id
JOIN revision AS revisionA ON pageA.page_id = revisionA.rev_page
JOIN revision AS revisionD ON pageD.page_id = revisionD.rev_page
WHERE revisionA.rev_user = revisionD.rev_user
AND revisionA.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 ptrp_created > (NOW() - INTERVAL 30 DAY)
LIMIT 10;
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.