AC Gaming Weekdays

SQL

SELECT
    user_name
	-- ptrp_reviewed_updated
    -- page_title
FROM 
pagetriage_page
INNER JOIN user ON pagetriage_page.ptrp_last_reviewed_by = user.user_id
INNER JOIN page ON pagetriage_page.ptrp_page_id  = page.page_id
LEFT OUTER JOIN revision ON page.page_latest = revision.rev_id
WHERE
TRUE
-- AND ptrp_reviewed = 1
-- AND page_namespace = 0
-- AND page_is_redirect = 0
AND ptrp_reviewed_updated >= '20210101000000'
-- AND ptrp_deleted = 1
AND rev_deleted > 0
ORDER BY ptrp_reviewed_updated DESC
LIMIT 1
SQL

Checking query status...
