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
18870	QuerySet.count() generates invalid sql when used with select_related() and extra()	bkvaiude@…	B001	"total = IntentStats.objects.filter().extra(where=['date(`intentapp_intent`.`created_at`) between \''+start_date.__str__()+'\' and \''+end_date.__str__()+'\''],tables=['intentapp_intent']).select_related('intent')

total_query=total.query
--------------------------------------------------------------------------------------------------------------
SELECT `intentapp_intentstats`.`id`, `intentapp_intentstats`.`intent_id`, `intentapp_intentstats`.`category`, `intentapp_intentstats`.`support_count`, `intentapp_intentstats`.`comment_count`, `intentapp_intentstats`.`adoption_count`, `intentapp_intentstats`.`updated_at`, `intentapp_intent`.`id`, `intentapp_intent`.`user_id`, `intentapp_intent`.`body`, `intentapp_intent`.`category`, `intentapp_intent`.`why_important`, `intentapp_intent`.`can_help`, `intentapp_intent`.`inspiration`, `intentapp_intent`.`parent_id`, `intentapp_intent`.`deleted`, `intentapp_intent`.`sponsored`, `intentapp_intent`.`fulfilled_at`, `intentapp_intent`.`created_at`, `intentapp_intent`.`updated_at`, `intentapp_intent`.`legacy_intent_id`, `intentapp_intent`.`homepage_location` FROM `intentapp_intentstats` INNER JOIN `intentapp_intent` ON (`intentapp_intentstats`.`intent_id` = `intentapp_intent`.`id`) WHERE date(`intentapp_intent`.`created_at`) between '2012-08-27' and '2012-08-28'
--------------------------------------------------------------------------------------------------------------
total=total.count() 
I got this output through django shell
Ans: 0

But when call it in my app it gives me XXX count.
SQL
--------------------------------------------------------------------------------------------------------------
SELECT COUNT(*) FROM `intentapp_intentstats` , `intentapp_intent` WHERE date(`intentapp_intent`.`created_at`) between '2012-08-27' and '2012-08-28'
--------------------------------------------------------------------------------------------------------------


Please let me any solution for above issue.

thanks in advanced."	Bug	closed	Database layer (models, ORM)	1.4	Normal	duplicate			Accepted	0	0	0	0	0	0