unreferenced, reviewed articles

SQL

# unreviewed pages with templates
SELECT EXTRACT(YEAR FROM DATE_FORMAT(ptrp_created,'%Y%m%d%H%i%s')) AS `year`,
       EXTRACT(MONTH FROM DATE_FORMAT(ptrp_created,'%Y%m%d%H%i%s')) AS `month`,
       EXTRACT(DAY FROM DATE_FORMAT(ptrp_created,'%Y%m%d%H%i%s')) AS `day`,  
       COUNT(DISTINCT page_title) AS pages
FROM templatelinks JOIN page ON tl_from = page_id JOIN pagetriage_page ON page_id = ptrp_page_id 
WHERE 
tl_namespace = 10
AND tl_title = 'Unreferenced'
AND ptrp_reviewed = 1
AND page_namespace = 0
#AND ptrp_created BETWEEN (NOW() - INTERVAL 30 DAY) AND (NOW() - INTERVAL 7 DAY)
GROUP BY `year`, `month`, `day`
ORDER BY `year` ASC, `month` ASC, `day` ASC;
SQL

Checking query status...
