Django specific sql query

Question

how can I execute such query in django:

SELECT * FROM keywords_keyword WHERE id not in (SELECT keyword_id FROM sites_pagekeyword)

In the latest SVN release we can use:

keywords = Keyword.objects.raw('SELECT * FROM keywords_keyword WHERE id not in (SELECT keyword_id FROM sites_pagekeyword)')

But RawQuerySet doesn't support filter(), count(), indexing and other things. Is there another way?

cethegeek · Accepted Answer · 2009-12-28 21:38:52Z

8

~~Keyword.objects.exclude(id__in=PageKeyword.objects.all()~~

Keyword.objects.exclude(id__in=PageKeyword.objects.values('keyword_id'))

Edit: Yes, you are right; I corrected my answer. See above.

Edit: Even more readable:

Keyword.objects.exclude(pagekeyword__in=PageKeyword.objects.all())

answered Dec 28, 2009 at 18:07

cethegeek

6,39437 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roman Dolgiy · Accepted Answer · 2009-12-28 20:55:14Z

1

I've tested your code and it works not as expected, here is the right solution for my task:

Keyword.objects.exclude(id__in=PageKeyword.objects.values('keyword_id'))

answered Dec 28, 2009 at 20:55

Roman Dolgiy

1,5311 gold badge15 silver badges21 bronze badges