# 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`,  

       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;

​