work in progress

SQL

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
  GROUP BY ptrp_reviewed, day
) as tmp2 
GROUP BY day
SQL

Checking query status...
