AC Gaming Weekdays

SQL

SELECT
user_name,
COUNT(*),
COUNT(ar_page_id)
FROM 
pagetriage_log
INNER JOIN user ON pagetriage_log.ptrl_user_id = user.user_id
LEFT OUTER 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 user_name NOT IN ('DannyS712 bot III', 'Barkeep49', 'John B123')
AND ptrl_timestamp >= '20210801000000'
AND (ar_page_id IS NULL OR ar_parent_id = 0)
GROUP BY user_name
ORDER BY COUNT(*) DESC
SQL

Checking query status...
