Unreviewed articles by day

Fork of Not brand new unreviewed and unindexed articles by SunloungerFrog

This query is marked as a draft This query has been published by SunloungerFrog.

SQL

#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)

SQL

Checking query status...