Ticket #97 (enhancement)

Add the following to one to the appropiate model after releasing 1.04.

select p.name, p.id, COUNT(t.project_id) AS count FROM projects p, todos t 
WHERE t.project_id IS NOT NULL AND t.done=0 
AND p.done = '0' AND p.id = t.project_id GROUP BY p.id;

Consider moving the sidebar management into a seperate controller. This might allow us to set up some clever OSX/dashboard widgets or small popups.

Select the above for a list of projects by:

  p.id IN #{projectids.join(",")}