id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
9510	TestStats for single Testplans at 1.4.8 not working - patched	podskalsky	seccanj	There is a bug in your SQL statement!\r\nSingle TestPlan statistics are not running at 1.4.8!\r\n\r\npatched line 115 at stats.py:\r\n\r\nsql = "SELECT COUNT(*) FROM testcasehistory th1, (SELECT id, planid, max(time) as maxtime FROM testcasehistory WHERE planid = '%s' AND time > %s AND time <= %s GROUP BY '''planid,''' id) th2 WHERE th1.time = th2.maxtime AND th1.id = th2.id AND th1.planid = th2.planid AND th1.status = '%s'" % (testplan, to_any_timestamp(from_date), to_any_timestamp(at_date), status)\r\n\r\nRegards,\r\nAndreas	defect	closed	highest	TestManagerForTracPlugin	blocker	fixed			0.12