work in progress

SQL

#SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF (ptrp_reviewed = 1, num, 0) AS reviewed,
#IF (ptrp_reviewed = 2, num, 0) AS patrolled,
#	IF (ptrp_reviewed = 3, num, 0) AS autopatrolled
SELECT day, MAX(unreviewed), MAX(reviewed), MAX(patrolled), MAX(autopatrolled)
FROM (
SELECT day, ptrp_reviewed, num,
IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
IF (ptrp_reviewed = 1, num, 0) AS reviewed,
IF (ptrp_reviewed = 2, num, 0) AS patrolled,
IF (ptrp_reviewed = 3, num, 0) AS autopatrolled
FROM (
  SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day, ptrp_reviewed, COUNT(*) as num
  FROM pagetriage_page 
  WHERE ptrp_created  >  (NOW() - INTERVAL 1 WEEK)
  GROUP BY ptrp_reviewed, day
) as tmp
) as tmp2
GROUP BY day
SQL

Checking query status...
