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 ptrl_reviewed
FROM pagetriage_log
JOIN page ON page_id = ptrl_page_id
WHERE page_title = 'Živko Kostadinović'
	AND page_namespace = 0
ORDER BY ptrl_timestamp DESC
LIMIT 1;

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...