Check if a page is marked as reviewed, by title and namespace

Fork of Check if a page is marked as reviewed, by page_id by Novem Linguae

This query is marked as a draft This query has been published by Novem Linguae.

Only works for pages that have an entry in this log table (usually pages less than a year old). If older than one year, assume it is marked as reviewed.

SQL

/* By page_title and page_namespace */
SELECT ptrp_reviewed
FROM pagetriage_page
JOIN page ON page_id = ptrp_page_id
/* For page_title, don't forget to use underscores instead of spaces. */
WHERE page_title = 'Živko_Kostadinović'
	AND page_namespace = 0

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...