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 * FROM 
(SELECT COUNT(page.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(log_title) FROM `logging`WHERE log_action = 'patrol' AND log_namespace = 0 AND log_timestamp > (NOW() - INTERVAL 7 DAY))
;
SQL

Checking query status...
