SELECT COUNT(tasks.id), tasks.locationid
FROM tasks, tasksworkflowlog, states
WHERE tasks.id = tasksid AND
  tostatesid = states.id AND
  type = 0 AND
  timestamp > 1162319400000 AND
   timestamp <= 1164825000000 AND
   states.archivedstate
GROUP BY tasks.locationid