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) AS triaged
      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) AS patrolled
      FROM `logging`WHERE log_action = 'patrol' 
      AND log_namespace = 0 AND log_timestamp > (NOW() - INTERVAL 7 DAY)
    ) 
;
SQL

Checking query status...
