Hi,

On the homepage of my site i display 1 main video and then the most
popular video from each of the 5 categories, which is determined by a
hit count.

Basically i need something like the following

tv_video = Video.objects.filter(category=1).order_by('-hit_count')

But i need an object returned that gets the most popular video (just
the first one) from each category (1-5)

Does someone have an idea of the most efficient way to achieve this ?

Thanks, hope i was clear.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to