#SELECT DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 91 DAY), "%Y%m%d000000") start;

#SELECT DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 89 DAY), "%Y%m%d000000") end;

SELECT COUNT(ptrp_page_id), YEAR(ptrp_created), MONTH(ptrp_created), DAY(ptrp_created)

FROM pagetriage_page

JOIN page ON page_id = ptrp_page_id

WHERE ptrp_reviewed = 0

AND page_is_redirect = 0

AND page_namespace = 0 

#AND page_len < 500

#AND ptrp_created > DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 91 DAY), "%Y%m%d000000")

#AND ptrp_created < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 89 DAY), "%Y%m%d000000")

#ORDER BY ptrp_created ASC

GROUP BY YEAR(ptrp_created), MONTH(ptrp_created), DAY(ptrp_created)