AC Gaming Weekdays

SQL

SELECT
*
    -- user_name
	-- ptrp_reviewed_updated
    -- page_title
FROM 
pagetriage_log
INNER JOIN user ON pagetriage_log.ptrl_user_id = user.user_id
INNER JOIN archive ON pagetriage_log.ptrl_page_id = archive.ar_page_id
-- LEFT OUTER JOIN page ON pagetriage_log.ptrl_page_id  = page.page_id
-- LEFT OUTER JOIN revision ON page.page_latest = revision.rev_id
WHERE
TRUE
AND ptrl_reviewed = 1
AND ar_namespace = 0
-- AND page_is_redirect = 0
AND ptrl_timestamp >= '20210101000000'
-- AND ptrp_deleted = 1
-- AND rev_deleted > 0 (NOT THIS)
-- AND page_id IS NULL
-- ORDER BY ptrp_reviewed_updated DESC
LIMIT 1
SQL

Checking query status...
