# HG changeset patch # User Björn Ricks # Date 1352808664 -3600 # Node ID 9e853f9e63ad853b7ddfdf7d8a3dc5edc1aa3022 # Parent 9f4da22fb1f17b9da21bb627860b303a580acaaf Remove whitespace diff -r 9f4da22fb1f1 -r 9e853f9e63ad getan/backend.py --- a/getan/backend.py Tue Nov 13 13:10:48 2012 +0100 +++ b/getan/backend.py Tue Nov 13 13:11:04 2012 +0100 @@ -46,10 +46,10 @@ LOAD_ACTIVE_PROJECTS = ''' SELECT id, key, description, total FROM projects LEFT JOIN -(SELECT - project_id, +(SELECT + project_id, sum(strftime('%s', stop_time) - strftime('%s', start_time)) AS total - FROM entries + FROM entries GROUP BY project_id) ON project_id = id WHERE active '''