Replicas browser and optimizer
This query is marked as a draft
This query has been published
# unreviewed pages that have been reviewed before SELECT user_name reviewer, page_title FROM page JOIN pagetriage_page ON page_id = ptrp_page_id JOIN user ON ptrp_last_reviewed_by = user_id WHERE ptrp_reviewed = 0 AND ptrp_last_reviewed_by > 0 AND page_namespace = 0 AND ptrp_created > (NOW() - INTERVAL 90 DAY);
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in