# HG changeset patch # User Daniele Nicolodi # Date 1319652792 -7200 # Node ID 2429e9db4f34c0cf9761e44015c707ff9d38e802 # Parent 49ae14f1eaef0931d6989934da8b531460916561 Fix activity view. diff -r 49ae14f1eaef -r 2429e9db4f34 src/ltpdarepo/views/browse.py --- a/src/ltpdarepo/views/browse.py Tue Oct 25 23:00:17 2011 +0200 +++ b/src/ltpdarepo/views/browse.py Wed Oct 26 20:13:12 2011 +0200 @@ -605,7 +605,7 @@ # collect number of objects for each interval curs.execute("""SELECT ts.begin AS date, COUNT(objmeta.obj_id) AS count - FROM ltpda.timeintervals AS ts + FROM timeintervals AS ts LEFT OUTER JOIN `%s`.objmeta ON (objmeta.submitted BETWEEN ts.begin AND ts.end) GROUP BY ts.begin, ts.end""" % database)