new pages this week

SQL

# new unreviewed article from last week
SELECT COUNT(page.page_title) FROM `page` JOIN `pagetriage_page` ON page_id = ptrp_page_id 
WHERE ptrp_reviewed = 0 AND page_namespace = 0 AND ptrp_created > (NOW() - INTERVAL 7 DAY);
SELECT COUNT(page_title) FROM `page` JOIN `pagetriage_page` ON page_id = ptrp_page_id 
WHERE ptrp_reviewed = 1 AND page_namespace = 0 AND ptrp_created > (NOW() - INTERVAL 7 DAY);
SELECT COUNT(page_title) FROM `logging`
WHERE log_action = 'patrol' AND page_namespace = 0 AND log_timestamp > (NOW() - INTERVAL 7 DAY);
SQL

Checking query status...
