ticket	summary	type	release	owner	status	created	modified	_description	_reporter
6693	Suggested query for checking ratings	enhancement	0.11		new	2010-02-18T21:15:29+01:00	2020-05-06T02:00:59+02:00	"As it stands, this hack creates all of the votes in a separate table. As I'm using the voting to rank tickets/bugs/features that people think are important, it is useful to get an overview of which tickets have what rating. My current query to do this is:

{{{
select id, type, summary, component, milestone, owner, (sum(v.vote)/count(v.resource))||'/5' as rating, count(v.resource) as votes
from ticket t left join fivestarvote v on 'ticket/'||t.id = v.resource
group by t.id
order by rating desc
}}}

It might be useful to include something like that in the default install, if possible, so that people can have easy access to the information."	ibboard