AC Gaming Weekdays

SQL

SELECT
*
-- user_name, ar_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 archive.ar_title = page.page_title
WHERE
TRUE
AND ptrl_reviewed = 1
AND ar_namespace = 0
-- AND page_title IS NULL
AND user_name NOT IN ('DannyS712 bot III', 'Barkeep49', 'John B123')
-- AND page_is_redirect = 0
AND ptrl_timestamp >= '20210101000000'
-- AND ptrp_deleted = 1
-- AND rev_deleted > 0 (NOT THIS)
-- AND page_id IS NULL
AND ar_title NOT LIKE '"%"' -- many bad stuff here
AND ar_parent_id = 0 -- dedup results, first rev
-- ORDER BY ptrp_reviewed_updated DESC
LIMIT 10
SQL

Checking query status...
