SQL
x
DESCRIBE enwiki_p.pagetriage_page;
/*SELECT COUNT(ptrp_created), rev_user_text
FROM revision
JOIN page ON rev_page = page_id
JOIN pagetriage_page ON rev_page = ptrp_page_id
WHERE ptrp_reviewed = 0
AND page_namespace = 0
AND ptrp_created > (NOW() - INTERVAL 90 DAY)
AND rev_parent_id = 0
GROUP BY rev_user_text
ORDER BY COUNT(ptrp_created) DESC;
*/
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.