Mercurial > getan
changeset 144:9e853f9e63ad
Remove whitespace
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Tue, 13 Nov 2012 13:11:04 +0100 (2012-11-13) |
parents | 9f4da22fb1f1 |
children | ccd47a2d37a6 |
files | getan/backend.py |
diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- 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 '''