id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30394	Mutiple annotation with Sum return wrong values.	Gouri Javed	nobody	"UserRoleAccount.objects.filter(pk='24f4a032-3f83-4123-8330-fa60fcbb880c').aggregate(
     given_count=Sum(
        Case(When(user_observations_given__group=grp, then=1),
              output_field=IntegerField())
     ),
     taken_count=Sum(
         Case(When(user_observations_taken__group=grp, then=1),
              output_field=IntegerField())
     )
 )"	Bug	new	Database layer (models, ORM)	2.2	Normal				Unreviewed	0	0	0	0	0	0