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
35300	Simple COUNT without OUTER JOIN	Chrea Chanchhunneng	nobody	"as in django query, we support `Count() in db.model` and `queryset.count()`. But the problem are `Count()` creates the `LEFT OUTER JOIN` and `queryset.count()` does not support `OuterRef(""pk"")`. 

I hope there is a way to just simply count without `LEFT OUTER JOIN` to reduce the query time."	New feature	closed	Uncategorized	4.2	Normal	invalid	reduce counting time,		Unreviewed	0	0	0	0	0	0