diff options
| author | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-15 01:40:48 -0400 |
|---|---|---|
| committer | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-15 01:40:48 -0400 |
| commit | cdff1a234be0d625c5c824707dbae32ffa6a76dd (patch) | |
| tree | a9e029f2a98ad72e64d9e09a922ec39ab502a75b /todolists/utils.py | |
| parent | f18a6c809f45e71175ced6050d7e57bf4e7e89ba (diff) | |
| parent | 90873ef7de4bf842fbf6971836a373c555cfcbaa (diff) | |
Merge branch 'master-nomake'
Diffstat (limited to 'todolists/utils.py')
| -rw-r--r-- | todolists/utils.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/todolists/utils.py b/todolists/utils.py index 7b98c887..e04c2e5e 100644 --- a/todolists/utils.py +++ b/todolists/utils.py @@ -6,7 +6,7 @@ from packages.models import Package def todo_counts(): sql = """ -SELECT todolist_id, count(*), sum(CASE WHEN status = %s THEN 1 ELSE 0 END) +SELECT todolist_id, count(*), SUM(CASE WHEN status = %s THEN 1 ELSE 0 END) FROM todolists_todolistpackage WHERE removed IS NULL GROUP BY todolist_id |