Thursday, March 3, 2011

Re: Need help with this basic query (annotate vs aggregate)

If it helps, this is, I believe, somewhat equivalent SQL:

SELECT
playlist_id, tag, SUM(tag_count) score
FROM
playlist_tag
WHERE
tag like '%query%'
GROUP BY
playlist_id
ORDER BY
score DESC

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

No comments:

Post a Comment