Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cat, dog, bird, count(1) FROM animals WHERE master_id = 1 GROUP BY cat, dog, bird
- animals = Animals.objects.filter(id=1).values('cat', 'dog', 'bird').annotate(ct=Count('cat'), dg=Count('dog'), br=Count('bird'))
- Animals.objects.filter(
- master_id=1
- ).values('cat', 'dog', 'bird').annotate(
- ct=Count('id')
- ).order_by('cat', 'dog', 'bird')
- <QuerySet [
- { 'cat': 0, 'dog': 2, 'bird': 1, 'ct': 1 },
- { 'cat': 0, 'dog': 3, 'bird': 3, 'ct': 4 },
- { 'cat': 1, 'dog': 0, 'bird': 0, 'ct': 2 },
- { 'cat': 2, 'dog': 2, 'bird': 1, 'ct': 5 },
- ]>
Add Comment
Please, Sign In to add comment