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 h1.  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(",")}